SELECT EXECUTABLE_NAME
,EXECUTION_FILE_NAME
,APPLICATION_SHORT_NAME
, fcpl.user_concurrent_program_ name
, fcp.concurrent_program_name
, par.end_user_column_name
, par.form_left_prompt prompt
, par.enabled_flag
, par.required_flag
, par.display_flag
FROM fnd_concurrent_programs fcp
, fnd_concurrent_programs_tl fcpl
, fnd_descr_flex_col_usage_vl par
, FND_EXECUTABLES fe
,fnd_application fa
WHERE fcp.concurrent_program_id = fcpl.concurrent_program_id
AND fcpl.user_concurrent_program_ name ='India - Debtors Trial Balance Report'
AND fcpl.LANGUAGE = 'US'
AND par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
and fe.application_id=fa. application_id
and fe.EXECUTABLE_ID = fcp.executable_id
,EXECUTION_FILE_NAME
,APPLICATION_SHORT_NAME
, fcpl.user_concurrent_program_
, fcp.concurrent_program_name
, par.end_user_column_name
, par.form_left_prompt prompt
, par.enabled_flag
, par.required_flag
, par.display_flag
FROM fnd_concurrent_programs fcp
, fnd_concurrent_programs_tl fcpl
, fnd_descr_flex_col_usage_vl par
, FND_EXECUTABLES fe
,fnd_application fa
WHERE fcp.concurrent_program_id = fcpl.concurrent_program_id
AND fcpl.user_concurrent_program_
AND fcpl.LANGUAGE = 'US'
AND par.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name
and fe.application_id=fa.
and fe.EXECUTABLE_ID = fcp.executable_id
No comments:
Post a Comment