View: EDW_PLAN_NAME_FKV

Product:	ISC - Supply Chain Intelligence
Description:	This view can be used by fact views to derive Plan Name dimension foreign keys
Implementation/DBA Data:	APPS.EDW_PLAN_NAME_FKV

View Text

SELECT MPL.COMPILE_DESIGNATOR||'-'||MPL.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE
, MPL.COMPILE_DESIGNATOR
, MPL.ORGANIZATION_ID
FROM MFG_LOOKUPS ML1
, MTL_PARAMETERS MP
, MRP_PLANS MPL
, EDW_LOCAL_INSTANCE INST
WHERE ML1.LOOKUP_TYPE = 'MRP_PLAN_TYPE'
AND ML1.LOOKUP_CODE = MPL.PLAN_TYPE
AND MP.ORGANIZATION_ID=MPL.ORGANIZATION_ID
AND MPL.PLAN_COMPLETION_DATE IS NOT NULL

Columns