View: MSC_PO_RESCHEDULE_DETAILS_V

Product:	MSC - Advanced Supply Chain Planning
Description:	This view contains the line information of a rescheduled purchase order. This view is used in XML-outbound.
Implementation/DBA Data:	APPS.MSC_PO_RESCHEDULE_DETAILS_V

View Text

SELECT MPR.SOURCE_LINE_ID
, MPR.PURCHASE_ORDER_ID
, MPR.PO_NUMBER
, MPR.LINE_ID
, S.PURCH_LINE_NUM
, S.ORGANIZATION_ID
, MSC_ST_UTIL.RET_ORG_CODE(MPR.SR_INSTANCE_ID
, S.ORGANIZATION_ID) ORG_CODE
, MSC_ST_UTIL.RET_PARTNER_NAME(NVL(S.SUPPLIER_ID
, S.SOURCE_SUPPLIER_ID)) SUPPLIER_NAME
, NVL(S.SUPPLIER_ID
, S.SOURCE_SUPPLIER_ID) SUPPLIER_ID
, MSC_ST_UTIL.RET_PARTNER_SITE(NVL(S.SUPPLIER_SITE_ID
, S.SOURCE_SUPPLIER_SITE_ID)) SUPPLIER_SITE_CODE
, NVL (S.SUPPLIER_SITE_ID
, S.SOURCE_SUPPLIER_SITE_ID) SUPPLIER_SITE_ID
, MSI.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MPR.QUANTITY
, MPR.UOM
, MPR.NEED_BY_DATE
, MPR.SR_INSTANCE_ID
, MAI.INSTANCE_CODE
FROM MSC_PO_RESCHEDULE_INTERFACE MPR
, MSC_APPS_INSTANCES MAI
, MSC_SYSTEM_ITEMS MSI
, MSC_SUPPLIES S
WHERE MPR.SR_INSTANCE_ID = MAI.INSTANCE_ID
AND MPR.SOURCE_LINE_ID = S.TRANSACTION_ID
AND MPR.PLAN_ID = S.PLAN_ID
AND MPR.SR_INSTANCE_ID = S.SR_INSTANCE_ID
AND MSI.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID
AND MSI.PLAN_ID = S.PLAN_ID
AND MSI.ORGANIZATION_ID = S.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID = S.SR_INSTANCE_ID

Columns