Concurrent Program Executable

SELECT DISTINCT fcpt.user_concurrent_program_name ,
fcp.concurrent_program_name short_name ,
fat.application_name program_application_name ,
fet.executable_name ,
fat1.application_name executable_application_name ,
flv.meaning execution_method ,
fet.execution_file_name ,
FCP.ENABLE_TRACE
FROM APPS.FND_CONCURRENT_PROGRAMS_TL FCPT ,
APPS.FND_CONCURRENT_PROGRAMS FCP ,
APPS.FND_APPLICATION_TL FAT ,
APPS.FND_EXECUTABLES FET ,
APPS.FND_APPLICATION_TL FAT1 ,
apps.FND_LOOKUP_VALUES FLV
WHERE 1 =1
AND fcpt.user_concurrent_program_name=:p_program_name
AND fcpt.concurrent_program_id = fcp.concurrent_program_id
AND fcpt.application_id = fcp.application_id
AND fcp.application_id = fat.application_id
AND fcpt.application_id = fat.application_id
AND fcp.executable_id = fet.executable_id
AND fcp.executable_application_id = fet.application_id
AND fet.application_id = fat1.application_id
AND FLV.LOOKUP_CODE = FET.EXECUTION_METHOD_CODE
AND FCPT.LANGUAGE =FAT.LANGUAGE
AND FCPT.LANGUAGE =Flv.LANGUAGE
AND fcpt.language =userenv(‘LANG’)
AND FLV.LOOKUP_TYPE =’CP_EXECUTION_METHOD_CODE’ ;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s