SELECT fcpt.user_concurrent_program_name,
fcp.CONCURRENT_PROGRAM_NAME,
fe.execution_file_name,
eflv.meaning execution_method
FROM apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_concurrent_programs fcp,
apps.fnd_executables fe,
apps.fnd_lookup_values eflv
WHERE 1 = 1
AND fcpt.concurrent_program_id = fcp.concurrent_program_id
AND fcp.executable_id = fe.executable_id
AND fe.execution_method_code = eflv.lookup_code
AND eflv.language = 'US'
AND eflv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND fcpt.user_concurrent_program_name LIKE '%XX%'
fcp.CONCURRENT_PROGRAM_NAME,
fe.execution_file_name,
eflv.meaning execution_method
FROM apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_concurrent_programs fcp,
apps.fnd_executables fe,
apps.fnd_lookup_values eflv
WHERE 1 = 1
AND fcpt.concurrent_program_id = fcp.concurrent_program_id
AND fcp.executable_id = fe.executable_id
AND fe.execution_method_code = eflv.lookup_code
AND eflv.language = 'US'
AND eflv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND fcpt.user_concurrent_program_name LIKE '%XX%'
No comments:
Post a Comment