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.MRPFV_PLAN_DEMANDS

Source

View Text - Preformatted


SELECT DISTINCT PA.ORGANIZATION_CODE , ORG.NAME , PLAN.COMPILE_DESIGNATOR , '_KF:INV:MSTK:SYSITEM' , DECODE(MGR.ORIGINATION_TYPE, 2, IWE.WIP_ENTITY_NAME, 3, IWE.WIP_ENTITY_NAME, 17, IWE.WIP_ENTITY_NAME, 18, IPO.PO_NUMBER, 19, IPO.PO_NUMBER, 20, IPO.PO_NUMBER, 23, IPO.PO_NUMBER, 24, IPO.PO_NUMBER, 25, IWE.WIP_ENTITY_NAME, 26, IWE.WIP_ENTITY_NAME, 6, SO.SEGMENT1 || ':' || SO.SEGMENT2 || ':' || SO.SEGMENT3, NULL) , LKUP.MEANING , MGR.USING_ASSEMBLY_DEMAND_DATE , - NVL(MGR.DAILY_DEMAND_RATE, MGR.USING_REQUIREMENTS_QUANTITY) , MGR.FIRM_DATE , MGR.FIRM_QUANTITY , GREATEST(0, MGR.USING_ASSEMBLY_DEMAND_DATE -(TRUNC(SYSDATE))) , MGR.ASSEMBLY_DEMAND_COMP_DATE , MGR.OLD_DEMAND_DATE , MGR.OLD_DEMAND_QUANTITY , MGR.PLANNING_GROUP , PA2.ORGANIZATION_CODE , ORG2.NAME , MRP_GET_PROJECT.PROJECT(MGR.PROJECT_ID) , MRP_GET_PROJECT.TASK(MGR.TASK_ID) , MGR.END_ITEM_UNIT_NUMBER , MRP_GET_PROJECT.PROJECT(MGR.LENDING_PROJECT_ID) , MRP_GET_PROJECT.TASK(MGR.LENDING_TASK_ID) , MGR.DEMAND_ID , MRPITEM.ORGANIZATION_ID , MGR.INVENTORY_ITEM_ID , MGR.PROJECT_ID , MGR.TASK_ID , MGR.SOURCE_ORGANIZATION_ID , DECODE(MGR.ORIGINATION_TYPE, 2, IWE.WIP_ENTITY_ID, 3, IWE.WIP_ENTITY_ID, TO_NUMBER(NULL)) , DECODE(MGR.ORIGINATION_TYPE, 1, SUPPLY.TRANSACTION_ID, 4, SUPPLY.TRANSACTION_ID, 16, SUPPLY.TRANSACTION_ID, 17, SUPPLY.TRANSACTION_ID, 21, SUPPLY.TRANSACTION_ID, TO_NUMBER(NULL)) , DECODE(MGR.ORIGINATION_TYPE, 6, DATES.MPS_TRANSACTION_ID, 7, DATES.MPS_TRANSACTION_ID, 8, DATES.MPS_TRANSACTION_ID, 9, DATES.MPS_TRANSACTION_ID, TO_NUMBER(NULL)) , MGR.LENDING_PROJECT_ID , MGR.LENDING_TASK_ID , MGR.LAST_UPDATE_DATE , MGR.LAST_UPDATED_BY , MGR.CREATION_DATE , MGR.CREATED_BY FROM MTL_SALES_ORDERS SO ,MRP_SCHEDULE_DATES DATES ,MFG_LOOKUPS LKUP ,MRP_RECOMMENDATIONS SUPPLY ,MRP_ITEM_PURCHASE_ORDERS IPO ,MRP_ITEM_WIP_ENTITIES IWE ,MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS ORG ,MTL_PARAMETERS PA2 ,HR_ALL_ORGANIZATION_UNITS ORG2 ,MTL_SYSTEM_ITEMS SYSITEM ,MRP_GROSS_REQUIREMENTS MGR ,MRP_SYSTEM_ITEMS MRPITEM ,MRP_PLAN_ORGANIZATIONS PLANORG ,MRP_PLANS PLAN WHERE SUPPLY.TRANSACTION_ID(+) = MGR.DISPOSITION_ID AND IPO.TRANSACTION_ID(+) = MGR.DISPOSITION_ID AND SYSITEM.ORGANIZATION_ID = MRPITEM.ORGANIZATION_ID AND SYSITEM.INVENTORY_ITEM_ID = MRPITEM.INVENTORY_ITEM_ID AND PA.ORGANIZATION_ID = MGR.ORGANIZATION_ID AND ORG.ORGANIZATION_ID = MGR.ORGANIZATION_ID AND PA2.ORGANIZATION_ID(+)= MGR.SOURCE_ORGANIZATION_ID AND ORG2.ORGANIZATION_ID(+) = MGR.SOURCE_ORGANIZATION_ID AND IWE.WIP_ENTITY_ID(+) = MGR.DISPOSITION_ID AND IWE.COMPILE_DESIGNATOR(+) = MGR.COMPILE_DESIGNATOR AND IWE.ORGANIZATION_ID(+) = MGR.ORGANIZATION_ID AND IWE.INVENTORY_ITEM_ID(+) = MGR.INVENTORY_ITEM_ID AND DATES.MPS_TRANSACTION_ID(+) = MGR.DISPOSITION_ID AND DATES.SOURCE_SALES_ORDER_ID = SO.SALES_ORDER_ID(+) AND DATES.SCHEDULE_LEVEL(+) = 3 AND MGR.COMPILE_DESIGNATOR = MRPITEM.COMPILE_DESIGNATOR AND MGR.ORGANIZATION_ID = MRPITEM.ORGANIZATION_ID AND MGR.INVENTORY_ITEM_ID = MRPITEM.INVENTORY_ITEM_ID AND DECODE(MGR.ORIGINATION_TYPE, 1, 'MRP_PLANNED_ORDER_DEMAND', 3, 'MRP_PLANNED_ORDER_DEMAND', 25, 'MRP_PLANNED_ORDER_DEMAND', 'MRP_DEMAND_ORIGINATION') = LKUP.LOOKUP_TYPE AND LKUP.LOOKUP_CODE = MGR.ORIGINATION_TYPE AND MRPITEM.ORGANIZATION_ID = NVL(PLANORG.PLANNED_ORGANIZATION, PLAN.ORGANIZATION_ID) AND MRPITEM.COMPILE_DESIGNATOR = PLAN.COMPILE_DESIGNATOR AND PLANORG.PLAN_LEVEL(+) = 2 AND PLANORG.COMPILE_DESIGNATOR(+) = PLAN.COMPILE_DESIGNATOR AND PLANORG.ORGANIZATION_ID(+) = PLAN.ORGANIZATION_ID AND '_SEC:MRPITEM.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT DISTINCT PA.ORGANIZATION_CODE
, ORG.NAME
, PLAN.COMPILE_DESIGNATOR
, '_KF:INV:MSTK:SYSITEM'
, DECODE(MGR.ORIGINATION_TYPE
, 2
, IWE.WIP_ENTITY_NAME
, 3
, IWE.WIP_ENTITY_NAME
, 17
, IWE.WIP_ENTITY_NAME
, 18
, IPO.PO_NUMBER
, 19
, IPO.PO_NUMBER
, 20
, IPO.PO_NUMBER
, 23
, IPO.PO_NUMBER
, 24
, IPO.PO_NUMBER
, 25
, IWE.WIP_ENTITY_NAME
, 26
, IWE.WIP_ENTITY_NAME
, 6
, SO.SEGMENT1 || ':' || SO.SEGMENT2 || ':' || SO.SEGMENT3
, NULL)
, LKUP.MEANING
, MGR.USING_ASSEMBLY_DEMAND_DATE
, - NVL(MGR.DAILY_DEMAND_RATE
, MGR.USING_REQUIREMENTS_QUANTITY)
, MGR.FIRM_DATE
, MGR.FIRM_QUANTITY
, GREATEST(0
, MGR.USING_ASSEMBLY_DEMAND_DATE -(TRUNC(SYSDATE)))
, MGR.ASSEMBLY_DEMAND_COMP_DATE
, MGR.OLD_DEMAND_DATE
, MGR.OLD_DEMAND_QUANTITY
, MGR.PLANNING_GROUP
, PA2.ORGANIZATION_CODE
, ORG2.NAME
, MRP_GET_PROJECT.PROJECT(MGR.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MGR.TASK_ID)
, MGR.END_ITEM_UNIT_NUMBER
, MRP_GET_PROJECT.PROJECT(MGR.LENDING_PROJECT_ID)
, MRP_GET_PROJECT.TASK(MGR.LENDING_TASK_ID)
, MGR.DEMAND_ID
, MRPITEM.ORGANIZATION_ID
, MGR.INVENTORY_ITEM_ID
, MGR.PROJECT_ID
, MGR.TASK_ID
, MGR.SOURCE_ORGANIZATION_ID
, DECODE(MGR.ORIGINATION_TYPE
, 2
, IWE.WIP_ENTITY_ID
, 3
, IWE.WIP_ENTITY_ID
, TO_NUMBER(NULL))
, DECODE(MGR.ORIGINATION_TYPE
, 1
, SUPPLY.TRANSACTION_ID
, 4
, SUPPLY.TRANSACTION_ID
, 16
, SUPPLY.TRANSACTION_ID
, 17
, SUPPLY.TRANSACTION_ID
, 21
, SUPPLY.TRANSACTION_ID
, TO_NUMBER(NULL))
, DECODE(MGR.ORIGINATION_TYPE
, 6
, DATES.MPS_TRANSACTION_ID
, 7
, DATES.MPS_TRANSACTION_ID
, 8
, DATES.MPS_TRANSACTION_ID
, 9
, DATES.MPS_TRANSACTION_ID
, TO_NUMBER(NULL))
, MGR.LENDING_PROJECT_ID
, MGR.LENDING_TASK_ID
, MGR.LAST_UPDATE_DATE
, MGR.LAST_UPDATED_BY
, MGR.CREATION_DATE
, MGR.CREATED_BY
FROM MTL_SALES_ORDERS SO
, MRP_SCHEDULE_DATES DATES
, MFG_LOOKUPS LKUP
, MRP_RECOMMENDATIONS SUPPLY
, MRP_ITEM_PURCHASE_ORDERS IPO
, MRP_ITEM_WIP_ENTITIES IWE
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_PARAMETERS PA2
, HR_ALL_ORGANIZATION_UNITS ORG2
, MTL_SYSTEM_ITEMS SYSITEM
, MRP_GROSS_REQUIREMENTS MGR
, MRP_SYSTEM_ITEMS MRPITEM
, MRP_PLAN_ORGANIZATIONS PLANORG
, MRP_PLANS PLAN
WHERE SUPPLY.TRANSACTION_ID(+) = MGR.DISPOSITION_ID
AND IPO.TRANSACTION_ID(+) = MGR.DISPOSITION_ID
AND SYSITEM.ORGANIZATION_ID = MRPITEM.ORGANIZATION_ID
AND SYSITEM.INVENTORY_ITEM_ID = MRPITEM.INVENTORY_ITEM_ID
AND PA.ORGANIZATION_ID = MGR.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = MGR.ORGANIZATION_ID
AND PA2.ORGANIZATION_ID(+)= MGR.SOURCE_ORGANIZATION_ID
AND ORG2.ORGANIZATION_ID(+) = MGR.SOURCE_ORGANIZATION_ID
AND IWE.WIP_ENTITY_ID(+) = MGR.DISPOSITION_ID
AND IWE.COMPILE_DESIGNATOR(+) = MGR.COMPILE_DESIGNATOR
AND IWE.ORGANIZATION_ID(+) = MGR.ORGANIZATION_ID
AND IWE.INVENTORY_ITEM_ID(+) = MGR.INVENTORY_ITEM_ID
AND DATES.MPS_TRANSACTION_ID(+) = MGR.DISPOSITION_ID
AND DATES.SOURCE_SALES_ORDER_ID = SO.SALES_ORDER_ID(+)
AND DATES.SCHEDULE_LEVEL(+) = 3
AND MGR.COMPILE_DESIGNATOR = MRPITEM.COMPILE_DESIGNATOR
AND MGR.ORGANIZATION_ID = MRPITEM.ORGANIZATION_ID
AND MGR.INVENTORY_ITEM_ID = MRPITEM.INVENTORY_ITEM_ID
AND DECODE(MGR.ORIGINATION_TYPE
, 1
, 'MRP_PLANNED_ORDER_DEMAND'
, 3
, 'MRP_PLANNED_ORDER_DEMAND'
, 25
, 'MRP_PLANNED_ORDER_DEMAND'
, 'MRP_DEMAND_ORIGINATION') = LKUP.LOOKUP_TYPE
AND LKUP.LOOKUP_CODE = MGR.ORIGINATION_TYPE
AND MRPITEM.ORGANIZATION_ID = NVL(PLANORG.PLANNED_ORGANIZATION
, PLAN.ORGANIZATION_ID)
AND MRPITEM.COMPILE_DESIGNATOR = PLAN.COMPILE_DESIGNATOR
AND PLANORG.PLAN_LEVEL(+) = 2
AND PLANORG.COMPILE_DESIGNATOR(+) = PLAN.COMPILE_DESIGNATOR
AND PLANORG.ORGANIZATION_ID(+) = PLAN.ORGANIZATION_ID
AND '_SEC:MRPITEM.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY