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)
APEX$TASK_PK
APEX$TASK_PK is a substitution string holding the primary key value of the system of records
-
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...
-
SELECT aca.check_number ,aia.invoice_id ,aia.invoice_num ,aia.invoice_amount ,distribution_line_number ,aida.accrual_p...
No comments:
Post a Comment