View: MSC_SUPPLIES_OUTBOUND_V

Product:	MSC - Advanced Supply Chain Planning
Description:	This view lists all the supplies for the plan. This view is used in XML-outbound
Implementation/DBA Data:	APPS.MSC_SUPPLIES_OUTBOUND_V

View Text

SELECT MSUP.SR_INSTANCE_ID
, MSUP.PLAN_ID
, MSUP.TRANSACTION_ID
, MSUP.ORGANIZATION_ID
, MTP.ORGANIZATION_CODE
, MSI.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSUP.REVISION
, MSUP.UNIT_NUMBER
, DECODE(NVL(MSUP.DISPOSITION_STATUS_TYPE
, 1)
, 2
, 'CANCEL'
, NULL) STATUS
, MSUP.NEW_SCHEDULE_DATE
, MSUP.LAST_UNIT_START_DATE
, (MSUP.NEW_ORDER_QUANTITY - NVL(MSUP.QUANTITY_IN_PROCESS
, 0) - NVL(MSUP.IMPLEMENTED_QUANTITY
, 0)) ORDER_QUANTITY
, MSUP.OLD_ORDER_QUANTITY
, MSUP.IMPLEMENT_AS LINE_TYPE
, MSUP.SUPPLIER_ID
, DECODE(MSUP.SUPPLIER_ID
, NULL
, NULL
, MSC_ST_UTIL.RET_PARTNER_NAME(MSUP.SUPPLIER_ID)) SUPPLIER_NAME
, MSUP.SUPPLIER_SITE_ID
, DECODE(MSUP.SUPPLIER_SITE_ID
, NULL
, NULL
, MSC_ST_UTIL.RET_PARTNER_SITE(MSUP.SUPPLIER_SITE_ID)) SUPPLIER_SITE_CODE
, MSUP.IMPLEMENTED_QUANTITY
, MSUP.FIRM_PLANNED_TYPE
, DECODE(MSUP.FIRM_PLANNED_TYPE
, 1
, 'YES'
, 2
, 'NO') FIRM_FLAG
, MSUP.RELEASE_STATUS
, MSUP.NEW_SHIP_DATE
, MSUP.PROJECT_ID
, DECODE(MSUP.PROJECT_ID
, NULL
, NULL
, MSC_ST_UTIL.RET_PROJECT_NUMBER(MSUP.PROJECT_ID
, MSUP.SR_INSTANCE_ID
, MSUP.ORGANIZATION_ID
, MSUP.PLAN_ID)) PROJECT_NUMBER
, MSUP.TASK_ID
, DECODE(MSUP.TASK_ID
, NULL
, NULL
, MSC_ST_UTIL.RET_TASK_NUMBER(MSUP.PROJECT_ID
, MSUP.TASK_ID
, MSUP.SR_INSTANCE_ID
, MSUP.ORGANIZATION_ID
, MSUP.PLAN_ID)) TASK_NUMBER
, MSUP.PLANNING_GROUP
, MSUP.DEMAND_CLASS
, MSI.UOM_CODE
, MSUP.SOURCE_SUPPLIER_ID
, MSUP.SOURCE_SUPPLIER_SITE_ID
FROM MSC_TRADING_PARTNERS MTP
, MSC_SUPPLIES MSUP
, MSC_APPS_INSTANCES MAI
, MSC_SYSTEM_ITEMS MSI
WHERE MTP.SR_TP_ID = MSUP.ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID=MSI.SR_INSTANCE_ID
AND MTP.PARTNER_TYPE = 3
AND MSUP.SR_INSTANCE_ID = MAI.INSTANCE_ID
AND MSUP.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSUP.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSUP.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MSUP.PLAN_ID= MSI.PLAN_ID
AND MSUP.ORDER_TYPE = 5
AND 0 < (MSUP.NEW_ORDER_QUANTITY - NVL(MSUP.QUANTITY_IN_PROCESS
, 0) - NVL(MSUP.IMPLEMENTED_QUANTITY
, 0))

Columns