FND Design Data [Home] [Help]

View: MRP_I2_RESCHED_PO_REQ_V

Product: MRP - Master Scheduling/MRP
Description: A Rhythm view supporting information regarding purchase orders rescheduled by Rhythm
Implementation/DBA Data: Not implemented in this database
View Text

SELECT EDC.PURCHASE_ORDER
, EDC.ORGANIZATION_ID
, PV.LINE_ID
, EDC.PO_QUANTITY
, TO_DATE( DECODE(INSTR(EDC.MESSAGE_2
, ' TO ')
, 0
, NULL
, SUBSTR(EDC.MESSAGE_2
, INSTR(EDC.MESSAGE_2
, ' TO ') + LENGTH(' TO ')
, 14))
, 'MM/DD/RR HH24:MI') - PV.POSTPROCESSING_LEADTIME
FROM /*+FULL*/ MRP_I2_PROCUREMENT_V PV
, MRP_I2_PO_EDC EDC
WHERE PV.ORDER_TYPE = MRP_I2_ERP.GET_PARAMETER('MRP_I2_L_SCHED_RECEIPT_PREFIX'
, EDC.ORGANIZATION_ID
, 2)
AND PV.ORGANIZATION_ID = EDC.ORGANIZATION_ID
AND PV.PO_NUMBER = EDC.PURCHASE_ORDER
AND EDC.MESSAGE_2 IS NOT NULL

Columns

Name
REQ_NUMBER
ORGANIZATION_ID
LINE_ID
QUANTITY
NEED_BY_DATE