View: MRP_FLP_SUPPLY_V

Product:	MRP - Master Scheduling/MRP
Description:	View of supply information
Implementation/DBA Data:	APPS.MRP_FLP_SUPPLY_V

View Text

SELECT MR.TRANSACTION_ID
, MR.INVENTORY_ITEM_ID
, MR.ORGANIZATION_ID
, MR.COMPILE_DESIGNATOR
, MR.NEW_SCHEDULE_DATE
, MR.NEW_ORDER_QUANTITY
, MR.ORDER_TYPE
, MR.NEW_PROCESSING_DAYS
, ML.MEANING
, DECODE(MR.ORDER_TYPE
, 1
, MIP.PO_NUMBER
, 2
, MIP.PO_NUMBER
, 3
, WE.WIP_ENTITY_NAME
, 7
, WE.WIP_ENTITY_NAME
, 14
, WE.WIP_ENTITY_NAME
, 15
, WE.WIP_ENTITY_NAME
, 11
, MIP.PO_NUMBER
, 12
, MIP.PO_NUMBER
, 8
, MIP.PO_NUMBER
, 27
, WE.WIP_ENTITY_NAME
, 28
, WE.WIP_ENTITY_NAME
, '')
, MRP_GET_PROJECT.PROJECT(MR.PROJECT_ID)
, MRP_GET_PROJECT.TASK(MR.TASK_ID)
, MIF.ITEM_NUMBER||'/'||MP.ORGANIZATION_CODE
, SUBSTR(MIF.DESCRIPTION
, 1
, 20)
, MR.END_ITEM_UNIT_NUMBER
FROM MFG_LOOKUPS ML
, MRP_ITEM_PURCHASE_ORDERS MIP
, WIP_ENTITIES WE
, MTL_PARAMETERS MP
, MTL_ITEM_FLEXFIELDS MIF
, MRP_RECOMMENDATIONS MR
WHERE MIF.INVENTORY_ITEM_ID = MR.INVENTORY_ITEM_ID
AND MIF.ORGANIZATION_ID = MR.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID(+) = MR.DISPOSITION_ID
AND WE.ORGANIZATION_ID(+) = MR.ORGANIZATION_ID
AND MP.ORGANIZATION_ID = MR.ORGANIZATION_ID
AND MIP.TRANSACTION_ID(+) = MR.DISPOSITION_ID
AND ML.LOOKUP_TYPE = 'MRP_ORDER_TYPE'
AND MR.ORDER_TYPE = ML.LOOKUP_CODE

Columns