VIEW: APPS.MRPBV_PLAN_PEGS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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