EBS SQL --> Form & Report

weixin_34402090發表於2013-05-28
--How to use script to get all oracle EBS Form name and corresponding fmb file name .
  SELECT fff.function_name
       , ff.form_name
       , ffft.user_function_name
       , fff.function_id
       , ff.form_id
       , fff.application_id
    FROM fnd_form ff
       , fnd_form_functions fff
       , fnd_form_functions_tl ffft
   WHERE     1 = 1
         AND ff.form_id = fff.form_id
         AND fff.function_id = ffft.function_id
         AND ffft.language = 'US'
         AND fff.application_id = 401    --Inventory Module
ORDER BY ffft.user_function_name;


--How to use script to get all Oracle EBS Concurrent Program/Report name and corresponding execution f .
  SELECT fcp.concurrent_program_name
       , fcpt.user_concurrent_program_name
       , fcp.execution_method_code
       , flv.meaning
    FROM fnd_concurrent_programs fcp
       , fnd_concurrent_programs_tl fcpt
       , fnd_lookup_values flv
   WHERE     1 = 1
         AND fcp.concurrent_program_id = fcpt.concurrent_program_id
         AND flv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
         AND fcp.execution_method_code = flv.lookup_code
         AND fcpt.language = 'US'
         AND flv.language = 'US'
         AND fcp.application_id = 401   --Inventory Module
ORDER BY fcpt.user_concurrent_program_name;

相關文章