Monday, 27 June 2011

To Find in which "Request group " the Particular Concurrent is Registered

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

No comments:

Post a Comment