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 Parent and Child Accounts in Oracle APPS R12
SELECT ffv1.flex_value parent_account ,ffvt1.description parent_account_desc ,ffv2.flex_value child_account ,ffvt2.description...
-
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...
-
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...
-
LOT_CONTROL_CODE column contains values as 1 & 2 in mtl_system_items_b table. Inorder to find meaning for this values run below que...
No comments:
Post a Comment