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