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_END_DEMAND_V

Source

View Text - Preformatted


SELECT MFP.ROWID , MFP.ORGANIZATION_ID , MFP.COMPILE_DESIGNATOR , MFP.PEGGING_ID , MFP.TRANSACTION_ID , MFP.DEMAND_ID , NVL(MFP.PREV_PEGGING_ID, -1) , MFP.INVENTORY_ITEM_ID , DECODE(MFP.DEMAND_ID, -1,ROUND(MFP.ALLOCATED_QUANTITY,2), ROUND(MFP.DEMAND_QUANTITY,2)) , ROUND(MR.NEW_ORDER_QUANTITY,2) , ROUND(MFP.ALLOCATED_QUANTITY,2) , DECODE(MFP.DEMAND_ID, -1,MFP.SUPPLY_DATE, MFP.DEMAND_DATE) , DECODE(MFP.DEMAND_ID, -1, DECODE(ML2.MEANING, NULL, ML.MEANING, ML.MEANING||'/'||ML2.MEANING), ML.MEANING) , DECODE(MGR.ORIGINATION_TYPE, 2, WE.WIP_ENTITY_NAME, 3, WE.WIP_ENTITY_NAME, 17, WE.WIP_ENTITY_NAME, 18, MIP.PO_NUMBER, 19, MIP.PO_NUMBER, 20, MIP.PO_NUMBER, 23, MIP.PO_NUMBER, 24, MIP.PO_NUMBER, 25, WE.WIP_ENTITY_NAME, 26, WE.WIP_ENTITY_NAME, 6, SUBSTR(MSO.SEGMENT1, 1, 40), '') , MIF.ITEM_NUMBER||'/'||MP.ORGANIZATION_CODE , SUBSTR(MIF.DESCRIPTION,1,20) , decode(mfp.demand_id, -1, mrp_get_project.project(mfp.project_id), -3, mrp_get_project.project(mfp.project_id), MRP_GET_PROJECT.PROJECT(MGR.PROJECT_ID)) , decode(mfp.demand_id, -1, mrp_get_project.task(mfp.task_id), -3, mrp_get_project.task(mfp.task_id), MRP_GET_PROJECT.TASK(MGR.TASK_ID)) , SL.DEMAND_CLASS_CODE , SL.ATTRIBUTE1 , SL.ATTRIBUTE2 , SL.ATTRIBUTE3 , SL.ATTRIBUTE4 , SL.ATTRIBUTE5 , SL.ATTRIBUTE6 , SL.ATTRIBUTE7 , SL.ATTRIBUTE8 , SL.ATTRIBUTE9 , SL.ATTRIBUTE10 , SL.ATTRIBUTE11 , SL.ATTRIBUTE12 , SL.ATTRIBUTE13 , SL.ATTRIBUTE14 , SL.ATTRIBUTE15 , MGR.END_ITEM_UNIT_NUMBER , MRP_GET_PROJECT.PROJECT(mgr.lending_project_id) , MRP_GET_PROJECT.TASK(mgr.lending_task_id) FROM FND_LOOKUP_VALUES ML, FND_LOOKUP_VALUES ML2, MRP_ITEM_PURCHASE_ORDERS MIP, WIP_ENTITIES WE, MTL_SALES_ORDERS MSO, MRP_SCHEDULE_DATES MSD, MTL_ITEM_FLEXFIELDS MIF, MTL_PARAMETERS MP, OE_ORDER_LINES_ALL SL, MRP_RECOMMENDATIONS MR, MRP_GROSS_REQUIREMENTS MGR, MRP_FULL_PEGGING MFP WHERE ML.LOOKUP_CODE = to_char(DECODE(MFP.DEMAND_ID, -1, MFP.DEMAND_ID, -2, MFP.DEMAND_ID, -3, MFP.DEMAND_ID, MGR.ORIGINATION_TYPE)) AND ML.LOOKUP_TYPE = DECODE(MFP.DEMAND_ID, -1, 'MRP_FLP_SUPPLY_DEMAND_TYPE', -2, 'MRP_FLP_SUPPLY_DEMAND_TYPE', -3, 'MRP_FLP_SUPPLY_DEMAND_TYPE', 'MRP_DEMAND_ORIGINATION') AND ML.LANGUAGE = userenv('LANG') AND ML.VIEW_APPLICATION_ID = 700 AND ML.SECURITY_GROUP_ID = fnd_global.lookup_security_group( ML.LOOKUP_TYPE,ML.VIEW_APPLICATION_ID) AND ML2.LOOKUP_CODE = to_char(DECODE(MFP.SUPPLY_TYPE, 10, 5, 13, 5, MFP.SUPPLY_TYPE)) AND ML2.LOOKUP_TYPE IN ('MRP_FLP_SUPPLY_DEMAND_TYPE', 'MRP_ORDER_TYPE') AND ML2.LANGUAGE = userenv('LANG') AND ML2.VIEW_APPLICATION_ID = 700 AND ML2.SECURITY_GROUP_ID = fnd_global.lookup_security_group( ML2.LOOKUP_TYPE,ML2.VIEW_APPLICATION_ID) AND MSO.SALES_ORDER_ID(+) = MSD.SOURCE_SALES_ORDER_ID AND MSD.MPS_TRANSACTION_ID(+) = MGR.DISPOSITION_ID AND MSD.SCHEDULE_LEVEL(+) = 2 AND MSD.SUPPLY_DEMAND_TYPE(+) = 1 AND MIP.TRANSACTION_ID(+) = MGR.DISPOSITION_ID AND WE.WIP_ENTITY_ID(+) = MGR.DISPOSITION_ID AND WE.ORGANIZATION_ID(+) = MGR.ORGANIZATION_ID AND SL.LINE_ID(+) = MGR.RESERVATION_ID AND MGR.DEMAND_ID(+) = MFP.DEMAND_ID AND MR.TRANSACTION_ID(+) = MFP.TRANSACTION_ID AND MP.ORGANIZATION_ID = MFP.ORGANIZATION_ID AND MIF.INVENTORY_ITEM_ID = MFP.INVENTORY_ITEM_ID AND MIF.ORGANIZATION_ID = MFP.ORGANIZATION_ID AND MFP.PREV_PEGGING_ID IS NULL

