View: MRPFV_PLAN_DEMANDS

Product:	MRP - Master Scheduling/MRP
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MRPFV_PLAN_DEMANDS

View Text

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

Columns