Wednesday, 19 June 2013

find the custom opject querie

/* Formatted on 6/19/2013 12:15:15 PM (QP5 v5.114.809.3010) */
SELECT   user_concurrent_program_name "Program",
         concurrent_program_name "Short Name",
         application_name "Application",
         fcp.description,
         executable_name,
         execution_file_name,
         fl1.meaning "Execution Method",
         output_file_type,
         application_short_name,
         basepath
  FROM   fnd_executables fne,
         fnd_application_vl fapl,
         fnd_concurrent_programs_vl fcp,
         fnd_lookups fl1
 WHERE       1 = 1
         AND fne.application_id = fapl.application_id
         AND fcp.application_id = fapl.application_id
         AND fne.EXECUTABLE_ID = fcp.EXECUTABLE_ID
         AND fcp.execution_method_code = fl1.lookup_code(+)
         AND fl1.lookup_type = 'CP_EXECUTION_METHOD_CODE'
         AND fapl.application_short_name = : custom_path

No comments:

Post a Comment