View: MSC_ORG_SEC_RESP_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_ORG_SEC_RESP_V

View Text

SELECT TL.RESPONSIBILITY_NAME
, TL.RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY RESP
, FND_RESPONSIBILITY_TL TL
, FND_APPLICATION APPL
WHERE APPL.APPLICATION_SHORT_NAME = 'MSC'
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')

Columns