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...
-
SELECT HAOU.NAME "Operating Unit", OTTT_H.NAME "Transaction Type", OTTT_H.DESCRIPTION "Descripti...
-
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...
-
GL tables are linked to Subledger Accounting (XLA tables). Regarding gl_import_references, there is a one-to-one correspondence between X...
No comments:
Post a Comment