Tuesday, August 2, 2011

Concurrent program Queries

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')

1 comment:

Rahul Aahir said...

can you enable copy options, it would be easy use.

Post a Comment

Best Blogger TipsGet Flower Effect