SELECT rs.user_request_set_name ,
rs.request_set_name,
rs.description ,
rss.display_sequence Seq,
cp.user_concurrent_program_name ,
ap.application_name ,
e.executable_name ,
e.execution_file_name ,
lv. meaning
FROM apps.fnd_request_sets_vl rs,
apps.fnd_req_set_stages_form_v rss,
applsys.fnd_request_set_programs rsp,
apps.fnd_concurrent_programs_vl cp,
apps.fnd_executables e,
apps.fnd_lookup_values lv,
apps.fnd_application_vl ap
WHERE rs.application_id = rss.set_application_id
AND rs.request_set_id = rss.request_set_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 e.application_id =ap.application_id
AND lv.lookup_code = e.execution_method_code
AND lv.language ='US'
AND ap.application_name = 'Order Management';
rs.request_set_name,
rs.description ,
rss.display_sequence Seq,
cp.user_concurrent_program_name ,
ap.application_name ,
e.executable_name ,
e.execution_file_name ,
lv. meaning
FROM apps.fnd_request_sets_vl rs,
apps.fnd_req_set_stages_form_v rss,
applsys.fnd_request_set_programs rsp,
apps.fnd_concurrent_programs_vl cp,
apps.fnd_executables e,
apps.fnd_lookup_values lv,
apps.fnd_application_vl ap
WHERE rs.application_id = rss.set_application_id
AND rs.request_set_id = rss.request_set_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 e.application_id =ap.application_id
AND lv.lookup_code = e.execution_method_code
AND lv.language ='US'
AND ap.application_name = 'Order Management';
No comments:
Post a Comment