Product: | ISC - Supply Chain Intelligence |
---|---|
Description: | This is the collection view for the Plan Name level of the Plan Name dimension |
Implementation/DBA Data: | APPS.EDW_MRP_PNDM_PLN_LCV |
SELECT MPL.COMPILE_DESIGNATOR||'-'||MPL.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE
, MPL.PLAN_COMPLETION_DATE
, MPL.CREATION_DATE
, MPL.DESCRIPTION
, MPL.CONSIDER_PO
, MPL.CONSIDER_WIP
, INST.INSTANCE_CODE
, MPL.LAST_UPDATE_DATE
, MPL.COMPILE_DESIGNATOR||'('||MP.ORGANIZATION_CODE||')'
, MPL.CUTOFF_DATE
, MPL.COMPILE_DESIGNATOR||'('||MP.ORGANIZATION_CODE||')'
, MPL.COMPILE_DESIGNATOR||'-'||MP.ORGANIZATION_CODE||'-'||INST.INSTANCE_CODE
, MPL.CONSIDER_RESERVATIONS
, MPL.PLAN_SAFETY_STOCK
, ML1.MEANING
, NULL
, NULL
, NULL
, NULL
, NULL
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