Tuesday, 13 March 2012

To Print the Concurrent Program Name,Concurrent Program Short Name,Executable Short Name,Executable Name

select fcpl.user_concurrent_program_name     
    , fcp.concurrent_program_name
  , fe.executable_name executableshortname
  , fe.execution_file_name
  --, fe.execution_method_code
from fnd_concurrent_programs fcp    
     , fnd_concurrent_programs_tl fcpl
   ,fnd_executables fe
WHERE    fcp.concurrent_program_id = fcpl.concurrent_program_id
      AND fcp.executable_id = fe.executable_id
      AND    fcpl.user_concurrent_program_name
      in ('Trial Balance - Summary 1',
          'Trial Balance - Detail',
          ,'India - Cash/Bank Book Report',
          ,'India - Debtors Ledger Report',
          'Inter Company Receipts Report',
          'Accounts Payable Trial Balance',
          'Approval of TDS and Credit Memo',
          'Final Payment Register',
          'Payables Transfer to General Ledger',
          'Supplier Payment History',
          'Payables Accounting Process',
          'Invoice Validation',
          'Invoice Approval Workflow',
          'India - Creditors Trial Balance Report',
          'Asset Retirements Report',
          'Journal Entry Reserve Ledger Report'         )

No comments:

Post a Comment