VIEW: APPS.EDW_MRP_PNDM_PLN_LCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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