View: MRP_ATP_BACKLOG_TEMP_V

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRP_ATP_BACKLOG_TEMP_V

View Text

SELECT MAST.SESSION_ID
, MAST.OVERRIDE_FLAG
, MAST.SEQUENCE_NUMBER
, MAST.ORDER_NUMBER
, MAST.ORDER_LINE_NUMBER
, MAST.ORDER_LINE_ID
, MAST.SHIPMENT_NUMBER
, MAST.OPTION_NUMBER
, MAST.SHIP_SET_NAME
, MAST.SHIP_SET_ID
, MAST.ARRIVAL_SET_NAME
, MAST.ARRIVAL_SET_ID
, MAST.INVENTORY_ITEM_NAME
, MAST.SOURCE_ORGANIZATION_CODE
, MAST.SOURCE_ORGANIZATION_ID
, MAST.QUANTITY_ORDERED
, MAST.UOM_CODE
, MAST.REQUESTED_SHIP_DATE
, MAST.REQUESTED_ARRIVAL_DATE
, MAST.SCHEDULED_SHIP_DATE
, MAST.SCHEDULED_ARRIVAL_DATE
, MAST.PROMISE_DATE
, MAST.FIRM_SOURCE_ORG_ID
, MAST.FIRM_SOURCE_ORG_CODE
, MAST.FIRM_SHIP_DATE
, MAST.FIRM_ARRIVAL_DATE
FROM MRP_ATP_SCHEDULE_TEMP MAST
WHERE 1=1 UNION SELECT MAST.SESSION_ID
, MAST.OVERRIDE_FLAG
, MAST.SEQUENCE_NUMBER
, MAST.ORDER_NUMBER
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MAST.SHIP_SET_NAME
, MAST.SHIP_SET_ID
, MAST.ARRIVAL_SET_NAME
, MAST.ARRIVAL_SET_ID
, TO_CHAR(NULL)
, DECODE(MAST.SHIP_SET_NAME
, NULL
, TO_CHAR(NULL)
, MAST.SOURCE_ORGANIZATION_CODE)
, DECODE(MAST.SHIP_SET_NAME
, NULL
, TO_NUMBER(NULL)
, MAST.SOURCE_ORGANIZATION_ID)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, DECODE(MAST.SHIP_SET_NAME
, NULL
, TO_DATE(NULL)
, MAST.REQUESTED_SHIP_DATE)
, DECODE(MAST.ARRIVAL_SET_NAME
, NULL
, TO_DATE(NULL)
, MAST.REQUESTED_ARRIVAL_DATE)
, DECODE(MAST.SHIP_SET_NAME
, NULL
, TO_DATE(NULL)
, MAST.SCHEDULED_SHIP_DATE)
, DECODE(MAST.ARRIVAL_SET_NAME
, NULL
, TO_DATE(NULL)
, MAST.SCHEDULED_ARRIVAL_DATE)
, TO_DATE(NULL)
, MAST.FIRM_SOURCE_ORG_ID
, MAST.FIRM_SOURCE_ORG_CODE
, MAST.FIRM_SHIP_DATE
, MAST.FIRM_ARRIVAL_DATE
FROM MRP_ATP_SCHEDULE_TEMP MAST
WHERE (MAST.SHIP_SET_NAME IS NOT NULL OR MAST.ARRIVAL_SET_NAME IS NOT NULL)

Columns