Custom Program LDT Download and Upload

SELECT ftl.user_concurrent_program_name, fcp.concurrent_program_name,
fe.execution_file_name, fe.execution_method_code,
‘FNDLOAD apps/password O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct ‘
|| fcp.concurrent_program_name
|| ‘.ldt ‘
|| ‘PROGRAM APPLICATION_SHORT_NAME=’
|| ””
|| fa.application_short_name
|| ””
|| ‘ CONCURRENT_PROGRAM_NAME=’
|| ””
|| fcp.concurrent_program_name
|| ”” ldt_download,
‘FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct ‘
|| fcp.concurrent_program_name
|| ‘.ldt’
|| ‘ – WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE’
ldt_upload
FROM fnd_concurrent_programs_tl ftl,
fnd_concurrent_programs fcp,
fnd_executables fe,
fnd_application fa
WHERE ftl.concurrent_program_id = fcp.concurrent_program_id
AND ftl.application_id = fa.application_id
AND fe.application_id = ftl.application_id
AND fe.executable_id = fcp.executable_id
AND ftl.user_concurrent_program_name LIKE ‘XX%’
AND fcp.enabled_flag = ‘Y’
ORDER BY fe.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