Responsibilities to which assigned:
SELECT DISTINCT *
FROM fnd_responsibility_tl
WHERE responsibility_id IN
(SELECT responsibility_id
FROM fnd_responsibility_vl
WHERE request_group_id IN
(SELECT request_group_id
FROM fnd_request_group_units
WHERE request_unit_id =
(SELECT DISTINCT concurrent_program_id
FROM fnd_concurrent_programs_tl
WHERE user_concurrent_program_name = 'XXXX'))
AND end_date IS NULL)
AND "LANGUAGE" LIKE 'US'
ORDER BY responsibility_name
Application name:
SELECT *
FROM fnd_application "application name"
WHERE application_id IN
(SELECT application_id
FROM fnd_request_group_units
WHERE request_unit_id =
(SELECT DISTINCT concurrent_program_id
FROM fnd_concurrent_programs_tl
WHERE user_concurrent_program_name = 'XXX'))
Concurrent program short name:
SELECT *
FROM fnd_concurrent_programs
WHERE concurrent_program_id = (SELECT DISTINCT concurrent_program_id
FROM fnd_concurrent_programs_tl
WHERE user_concurrent_program_name = 'XXX')
Execution file name:
SELECT *
FROM fnd_executables
WHERE executable_id =
(SELECT executable_id
FROM fnd_concurrent_programs
WHERE concurrent_program_id =
(SELECT DISTINCT concurrent_program_id
FROM fnd_concurrent_programs_tl
WHERE user_concurrent_program_name = 'XXX'))
Requests groups:
SELECT *
FROM fnd_request_groups "requests groups"
WHERE request_group_id IN
(SELECT request_group_id
FROM fnd_request_group_units
WHERE request_unit_id =
(SELECT DISTINCT concurrent_program_id
FROM fnd_concurrent_programs_tl
WHERE user_concurrent_program_name = 'XXXX')
🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88
💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com
Tuesday, August 2, 2011
Subscribe to:
Post Comments (Atom)
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
1 comment:
can you enable copy options, it would be easy use.
Post a Comment