View: MSC_AVAILABLE_ORGS_V

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

View Text

SELECT LTRIM(RTRIM(PT.ORGANIZATION_CODE))
, TO_CHAR(PT.SR_TP_ID) || ':' || TO_CHAR(PT.SR_INSTANCE_ID)
, RESP.RESPONSIBILITY_ID
FROM MSC_TRADING_PARTNERS PT
, MSC_APPS_INSTANCES AI
, FND_RESPONSIBILITY RESP
, FND_APPLICATION APPL
WHERE PT.SR_INSTANCE_ID = AI.INSTANCE_ID
AND AI.ENABLE_FLAG = '1'
AND PT.PARTNER_TYPE= 3
AND NOT EXISTS (SELECT 'X'
FROM MSC_ORG_ACCESS ACC
WHERE ACC.ORGANIZATION_ID = PT.SR_TP_ID
AND ACC.SR_INSTANCE_ID = PT.SR_INSTANCE_ID
AND ACC.RESPONSIBILITY_ID= RESP.RESPONSIBILITY_ID
AND ACC.RESP_APPLICATION_ID = APPL.APPLICATION_ID
AND SYSDATE >= NVL(ACC.EFFECTIVE_FROM_DATE
, SYSDATE)
AND SYSDATE <= NVL(ACC.EFFECTIVE_TO_DATE
, SYSDATE) )
AND RESP.APPLICATION_ID = APPL.APPLICATION_ID
AND APPL.APPLICATION_SHORT_NAME = 'MSC' ORDER BY LTRIM(RTRIM(PT.ORGANIZATION_CODE))

Columns