FND Design Data [Home] [Help]

View: MRP_FLP_SUPPLY_DEMAND_V2

Product: MRP - Master Scheduling/MRP
Description: View of pegged supply and demand information
Implementation/DBA Data: ViewAPPS.MRP_FLP_SUPPLY_DEMAND_V2
View Text

SELECT MFP2.ROWID
, MFP2.COMPILE_DESIGNATOR
, MFP2.ORGANIZATION_ID
, MFP2.PEGGING_ID
, NVL(MFP2.PREV_PEGGING_ID
, -1)
, MFP2.DEMAND_ID
, MFP2.TRANSACTION_ID
, MFP2.END_ITEM_USAGE
, ROUND(MFP2.DEMAND_QUANTITY
, 2)
, MGR2.USING_ASSEMBLY_DEMAND_DATE
, ROUND(MR2.NEW_ORDER_QUANTITY
, 2)
, MFP2.INVENTORY_ITEM_ID
, MIF2.ITEM_NUMBER||'/'||MP2.ORGANIZATION_CODE
, SUBSTR(MIF2.DESCRIPTION
, 1
, 20)
, ROUND(MFP2.ALLOCATED_QUANTITY
, 2)
, ML2.MEANING
, MRP_GET_PROJECT.PROJECT(MGR2.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MGR2.TASK_ID)
, DECODE(MFP2.END_ITEM_USAGE
, NULL
, 0
, ROUND(MFP2.ALLOCATED_QUANTITY/MFP2.END_ITEM_USAGE
, 2))
, DECODE(MFP3.DEMAND_ID
, -1
, ROUND(MFP3.ALLOCATED_QUANTITY
, 2)
, ROUND(MFP3.DEMAND_QUANTITY
, 2))
, DECODE(MFP3.DEMAND_ID
, -1
, MFP3.SUPPLY_DATE
, MFP3.DEMAND_DATE)
, MIF3.ITEM_NUMBER||'/'||MP3.ORGANIZATION_CODE
, SUBSTR(MIF3.DESCRIPTION
, 1
, 20)
, ML3.MEANING
, DECODE(MGR3.ORIGINATION_TYPE
, 2
, WE3.WIP_ENTITY_NAME
, 3
, WE3.WIP_ENTITY_NAME
, 17
, WE3.WIP_ENTITY_NAME
, 18
, MIP3.PO_NUMBER
, 19
, MIP3.PO_NUMBER
, 20
, MIP3.PO_NUMBER
, 23
, MIP3.PO_NUMBER
, 24
, MIP3.PO_NUMBER
, 25
, WE3.WIP_ENTITY_NAME
, 26
, WE3.WIP_ENTITY_NAME
, 6
, SUBSTR(MSO3.SEGMENT1
, 1
, 40)
, '')
, MRP_GET_PROJECT.PROJECT(MFP3.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MFP3.TASK_ID)
, ROUND(MR1.NEW_ORDER_QUANTITY
, 2)
, MR1.NEW_SCHEDULE_DATE
, MIF1.ITEM_NUMBER||'/'||MP1.ORGANIZATION_CODE
, SUBSTR(MIF1.DESCRIPTION
, 1
, 20)
, MFP1.INVENTORY_ITEM_ID
, MFP1.DEMAND_ID
, ROUND(MFP1.ALLOCATED_QUANTITY
, 2)
, MR1.NEW_PROCESSING_DAYS
, ML1.MEANING
, MR1.ORDER_TYPE
, DECODE(MR1.ORDER_TYPE
, 3
, WE1.WIP_ENTITY_NAME
, 7
, WE1.WIP_ENTITY_NAME
, 14
, WE1.WIP_ENTITY_NAME
, 15
, WE1.WIP_ENTITY_NAME
, 1
, MIP1.PO_NUMBER
, 2
, MIP1.PO_NUMBER
, 11
, MIP1.PO_NUMBER
, 12
, MIP1.PO_NUMBER
, '')
, SL3.DEMAND_CLASS_CODE
, SL3.ATTRIBUTE1
, SL3.ATTRIBUTE2
, SL3.ATTRIBUTE3
, SL3.ATTRIBUTE4
, SL3.ATTRIBUTE5
, SL3.ATTRIBUTE6
, SL3.ATTRIBUTE7
, SL3.ATTRIBUTE8
, SL3.ATTRIBUTE9
, SL3.ATTRIBUTE10
, SL3.ATTRIBUTE11
, SL3.ATTRIBUTE12
, SL3.ATTRIBUTE13
, SL3.ATTRIBUTE14
, SL3.ATTRIBUTE15
, MGR2.END_ITEM_UNIT_NUMBER
, MGR3.END_ITEM_UNIT_NUMBER
, MR1.END_ITEM_UNIT_NUMBER
, MRP_GET_PROJECT.PROJECT(MR1.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MR1.TASK_ID)
, MRP_GET_PROJECT.PROJECT(MGR2.LENDING_PROJECT_ID)
, MRP_GET_PROJECT.TASK(MGR2.LENDING_TASK_ID)
, MRP_GET_PROJECT.PROJECT(MGR3.LENDING_PROJECT_ID)
, MRP_GET_PROJECT.TASK(MGR3.LENDING_TASK_ID)
FROM MFG_LOOKUPS ML3
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML1
, MRP_ITEM_PURCHASE_ORDERS MIP3
, MRP_ITEM_PURCHASE_ORDERS MIP1
, WIP_ENTITIES WE3
, WIP_ENTITIES WE1
, MTL_ITEM_FLEXFIELDS MIF3
, MTL_ITEM_FLEXFIELDS MIF2
, MTL_ITEM_FLEXFIELDS MIF1
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MTL_PARAMETERS MP3
, OE_ORDER_LINES_ALL SL3
, MTL_DEMAND_OMOE MD3
, MTL_SALES_ORDERS MSO3
, MRP_SCHEDULE_DATES MSD3
, MRP_RECOMMENDATIONS MR2
, MRP_RECOMMENDATIONS MR1
, MRP_GROSS_REQUIREMENTS MGR3
, MRP_GROSS_REQUIREMENTS MGR2
, MRP_FULL_PEGGING MFP1
, MRP_FULL_PEGGING MFP3
, MRP_FULL_PEGGING MFP2
WHERE ML1.LOOKUP_CODE = MR1.ORDER_TYPE
AND ML1.LOOKUP_TYPE = 'MRP_ORDER_TYPE'
AND MIP1.TRANSACTION_ID(+) = MR1.DISPOSITION_ID
AND WE1.WIP_ENTITY_ID(+) = MR1.DISPOSITION_ID
AND WE1.ORGANIZATION_ID(+) = MR1.ORGANIZATION_ID
AND MP1.ORGANIZATION_ID = MFP1.ORGANIZATION_ID
AND MR1.TRANSACTION_ID = MFP1.TRANSACTION_ID
AND MIF1.INVENTORY_ITEM_ID = MFP1.INVENTORY_ITEM_ID
AND MIF1.ORGANIZATION_ID = MFP1.ORGANIZATION_ID
AND MFP1.PEGGING_ID = MFP2.PREV_PEGGING_ID
AND ML3.LOOKUP_CODE = DECODE(MFP3.DEMAND_ID
, -1
, MFP3.DEMAND_ID
, -2
, MFP3.DEMAND_ID
, -3
, MFP3.DEMAND_ID
, MGR3.ORIGINATION_TYPE)
AND ML3.LOOKUP_TYPE = DECODE(MFP3.DEMAND_ID
, -1
, 'TEST_FLP_SUPPLY_DEMAND_TYPE'
, -2
, 'TEST_FLP_SUPPLY_DEMAND_TYPE'
, -3
, 'TEST_FLP_SUPPLY_DEMAND_TYPE'
, 'MRP_DEMAND_ORIGINATION')
AND MSO3.SALES_ORDER_ID(+) = MSD3.SOURCE_SALES_ORDER_ID
AND MSD3.MPS_TRANSACTION_ID(+) = MGR3.DISPOSITION_ID
AND MSD3.SCHEDULE_LEVEL(+) = 2
AND MSD3.SUPPLY_DEMAND_TYPE(+) = 1
AND MIP3.TRANSACTION_ID(+) = MGR3.DISPOSITION_ID
AND WE3.WIP_ENTITY_ID(+) = MGR3.DISPOSITION_ID
AND WE3.ORGANIZATION_ID(+) = MGR3.ORGANIZATION_ID
AND SL3.LINE_ID(+) = MD3.DEMAND_SOURCE_LINE
AND MD3.DEMAND_ID(+) = MGR3.RESERVATION_ID
AND MGR3.DEMAND_ID(+) = MFP3.DEMAND_ID
AND MP3.ORGANIZATION_ID = MFP3.ORGANIZATION_ID
AND MIF3.INVENTORY_ITEM_ID = MFP3.INVENTORY_ITEM_ID
AND MIF3.ORGANIZATION_ID = MFP3.ORGANIZATION_ID
AND MFP3.PEGGING_ID = MFP2.END_PEGGING_ID
AND ML2.LOOKUP_CODE = MGR2.ORIGINATION_TYPE
AND ML2.LOOKUP_TYPE = 'MRP_DEMAND_ORIGINATION'
AND MP2.ORGANIZATION_ID = MFP2.ORGANIZATION_ID
AND MIF2.ORGANIZATION_ID = MFP2.ORGANIZATION_ID
AND MIF2.INVENTORY_ITEM_ID = MFP2.INVENTORY_ITEM_ID
AND MGR2.DEMAND_ID = MFP2.DEMAND_ID
AND MR2.TRANSACTION_ID = MFP2.TRANSACTION_ID
AND MFP2.PREV_PEGGING_ID IS NOT NULL

Columns

Name
ROW_ID
COMPILE_DESIGNATOR
ORGANIZATION_ID
PEGGING_ID
PREV_PEGGING_ID
DEMAND_ID
TRANSACTION_ID
END_ITEM_USAGE
DEMAND_QTY
DEMAND_DATE
SUPPLY_QTY
ITEM_ID
ITEM_ORG
ITEM_DESC
PEGGED_QTY
ORIGINATION_NAME
PROJECT_NUMBER
TASK_NUMBER
END_PEGGED_QTY
END_DEMAND_QTY
END_DEMAND_DATE
END_ITEM_ORG
END_ITEM_DESC
END_ORIGINATION_NAME
END_DISPOSITION
END_PROJECT_NUMBER
END_TASK_NUMBER
PREV_SUPPLY_QTY
PREV_SUPPLY_DATE
PREV_ITEM_ORG
PREV_ITEM_DESC
PREV_ITEM_ID
PREV_DEMAND_ID
PREV_PEGGED_QTY
NEW_PROCESSING_DAYS
ORDER_NAME
ORDER_TYPE
PREV_DISPOSITION
END_DEMAND_CLASS
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
UNIT_NUMBER
END_UNIT_NUMBER
PREV_UNIT_NUMBER
PREV_PROJECT_NUMBER
PREV_TASK_NUMBER
LENDING_PROJECT_NUMBER
LENDING_TASK_NUMBER
END_LENDING_PROJECT_NUMBER
END_LENDING_TASK_NUMBER