--Query to get Request Set Information with Request Group
SELECT rs.user_request_set_name Request_Set_Name
,rss.display_sequence Seq
,cp.user_concurrent_program_name Concurrent_Program_Name
,frg.request_group_name
,e.EXECUTABLE_NAME
,e.execution_file_name
,lv.meaning file_type
,fat.application_name Application_Name
,fa.application_short_name Application_Short_Name
,fat.application_name application_name
FROM fnd_request_sets_vl rs
,fnd_req_set_stages_form_v rss
,fnd_request_set_programs rsp
,fnd_concurrent_programs_vl cp
,fnd_executables e
,fnd_lookup_values lv
,fnd_application_tl fat
,fnd_request_group_units frgu
,fnd_request_groups frg
,fnd_application fa
WHERE 1=1
AND rs.application_id = rss.set_application_id
AND fa.application_id = fat.application_id
AND rs.request_set_id = rss.request_set_id
AND e.APPLICATION_ID =FAT.APPLICATION_ID
AND rss.set_application_id = rsp.set_application_id
AND rss.request_set_id = rsp.request_set_id
AND rss.request_set_stage_id = rsp.request_set_stage_id
AND rsp.program_application_id = cp.application_id
AND rsp.concurrent_program_id = cp.concurrent_program_id
AND cp.executable_id = e.executable_id
AND cp.executable_application_id = e.application_id
AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND lv.lookup_code = e.execution_method_code
AND lv.language = 'US'
AND fat.language = 'US'
AND rs.end_date_active IS NULL
AND rs.request_set_id = frgu.request_unit_id
AND frgu.request_group_id = frg.request_group_id
AND rs.user_request_set_name = :P_REQUEST_SET_NAME
ORDER BY 1;
SELECT rs.user_request_set_name Request_Set_Name
,rss.display_sequence Seq
,cp.user_concurrent_program_name Concurrent_Program_Name
,frg.request_group_name
,e.EXECUTABLE_NAME
,e.execution_file_name
,lv.meaning file_type
,fat.application_name Application_Name
,fa.application_short_name Application_Short_Name
,fat.application_name application_name
FROM fnd_request_sets_vl rs
,fnd_req_set_stages_form_v rss
,fnd_request_set_programs rsp
,fnd_concurrent_programs_vl cp
,fnd_executables e
,fnd_lookup_values lv
,fnd_application_tl fat
,fnd_request_group_units frgu
,fnd_request_groups frg
,fnd_application fa
WHERE 1=1
AND rs.application_id = rss.set_application_id
AND fa.application_id = fat.application_id
AND rs.request_set_id = rss.request_set_id
AND e.APPLICATION_ID =FAT.APPLICATION_ID
AND rss.set_application_id = rsp.set_application_id
AND rss.request_set_id = rsp.request_set_id
AND rss.request_set_stage_id = rsp.request_set_stage_id
AND rsp.program_application_id = cp.application_id
AND rsp.concurrent_program_id = cp.concurrent_program_id
AND cp.executable_id = e.executable_id
AND cp.executable_application_id = e.application_id
AND lv.lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND lv.lookup_code = e.execution_method_code
AND lv.language = 'US'
AND fat.language = 'US'
AND rs.end_date_active IS NULL
AND rs.request_set_id = frgu.request_unit_id
AND frgu.request_group_id = frg.request_group_id
AND rs.user_request_set_name = :P_REQUEST_SET_NAME
ORDER BY 1;
No comments:
Post a Comment