Tuesday 13 March 2012

To Print the Concurrent Program Name & Short Name,Executable Short Name,Executable Name,Application short Name,application top,application name

select fcpl.user_concurrent_program_name     
    , fcp.concurrent_program_name
  , fe.executable_name executableshortname
  , fe.execution_file_name, fe.application_id , fa.application_short_name,fa.basepath,fa.product_code
  --, fe.execution_method_code
from fnd_concurrent_programs fcp    
     , fnd_concurrent_programs_tl fcpl
   ,fnd_executables fe,fnd_application fa
WHERE    fcp.concurrent_program_id = fcpl.concurrent_program_id
      AND fcp.executable_id = fe.executable_id
      AND fe.application_id = fa.application_id
      AND    fcpl.user_concurrent_program_name
in ('Trial Balance - Summary 1',
          'Trial Balance - Detail',
'Accounts Payable Trial Balance',
          'Approval of TDS and Credit Memo',
          'Final Payment Register')

No comments:

Post a Comment