View: MSC_NET_PLANS_V2

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

View Text

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

Columns