View Text - HTML Formatted

SELECT MFP.ROWID
, MFP.ORGANIZATION_ID
, MFP.COMPILE_DESIGNATOR
, MFP.PEGGING_ID
, MFP.TRANSACTION_ID
, MFP.DEMAND_ID
, NVL(MFP.PREV_PEGGING_ID
, -1)
, MFP.INVENTORY_ITEM_ID
, DECODE(MFP.DEMAND_ID
, -1
, ROUND(MFP.ALLOCATED_QUANTITY
, 2)
, ROUND(MFP.DEMAND_QUANTITY
, 2))
, ROUND(MR.NEW_ORDER_QUANTITY
, 2)
, ROUND(MFP.ALLOCATED_QUANTITY
, 2)
, DECODE(MFP.DEMAND_ID
, -1
, MFP.SUPPLY_DATE
, MFP.DEMAND_DATE)
, DECODE(MFP.DEMAND_ID
, -1
, DECODE(ML2.MEANING
, NULL
, ML.MEANING
, ML.MEANING||'/'||ML2.MEANING)
, ML.MEANING)
, DECODE(MGR.ORIGINATION_TYPE
, 2
, WE.WIP_ENTITY_NAME
, 3
, WE.WIP_ENTITY_NAME
, 17
, WE.WIP_ENTITY_NAME
, 18
, MIP.PO_NUMBER
, 19
, MIP.PO_NUMBER
, 20
, MIP.PO_NUMBER
, 23
, MIP.PO_NUMBER
, 24
, MIP.PO_NUMBER
, 25
, WE.WIP_ENTITY_NAME
, 26
, WE.WIP_ENTITY_NAME
, 6
, SUBSTR(MSO.SEGMENT1
, 1
, 40)
, '')
, MIF.ITEM_NUMBER||'/'||MP.ORGANIZATION_CODE
, SUBSTR(MIF.DESCRIPTION
, 1
, 20)
, DECODE(MFP.DEMAND_ID
, -1
, MRP_GET_PROJECT.PROJECT(MFP.PROJECT_ID)
, -3
, MRP_GET_PROJECT.PROJECT(MFP.PROJECT_ID)
, MRP_GET_PROJECT.PROJECT(MGR.PROJECT_ID))
, DECODE(MFP.DEMAND_ID
, -1
, MRP_GET_PROJECT.TASK(MFP.TASK_ID)
, -3
, MRP_GET_PROJECT.TASK(MFP.TASK_ID)
, MRP_GET_PROJECT.TASK(MGR.TASK_ID))
, SL.DEMAND_CLASS_CODE
, SL.ATTRIBUTE1
, SL.ATTRIBUTE2
, SL.ATTRIBUTE3
, SL.ATTRIBUTE4
, SL.ATTRIBUTE5
, SL.ATTRIBUTE6
, SL.ATTRIBUTE7
, SL.ATTRIBUTE8
, SL.ATTRIBUTE9
, SL.ATTRIBUTE10
, SL.ATTRIBUTE11
, SL.ATTRIBUTE12
, SL.ATTRIBUTE13
, SL.ATTRIBUTE14
, SL.ATTRIBUTE15
, MGR.END_ITEM_UNIT_NUMBER
, MRP_GET_PROJECT.PROJECT(MGR.LENDING_PROJECT_ID)
, MRP_GET_PROJECT.TASK(MGR.LENDING_TASK_ID)
FROM FND_LOOKUP_VALUES ML
, FND_LOOKUP_VALUES ML2
, MRP_ITEM_PURCHASE_ORDERS MIP
, WIP_ENTITIES WE
, MTL_SALES_ORDERS MSO
, MRP_SCHEDULE_DATES MSD
, MTL_ITEM_FLEXFIELDS MIF
, MTL_PARAMETERS MP
, OE_ORDER_LINES_ALL SL
, MRP_RECOMMENDATIONS MR
, MRP_GROSS_REQUIREMENTS MGR
, MRP_FULL_PEGGING MFP
WHERE ML.LOOKUP_CODE = TO_CHAR(DECODE(MFP.DEMAND_ID
, -1
, MFP.DEMAND_ID
, -2
, MFP.DEMAND_ID
, -3
, MFP.DEMAND_ID
, MGR.ORIGINATION_TYPE))
AND ML.LOOKUP_TYPE = DECODE(MFP.DEMAND_ID
, -1
, 'MRP_FLP_SUPPLY_DEMAND_TYPE'
, -2
, 'MRP_FLP_SUPPLY_DEMAND_TYPE'
, -3
, 'MRP_FLP_SUPPLY_DEMAND_TYPE'
, 'MRP_DEMAND_ORIGINATION')
AND ML.LANGUAGE = USERENV('LANG')
AND ML.VIEW_APPLICATION_ID = 700
AND ML.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP( ML.LOOKUP_TYPE
, ML.VIEW_APPLICATION_ID)
AND ML2.LOOKUP_CODE = TO_CHAR(DECODE(MFP.SUPPLY_TYPE
, 10
, 5
, 13
, 5
, MFP.SUPPLY_TYPE))
AND ML2.LOOKUP_TYPE IN ('MRP_FLP_SUPPLY_DEMAND_TYPE'
, 'MRP_ORDER_TYPE')
AND ML2.LANGUAGE = USERENV('LANG')
AND ML2.VIEW_APPLICATION_ID = 700
AND ML2.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP( ML2.LOOKUP_TYPE
, ML2.VIEW_APPLICATION_ID)
AND MSO.SALES_ORDER_ID(+) = MSD.SOURCE_SALES_ORDER_ID
AND MSD.MPS_TRANSACTION_ID(+) = MGR.DISPOSITION_ID
AND MSD.SCHEDULE_LEVEL(+) = 2
AND MSD.SUPPLY_DEMAND_TYPE(+) = 1
AND MIP.TRANSACTION_ID(+) = MGR.DISPOSITION_ID
AND WE.WIP_ENTITY_ID(+) = MGR.DISPOSITION_ID
AND WE.ORGANIZATION_ID(+) = MGR.ORGANIZATION_ID
AND SL.LINE_ID(+) = MGR.RESERVATION_ID
AND MGR.DEMAND_ID(+) = MFP.DEMAND_ID
AND MR.TRANSACTION_ID(+) = MFP.TRANSACTION_ID
AND MP.ORGANIZATION_ID = MFP.ORGANIZATION_ID
AND MIF.INVENTORY_ITEM_ID = MFP.INVENTORY_ITEM_ID
AND MIF.ORGANIZATION_ID = MFP.ORGANIZATION_ID
AND MFP.PREV_PEGGING_ID IS NULL