View: MRP_I2_PROCUREMENT_V

View Text

SELECT PMV.PART_NUMBER
, PMV.INVENTORY_ITEM_ID
, PMV.ORGANIZATION_ID
, PS.SUPPLY_QUANTITY
, SUBSTR( MRP_I2_ERP.GET_PARAMETER('MRP_I2_L_SCHED_RECEIPT_PREFIX'
, PMV.ORGANIZATION_ID
, DECODE(SUPPLY_TYPE
, 11
, 12
, SUPPLY_TYPE))|| PS.SUPPLY_NUMBER || '-' || TO_CHAR(PS.SUPPLY_LINE_NUM)
, 1
, 240)
, GREATEST( MRP_I2_ERP.NEXT_WORKDAY(TRUNC(PS.DOCK_DATE) + PMV.POSTPROCESSING_LEADTIME
, PMV.ORGANIZATION_ID)
, MRP_I2_ERP.GET_START_DATE(PMV.ORGANIZATION_ID))
, PS.VENDOR_NAME
, DECODE(SUPPLY_TYPE
, 2
, PS.SUPPLY_LINE_ID
, TO_NUMBER(NULL))
, SUBSTR( MRP_I2_ERP.GET_PARAMETER('MRP_I2_L_SCHED_RECEIPT_PREFIX'
, PMV.ORGANIZATION_ID
, DECODE(SUPPLY_TYPE
, 11
, 12
, SUPPLY_TYPE))
, 1
, 240)
, PMV.POSTPROCESSING_LEADTIME
, SUPPLY_TYPE
, DECODE(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_ENABLE_ABP'
, PMV.ORGANIZATION_ID)
, 'Y'
, DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_PO_AA_ATTR_NUM'
, PMV.ORGANIZATION_ID))
, 1
, PS.ATTRIBUTE1
, 2
, PS.ATTRIBUTE2
, 3
, PS.ATTRIBUTE3
, 4
, PS.ATTRIBUTE4
, 5
, PS.ATTRIBUTE5
, 6
, PS.ATTRIBUTE6
, 7
, PS.ATTRIBUTE7
, 8
, PS.ATTRIBUTE8
, 9
, PS.ATTRIBUTE9
, 10
, PS.ATTRIBUTE10
, 11
, PS.ATTRIBUTE11
, 12
, PS.ATTRIBUTE12
, 13
, PS.ATTRIBUTE13
, 14
, PS.ATTRIBUTE14
, 15
, PS.ATTRIBUTE15)
, 'N'
, NULL)
FROM /*+FULL*/MRP_RHX_PURCHASING_SUPPLY_V PS
, MRP_I2_PART_MASTER_V PMV
WHERE PS.DESTINATION_TYPE_CODE = 'INVENTORY'
AND PS.SUPPLY_LINE_NUM IS NOT NULL
AND PS.SUPPLY_LINE_ID IS NOT NULL
AND PS.INVENTORY_ITEM_ID IS NOT NULL
AND PS.ORGANIZATION_ID = PMV.ORGANIZATION_ID
AND PS.INVENTORY_ITEM_ID = PMV.INVENTORY_ITEM_ID

Columns