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