[Home] [Help]
View: MSC_PO_RESCHEDULE_HEADER_V
Product: | MSC - Advanced Supply Chain Planning |
Description: | This view contains the header information of a rescheduled purchase order. This view is used in XML-outbound |
Implementation/DBA Data: |
APPS.MSC_PO_RESCHEDULE_HEADER_V
|
View Text
SELECT DISTINCT MPR. PURCHASE_ORDER_ID
, MPR.PO_NUMBER
, MPR.SR_INSTANCE_ID
, MAI.INSTANCE_CODE
, MPR.SOURCE_LINE_ID
FROM MSC_PO_RESCHEDULE_INTERFACE MPR
, MSC_APPS_INSTANCES MAI
WHERE MPR.SR_INSTANCE_ID = MAI.INSTANCE_ID
Columns
Name |
PURCHASE_ORDER_ID |
PO_NUMBER |
SR_INSTANCE_ID |
INSTANCE_CODE |
SOURCE_LINE_ID |