View: MSC_NET_PLANS_V

Product:	MSC - Advanced Supply Chain Planning
Description:	to display the plan LOV in the from plan of Plan Comparison Reports
Implementation/DBA Data:	APPS.MSC_NET_PLANS_V

View Text

SELECT MP.PLAN_ID
, MP.COMPILE_DESIGNATOR
, MP.DESCRIPTION
, MP.PLAN_TYPE
, MP.LAST_UPDATE_DATE
, MP.LAST_UPDATED_BY
, MP.CREATION_DATE
, MP.CREATED_BY
, MP.LAST_UPDATE_LOGIN
FROM MSC_PLANS MP
WHERE MP.PLAN_COMPLETION_DATE IS NOT NULL
AND MP.DATA_COMPLETION_DATE IS NOT NULL
AND MP.PLAN_ID <> -1
AND EXISTS (SELECT 1
FROM MSC_NEC_COMPARE_PLANS MNCP
WHERE (MNCP.FROM_PLAN = MP.PLAN_ID OR MNCP.TO_PLAN = MP.PLAN_ID)
AND MNCP.COMPARE_COMPLETION_DATE IS NOT NULL)

Columns