VIEW: APPS.MRP_ATP_BACKLOG_TEMP_V

Source

View Text - Preformatted

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 ,mast.customer_name ,mast.customer_location ,mast.ship_method ,mast.demand_class ,mast.latest_acceptable_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 ,mast.customer_name ,mast.customer_location ,mast.ship_method ,mast.demand_class ,mast.latest_acceptable_date FROM mrp_atp_schedule_temp mast WHERE (mast.ship_set_name IS NOT NULL or mast.arrival_set_name IS NOT NULL)

View Text - HTML Formatted

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
, MAST.CUSTOMER_NAME
, MAST.CUSTOMER_LOCATION
, MAST.SHIP_METHOD
, MAST.DEMAND_CLASS
, MAST.LATEST_ACCEPTABLE_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
, MAST.CUSTOMER_NAME
, MAST.CUSTOMER_LOCATION
, MAST.SHIP_METHOD
, MAST.DEMAND_CLASS
, MAST.LATEST_ACCEPTABLE_DATE
FROM MRP_ATP_SCHEDULE_TEMP MAST
WHERE (MAST.SHIP_SET_NAME IS NOT NULL OR MAST.ARRIVAL_SET_NAME IS NOT NULL)