VIEW: APPS.MRPFV_PLAN_PEGS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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