Wednesday, 23 August 2017

Query to fetch Concurrent Program and executables details

SELECT
  fcpv.user_concurrent_program_name program_name,
  fcpv.concurrent_program_name program_short_name,
  fat.application_name program_application_name,
  fcpv.description program_description,
  fe.executable_name ,
  fe.execution_file_name ,
  DECODE( fe.execution_method_code, 'I', 'PLSQL Stored Procedure', 'P',
  'Report', 'L', 'SQL Loader','Q','SQL*Plus', fe.execution_method_code)
  execution_method,
  fu.user_name created_by,
  fcpv.creation_date
FROM
  fnd_executables fe,
  fnd_application_tl fat,
  fnd_concurrent_programs_vl fcpv,
  fnd_user fu
WHERE
  1                   =1
AND fe.application_id = fat.application_id
AND fe.executable_id  = fcpv.executable_id
AND fat.language      ='US'
AND fu.user_id        = fcpv.created_by
AND fcpv.user_concurrent_program_name LIKE 'Trial Balance';


No comments:

Post a Comment

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...