View: MRPBV_PLAN_PEGS

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPBV_PLAN_PEGS

View Text

SELECT PEG.DEMAND_QUANTITY
, PEG.SUPPLY_QUANTITY
, PEG.ALLOCATED_QUANTITY
, PEG.DEMAND_DATE
, PEG.SUPPLY_DATE
, LKUP.MEANING
, LKUP2.MEANING
, PEG.END_ITEM_USAGE
, PEG.PEGGING_ID
, PEG.PREV_PEGGING_ID
, PEG.END_PEGGING_ID
, PEG.ORGANIZATION_ID
, PEG.COMPILE_DESIGNATOR
, PEG.INVENTORY_ITEM_ID
, PEG.TRANSACTION_ID
, PEG.DEMAND_ID
, PEG.PROJECT_ID
, PEG.TASK_ID
, PEG.LAST_UPDATE_DATE
, PEG.LAST_UPDATED_BY
, PEG.CREATION_DATE
, PEG.CREATED_BY
FROM MFG_LOOKUPS LKUP
, MFG_LOOKUPS LKUP2
, MRP_FULL_PEGGING PEG
WHERE LKUP.LOOKUP_TYPE(+) = 'MRP_ORDER_TYPE'
AND LKUP.LOOKUP_CODE(+) = PEG.SUPPLY_TYPE
AND DECODE(PEG.END_ORIGINATION_TYPE
, 1
, 'MRP_PLANNED_ORDER_DEMAND'
, 3
, 'MRP_PLANNED_ORDER_DEMAND'
, 25
, 'MRP_PLANNED_ORDER_DEMAND'
, 'MRP_DEMAND_ORIGINATION') = LKUP2.LOOKUP_TYPE(+)
AND LKUP2.LOOKUP_CODE(+) = PEG.END_ORIGINATION_TYPE
AND '_SEC:PEG.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns