eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MRP_FLP_DEMAND_SUPPLY_V

Source

View Text - Preformatted


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 , MFP2.INVENTORY_ITEM_ID , MIF2.ITEM_NUMBER||'/'||MP2.ORGANIZATION_CODE , ROUND(MR2.NEW_ORDER_QUANTITY,2) , ROUND(MFP2.ALLOCATED_QUANTITY,2) , MR2.NEW_SCHEDULE_DATE , ROUND(MFP2.DEMAND_QUANTITY,2) , MFP2.DEMAND_DATE , ML2.MEANING , MRP_GET_PROJECT.PROJECT(MR2.PROJECT_ID) , MRP_GET_PROJECT.TASK(MR2.TASK_ID) , MR2.ORDER_TYPE , DECODE(MR2.ORDER_TYPE, 3, WE2.WIP_ENTITY_NAME, 7, WE2.WIP_ENTITY_NAME, 14, WE2.WIP_ENTITY_NAME, 15, WE2.WIP_ENTITY_NAME, 1, MIP2.PO_NUMBER, 2, MIP2.PO_NUMBER, 11, MIP2.PO_NUMBER, 12, MIP2.PO_NUMBER, 8, MIP2.PO_NUMBER, 27, WE2.WIP_ENTITY_NAME, 28, WE2.WIP_ENTITY_NAME, '') , 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, 6, SUBSTR(MSO3.SEGMENT1, 1, 40), '') , MRP_GET_PROJECT.PROJECT(MFP3.PROJECT_ID) , MRP_GET_PROJECT.TASK(MFP3.TASK_ID) , 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 , MR2.END_ITEM_UNIT_NUMBER , MGR3.END_ITEM_UNIT_NUMBER , MIF2.description , MRP_GET_PROJECT.PROJECT(mgr3.lending_project_id) , MRP_GET_PROJECT.TASK(mgr3.lending_task_id) FROM MFG_LOOKUPS ML3, MFG_LOOKUPS ML2, MRP_ITEM_PURCHASE_ORDERS MIP3, MRP_ITEM_PURCHASE_ORDERS MIP2, WIP_ENTITIES WE3, WIP_ENTITIES WE2, MTL_ITEM_FLEXFIELDS MIF3, MTL_ITEM_FLEXFIELDS MIF2, MTL_PARAMETERS MP2, MTL_PARAMETERS MP3, MTL_SALES_ORDERS MSO3, OE_ORDER_LINES_ALL SL3, MTL_DEMAND MD3, MRP_SCHEDULE_DATES MSD3, MRP_GROSS_REQUIREMENTS MGR3, MRP_RECOMMENDATIONS MR2, MRP_FULL_PEGGING MFP3, MRP_FULL_PEGGING MFP2 WHERE 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, 'MRP_FLP_SUPPLY_DEMAND_TYPE', -2, 'MRP_FLP_SUPPLY_DEMAND_TYPE', -3, 'MRP_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 = MR2.ORDER_TYPE AND ML2.LOOKUP_TYPE = 'MRP_ORDER_TYPE' AND MIP2.TRANSACTION_ID(+) = MR2.DISPOSITION_ID AND WE2.WIP_ENTITY_ID(+) = MR2.DISPOSITION_ID AND WE2.ORGANIZATION_ID(+) = MR2.ORGANIZATION_ID AND MR2.TRANSACTION_ID = MFP2.TRANSACTION_ID AND MP2.ORGANIZATION_ID = MFP2.ORGANIZATION_ID AND MIF2.INVENTORY_ITEM_ID = MFP2.INVENTORY_ITEM_ID AND MIF2.ORGANIZATION_ID = MFP2.ORGANIZATION_ID AND NVL(MFP2.SUPPLY_TYPE,1) != 18

View Text - HTML Formatted

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
, MFP2.INVENTORY_ITEM_ID
, MIF2.ITEM_NUMBER||'/'||MP2.ORGANIZATION_CODE
, ROUND(MR2.NEW_ORDER_QUANTITY
, 2)
, ROUND(MFP2.ALLOCATED_QUANTITY
, 2)
, MR2.NEW_SCHEDULE_DATE
, ROUND(MFP2.DEMAND_QUANTITY
, 2)
, MFP2.DEMAND_DATE
, ML2.MEANING
, MRP_GET_PROJECT.PROJECT(MR2.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MR2.TASK_ID)
, MR2.ORDER_TYPE
, DECODE(MR2.ORDER_TYPE
, 3
, WE2.WIP_ENTITY_NAME
, 7
, WE2.WIP_ENTITY_NAME
, 14
, WE2.WIP_ENTITY_NAME
, 15
, WE2.WIP_ENTITY_NAME
, 1
, MIP2.PO_NUMBER
, 2
, MIP2.PO_NUMBER
, 11
, MIP2.PO_NUMBER
, 12
, MIP2.PO_NUMBER
, 8
, MIP2.PO_NUMBER
, 27
, WE2.WIP_ENTITY_NAME
, 28
, WE2.WIP_ENTITY_NAME
, '')
, 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
, 6
, SUBSTR(MSO3.SEGMENT1
, 1
, 40)
, '')
, MRP_GET_PROJECT.PROJECT(MFP3.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MFP3.TASK_ID)
, 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
, MR2.END_ITEM_UNIT_NUMBER
, MGR3.END_ITEM_UNIT_NUMBER
, MIF2.DESCRIPTION
, MRP_GET_PROJECT.PROJECT(MGR3.LENDING_PROJECT_ID)
, MRP_GET_PROJECT.TASK(MGR3.LENDING_TASK_ID)
FROM MFG_LOOKUPS ML3
, MFG_LOOKUPS ML2
, MRP_ITEM_PURCHASE_ORDERS MIP3
, MRP_ITEM_PURCHASE_ORDERS MIP2
, WIP_ENTITIES WE3
, WIP_ENTITIES WE2
, MTL_ITEM_FLEXFIELDS MIF3
, MTL_ITEM_FLEXFIELDS MIF2
, MTL_PARAMETERS MP2
, MTL_PARAMETERS MP3
, MTL_SALES_ORDERS MSO3
, OE_ORDER_LINES_ALL SL3
, MTL_DEMAND MD3
, MRP_SCHEDULE_DATES MSD3
, MRP_GROSS_REQUIREMENTS MGR3
, MRP_RECOMMENDATIONS MR2
, MRP_FULL_PEGGING MFP3
, MRP_FULL_PEGGING MFP2
WHERE 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
, 'MRP_FLP_SUPPLY_DEMAND_TYPE'
, -2
, 'MRP_FLP_SUPPLY_DEMAND_TYPE'
, -3
, 'MRP_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 = MR2.ORDER_TYPE
AND ML2.LOOKUP_TYPE = 'MRP_ORDER_TYPE'
AND MIP2.TRANSACTION_ID(+) = MR2.DISPOSITION_ID
AND WE2.WIP_ENTITY_ID(+) = MR2.DISPOSITION_ID
AND WE2.ORGANIZATION_ID(+) = MR2.ORGANIZATION_ID
AND MR2.TRANSACTION_ID = MFP2.TRANSACTION_ID
AND MP2.ORGANIZATION_ID = MFP2.ORGANIZATION_ID
AND MIF2.INVENTORY_ITEM_ID = MFP2.INVENTORY_ITEM_ID
AND MIF2.ORGANIZATION_ID = MFP2.ORGANIZATION_ID
AND NVL(MFP2.SUPPLY_TYPE
, 1) != 18