View: MRPFV_PLAN_PEGS

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

View Text

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, PEG.COMPILE_DESIGNATOR
, '_KF:INV:MSTK:SYSITEM'
, PEG.DEMAND_QUANTITY
, PEG.SUPPLY_QUANTITY
, PEG.ALLOCATED_QUANTITY
, PEG.DEMAND_DATE
, PEG.SUPPLY_DATE
, LKUP.MEANING
, LKUP2.MEANING
, PEG.END_ITEM_USAGE
, MRP_GET_PROJECT.PROJECT(PEG.PROJECT_ID)
, MRP_GET_PROJECT.TASK(PEG.TASK_ID)
, PEG.PEGGING_ID
, PEG.PREV_PEGGING_ID
, PEG.END_PEGGING_ID
, PEG.ORGANIZATION_ID
, 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
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SYSITEM
, MRP_SYSTEM_ITEMS MRPITEM
, MRP_FULL_PEGGING PEG
WHERE PEG.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND PEG.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND PEG.COMPILE_DESIGNATOR = MRPITEM.COMPILE_DESIGNATOR
AND PEG.ORGANIZATION_ID = MRPITEM.ORGANIZATION_ID
AND PEG.INVENTORY_ITEM_ID = MRPITEM.INVENTORY_ITEM_ID
AND SYSITEM.ORGANIZATION_ID = MRPITEM.ORGANIZATION_ID
AND SYSITEM.INVENTORY_ITEM_ID = MRPITEM.INVENTORY_ITEM_ID
AND 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