VIEW: APPS.MSC_ORG_SEC_RESP_V

Source

View Text - Preformatted

SELECT TL.RESPONSIBILITY_NAME, TL.RESPONSIBILITY_ID FROM FND_RESPONSIBILITY RESP, FND_RESPONSIBILITY_TL TL, FND_APPLICATION APPL WHERE APPL.APPLICATION_SHORT_NAME in ( 'MSC', 'MSD') AND APPL.APPLICATION_ID = RESP.APPLICATION_ID AND RESP.RESPONSIBILITY_ID = TL.RESPONSIBILITY_ID AND SYSDATE BETWEEN RESP.START_DATE AND NVL(RESP.END_DATE, SYSDATE) AND TL.LANGUAGE = USERENV('LANG') UNION ALL SELECT TL.RESPONSIBILITY_NAME, TL.RESPONSIBILITY_ID FROM FND_RESPONSIBILITY RESP, FND_RESPONSIBILITY_TL TL WHERE RESP.RESPONSIBILITY_ID = TL.RESPONSIBILITY_ID AND SYSDATE BETWEEN RESP.START_DATE AND NVL(RESP.END_DATE, SYSDATE) AND TL.LANGUAGE = USERENV('LANG') AND RESP.MENU_ID in (select fm.menu_id from fnd_menus fm, fnd_menus fm1, fnd_menu_entries fme where fm.menu_id = fme.menu_id and fm1.menu_name = 'MSC_SCP_4.0' and fm1.menu_id = fme.sub_menu_id )

View Text - HTML Formatted

SELECT TL.RESPONSIBILITY_NAME
, TL.RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY RESP
, FND_RESPONSIBILITY_TL TL
, FND_APPLICATION APPL
WHERE APPL.APPLICATION_SHORT_NAME IN ( 'MSC'
, 'MSD')
AND APPL.APPLICATION_ID = RESP.APPLICATION_ID
AND RESP.RESPONSIBILITY_ID = TL.RESPONSIBILITY_ID
AND SYSDATE BETWEEN RESP.START_DATE
AND NVL(RESP.END_DATE
, SYSDATE)
AND TL.LANGUAGE = USERENV('LANG') UNION ALL SELECT TL.RESPONSIBILITY_NAME
, TL.RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY RESP
, FND_RESPONSIBILITY_TL TL
WHERE RESP.RESPONSIBILITY_ID = TL.RESPONSIBILITY_ID
AND SYSDATE BETWEEN RESP.START_DATE
AND NVL(RESP.END_DATE
, SYSDATE)
AND TL.LANGUAGE = USERENV('LANG')
AND RESP.MENU_ID IN (SELECT FM.MENU_ID
FROM FND_MENUS FM
, FND_MENUS FM1
, FND_MENU_ENTRIES FME
WHERE FM.MENU_ID = FME.MENU_ID
AND FM1.MENU_NAME = 'MSC_SCP_4.0'
AND FM1.MENU_ID = FME.SUB_MENU_ID )