SELECT DISTINCT frt.responsibility_name
,frg.request_group_name
,frgu.request_unit_type
,frgu.request_unit_id
,fcpt.user_concurrent_program_name
FROM fnd_responsibility fr
,fnd_responsibility_tl frt
,fnd_request_groups frg
,fnd_request_group_units frgu
,fnd_concurrent_programs_tl fcpt
WHERE frt.responsibility_id = fr.responsibility_id
AND frg.request_group_id = fr.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND fcpt.concurrent_program_id = frgu.request_unit_id
AND UPPER(fcpt.user_concurrent_program_name) = UPPER(:p_concurrent_program)
ORDER BY frt.responsibility_name
Subscribe to:
Post Comments (Atom)
Query to get the Concurrent Program along with Value Set details
SELECT fcpl1.user_concurrent_program_name ,fdfcuv.end_user_column_name ,ffvs.flex_value_set_name value_set_name ,ffvt.appl...
-
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
-
SELECT HAOU.NAME "Operating Unit", OTTT_H.NAME "Transaction Type", OTTT_H.DESCRIPTION "Descripti...
-
Serial_number_control_code column contains values as 1,2,5 &6 in mtl_system_items_b table. Inorder to find meaning for this values r...
No comments:
Post a Comment