[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 |