Tuesday 5 March 2013

Query to findout the Package name from CP or CP name from Package

SELECT fcpt.user_concurrent_program_name concurrent_program_name,
  fcp.concurrent_program_name cp_short_name,
  fet.user_executable_name executable_name,
  fe.executable_name executable_short_name,
  fet.description description,
  fe.execution_file_name execution_file_name
FROM APPS.FND_EXECUTABLES fe,
  APPS.FND_EXECUTABLES_tl fet,
  APPS.FND_CONCURRENT_PROGRAMS fcp,
  APPS.fnd_concurrent_programs_tl fcpt
WHERE fet.application_id      = fe.application_id
AND fet.executable_id         = fe.executable_id
AND fcp.application_id        = fe.application_id
AND fcp.executable_id         = fe.executable_id
AND fcp.application_id        = fcpt.application_id
AND fcp.concurrent_program_id = fcpt.concurrent_program_id
  --AND fe.execution_file_name LIKE '%AR_INBOUND_INTERFACE_PKG%'
AND fcpt.user_concurrent_program_name LIKE '%AR Contact Inbound Interface%';

No comments:

Post a Comment