Srinivas's Page

This sql will take Concurent Program name as a parameter:

SELECT *
FROM fnd_responsibility
WHERE request_group_id IN (
SELECT request_group_id
FROM fnd_request_groups
WHERE request_group_id IN (
SELECT request_group_id
FROM fnd_request_group_units
WHERE request_unit_id = (select CONCURRENT_PROGRAM_ID from fnd_concurrent_programs where user_concurrent_program_name like :p)))

This query will take table name as Parameter:







SELECT owner, object_type, object_name, object_id, status,

DECODE (REPLACE (object_type, ' ', '_'),

'PACKAGE_BODY', 'PACKAGE',

REPLACE (object_type, ' ', '_')

) type_link

FROM SYS.all_objects

WHERE object_id IN (

SELECT object_id

FROM public_dependency

CONNECT BY PRIOR object_id = referenced_object_id

START WITH referenced_object_id =

(SELECT object_id

FROM… Continue