View: MRP_ATP_SCHEDULE_TEMP_V

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

View Text

SELECT MAST.ACTION
, MAST.CALLING_MODULE
, MAST.ROWID ROW_ID
, MAST.SESSION_ID
, MAST.ORDER_HEADER_ID
, MAST.ORDER_NUMBER
, MAST.ORDER_LINE_ID
, MAST.INVENTORY_ITEM_ID
, MAST.ORGANIZATION_ID
, MAST.SR_INSTANCE_ID
, MAST.ORGANIZATION_CODE
, MAST.SOURCE_ORGANIZATION_ID
, MAST.CUSTOMER_ID
, MAST.CUSTOMER_SITE_ID
, MAST.DESTINATION_TIME_ZONE
, MAST.QUANTITY_ORDERED
, MAST.UOM_CODE
, MAST.REQUESTED_SHIP_DATE
, MAST.REQUESTED_ARRIVAL_DATE
, MAST.LATEST_ACCEPTABLE_DATE
, MAST.DELIVERY_LEAD_TIME
, MAST.FREIGHT_CARRIER
, MAST.SHIP_METHOD
, MAST.DEMAND_CLASS
, MAST.SHIP_SET_NAME
, MAST.ARRIVAL_SET_NAME
, MAST.OVERRIDE_FLAG
, MAST.SCHEDULED_SHIP_DATE
, MAST.SCHEDULED_ARRIVAL_DATE
, MAST.AVAILABLE_QUANTITY
, MAST.REQUESTED_DATE_QUANTITY
, MAST.GROUP_SHIP_DATE
, MAST.GROUP_ARRIVAL_DATE
, MAST.VENDOR_ID
, MAST.VENDOR_SITE_ID
, MAST.INSERT_FLAG
, MAST.ERROR_CODE
, ML.MEANING ERROR_MESSAGE
, MAST.SEQUENCE_NUMBER
, MAST.FIRM_FLAG
, MAST.INVENTORY_ITEM_NAME
, MAST.SOURCE_ORGANIZATION_CODE
, MAST.INSTANCE_ID1
, MAST.ORDER_LINE_NUMBER
, MAST.PROMISE_DATE
, MAST.CUSTOMER_NAME
, MAST.CUSTOMER_LOCATION
, MAST.OLD_LINE_SCHEDULE_DATE
, MAST.OLD_SOURCE_ORGANIZATION_CODE
, MAST.SCENARIO_ID
, MAST.VENDOR_NAME
, MAST.VENDOR_SITE_NAME
, MAST.STATUS_FLAG
, OO.SCHEDULE_STATUS_CODE
, MAST.ITEM_DESC
, MAST.INTRANSIT_LEAD_TIME
, MAST.SHIP_METHOD_TEXT
, MAST.END_PEGGING_ID
, MAST.SHIPMENT_NUMBER
, MAST.OPTION_NUMBER
, MAST.PROJECT_ID
, MAST.TASK_ID
, MAST.SHIP_SET_ID
, MAST.ARRIVAL_SET_ID
, MAST.PROJECT_NUMBER
, MAST.TASK_NUMBER
, MAST.EXCEPTION1
, MAST.EXCEPTION2
, MAST.EXCEPTION3
, MAST.EXCEPTION4
, MAST.EXCEPTION5
, MAST.EXCEPTION6
, MAST.EXCEPTION7
, MAST.EXCEPTION8
, MAST.EXCEPTION9
, MAST.EXCEPTION10
, MAST.EXCEPTION11
, MAST.EXCEPTION12
, MAST.EXCEPTION13
, MAST.EXCEPTION14
, MAST.EXCEPTION15
, MAST.FIRM_SOURCE_ORG_ID
, MAST.FIRM_SOURCE_ORG_CODE
, MAST.FIRM_SHIP_DATE
, MAST.FIRM_ARRIVAL_DATE
, MAST.REQUEST_ITEM_NAME
, MAST.REQ_ITEM_AVAILABLE_DATE
, MAST.REQ_ITEM_AVAILABLE_DATE_QTY
, MAST.REQ_ITEM_REQ_DATE_QTY
, MAST.COMPILE_DESIGNATOR
, MAST.FLOW_STATUS_CODE
FROM MRP_ATP_SCHEDULE_TEMP MAST
, OE_ORDER_LINES_ALL OO
, MFG_LOOKUPS ML
WHERE MAST.ORDER_LINE_ID = OO.LINE_ID(+)
AND MAST.ORDER_HEADER_ID = OO.HEADER_ID(+)
AND ML.LOOKUP_TYPE(+) = 'MTL_DEMAND_INTERFACE_ERRORS'
AND NVL(MAST.ERROR_CODE
, -1) = ML.LOOKUP_CODE(+)

Columns