View: MSC_SELECTED_ORGS_V

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

View Text

SELECT LTRIM(RTRIM(MSC_GET_NAME.ORG_CODE(ACC.ORGANIZATION_ID
, ACC.SR_INSTANCE_ID)))
, TO_CHAR(ACC.ORGANIZATION_ID) || ':' || TO_CHAR(ACC.SR_INSTANCE_ID)
, ACC.RESPONSIBILITY_ID
, ACC.ORGANIZATION_ID
, ACC.SR_INSTANCE_ID
FROM MSC_ORG_ACCESS ACC
, FND_APPLICATION APPL
WHERE SYSDATE >= NVL(ACC.EFFECTIVE_FROM_DATE
, SYSDATE)
AND SYSDATE <= NVL(ACC.EFFECTIVE_TO_DATE
, SYSDATE)
AND ACC.RESP_APPLICATION_ID = APPL.APPLICATION_ID
AND APPL.APPLICATION_SHORT_NAME ='MSC' ORDER BY LTRIM(RTRIM(MSC_GET_NAME.ORG_CODE(ACC.ORGANIZATION_ID
, ACC.SR_INSTANCE_ID)))

Columns