--Lists the responsibilities to which a CP is attached
SELECT RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL FR, FND_REQUEST_GROUPS FRG
WHERE FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID
AND FR.REQUEST_GROUP_ID IN (SELECT REQUEST_GROUP_ID FROM FND_REQUEST_GROUP_UNITS FRU, FND_CONCURRENT_PROGRAMS_VL FC
WHERE FRU.REQUEST_UNIT_ID =FC.CONCURRENT_PROGRAM_ID
AND FC.USER_CONCURRENT_PROGRAM_NAME = :ConProgram_Name)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment