VIEW: MRP.MRP_ATP_SCHEDULE_TEMP#

Source

View Text - Preformatted

select ACTION ACTION, CALLING_MODULE CALLING_MODULE, SESSION_ID SESSION_ID, ORDER_HEADER_ID ORDER_HEADER_ID, ORDER_LINE_ID ORDER_LINE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_CODE ORGANIZATION_CODE, ORDER_NUMBER ORDER_NUMBER, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, DESTINATION_TIME_ZONE DESTINATION_TIME_ZONE, QUANTITY_ORDERED QUANTITY_ORDERED, UOM_CODE UOM_CODE, REQUESTED_SHIP_DATE REQUESTED_SHIP_DATE, REQUESTED_ARRIVAL_DATE REQUESTED_ARRIVAL_DATE, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME, FREIGHT_CARRIER FREIGHT_CARRIER, SHIP_METHOD SHIP_METHOD, DEMAND_CLASS DEMAND_CLASS, SHIP_SET_NAME SHIP_SET_NAME, SHIP_SET_ID SHIP_SET_ID, ARRIVAL_SET_NAME ARRIVAL_SET_NAME, ARRIVAL_SET_ID ARRIVAL_SET_ID, OVERRIDE_FLAG OVERRIDE_FLAG, SCHEDULED_SHIP_DATE SCHEDULED_SHIP_DATE, SCHEDULED_ARRIVAL_DATE SCHEDULED_ARRIVAL_DATE, AVAILABLE_QUANTITY AVAILABLE_QUANTITY, REQUESTED_DATE_QUANTITY REQUESTED_DATE_QUANTITY, GROUP_SHIP_DATE GROUP_SHIP_DATE, GROUP_ARRIVAL_DATE GROUP_ARRIVAL_DATE, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, INSERT_FLAG INSERT_FLAG, ERROR_CODE ERROR_CODE, ERROR_MESSAGE ERROR_MESSAGE, SEQUENCE_NUMBER SEQUENCE_NUMBER, FIRM_FLAG FIRM_FLAG, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME, SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE, INSTANCE_ID1 INSTANCE_ID1, ORDER_LINE_NUMBER ORDER_LINE_NUMBER, SHIPMENT_NUMBER SHIPMENT_NUMBER, OPTION_NUMBER OPTION_NUMBER, PROMISE_DATE PROMISE_DATE, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_LOCATION CUSTOMER_LOCATION, OLD_LINE_SCHEDULE_DATE OLD_LINE_SCHEDULE_DATE, OLD_SOURCE_ORGANIZATION_CODE OLD_SOURCE_ORGANIZATION_CODE, SCENARIO_ID SCENARIO_ID, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_NAME VENDOR_SITE_NAME, STATUS_FLAG STATUS_FLAG, MDI_ROWID MDI_ROWID, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY, ATP_LEAD_TIME ATP_LEAD_TIME, OE_FLAG OE_FLAG, ITEM_DESC ITEM_DESC, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME, SHIP_METHOD_TEXT SHIP_METHOD_TEXT, END_PEGGING_ID END_PEGGING_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, EXCEPTION1 EXCEPTION1, EXCEPTION2 EXCEPTION2, EXCEPTION3 EXCEPTION3, EXCEPTION4 EXCEPTION4, EXCEPTION5 EXCEPTION5, EXCEPTION6 EXCEPTION6, EXCEPTION7 EXCEPTION7, EXCEPTION8 EXCEPTION8, EXCEPTION9 EXCEPTION9, EXCEPTION10 EXCEPTION10, EXCEPTION11 EXCEPTION11, EXCEPTION12 EXCEPTION12, EXCEPTION13 EXCEPTION13, EXCEPTION14 EXCEPTION14, EXCEPTION15 EXCEPTION15, FIRM_SOURCE_ORG_ID FIRM_SOURCE_ORG_ID, FIRM_SOURCE_ORG_CODE FIRM_SOURCE_ORG_CODE, FIRM_SHIP_DATE FIRM_SHIP_DATE, FIRM_ARRIVAL_DATE FIRM_ARRIVAL_DATE, OLD_SOURCE_ORGANIZATION_ID OLD_SOURCE_ORGANIZATION_ID, OLD_DEMAND_CLASS OLD_DEMAND_CLASS, ATTRIBUTE_06 ATTRIBUTE_06, REQUEST_ITEM_ID REQUEST_ITEM_ID, REQUEST_ITEM_NAME REQUEST_ITEM_NAME, REQ_ITEM_AVAILABLE_DATE REQ_ITEM_AVAILABLE_DATE, REQ_ITEM_AVAILABLE_DATE_QTY REQ_ITEM_AVAILABLE_DATE_QTY, REQ_ITEM_REQ_DATE_QTY REQ_ITEM_REQ_DATE_QTY, SALES_REP SALES_REP, CUSTOMER_CONTACT CUSTOMER_CONTACT, SUBST_FLAG SUBST_FLAG, SUBSTITUTION_TYP_CODE SUBSTITUTION_TYP_CODE, REQ_ITEM_DETAIL_FLAG REQ_ITEM_DETAIL_FLAG, OLD_INVENTORY_ITEM_ID OLD_INVENTORY_ITEM_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FLOW_STATUS_CODE FLOW_STATUS_CODE, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID, DIAGNOSTIC_ATP_FLAG DIAGNOSTIC_ATP_FLAG, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID, ATO_PARENT_MODEL_LINE_ID ATO_PARENT_MODEL_LINE_ID, ATO_MODEL_LINE_ID ATO_MODEL_LINE_ID, PARENT_LINE_ID PARENT_LINE_ID, MATCH_ITEM_ID MATCH_ITEM_ID, VALIDATION_ORG VALIDATION_ORG, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, COMPONENT_CODE COMPONENT_CODE, INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG, LINE_NUMBER LINE_NUMBER, BOM_ITEM_TYPE BOM_ITEM_TYPE, CONFIG_ITEM_LINE_ID CONFIG_ITEM_LINE_ID, OSS_ERROR_CODE OSS_ERROR_CODE, SOURCE_DOC_ID SOURCE_DOC_ID, PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG, MATCHED_ITEM_NAME MATCHED_ITEM_NAME, ATP_FLAG ATP_FLAG, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, FIXED_LT FIXED_LT, VARIABLE_LT VARIABLE_LT, MANDATORY_ITEM_FLAG MANDATORY_ITEM_FLAG, CASCADE_MODEL_INFO_TO_COMP CASCADE_MODEL_INFO_TO_COMP, ORIGINAL_REQUEST_DATE ORIGINAL_REQUEST_DATE, PLAN_ID PLAN_ID, INTERNAL_ORG_ID INTERNAL_ORG_ID, FIRST_VALID_SHIP_ARRIVAL_DATE FIRST_VALID_SHIP_ARRIVAL_DATE, PART_OF_SET PART_OF_SET, PARTY_SITE_ID PARTY_SITE_ID, CUSTOMER_COUNTRY CUSTOMER_COUNTRY, CUSTOMER_STATE CUSTOMER_STATE, CUSTOMER_CITY CUSTOMER_CITY, CUSTOMER_POSTAL_CODE CUSTOMER_POSTAL_CODE from "MRP"."MRP_ATP_SCHEDULE_TEMP"

View Text - HTML Formatted

SELECT ACTION ACTION
, CALLING_MODULE CALLING_MODULE
, SESSION_ID SESSION_ID
, ORDER_HEADER_ID ORDER_HEADER_ID
, ORDER_LINE_ID ORDER_LINE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, ORDER_NUMBER ORDER_NUMBER
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, DESTINATION_TIME_ZONE DESTINATION_TIME_ZONE
, QUANTITY_ORDERED QUANTITY_ORDERED
, UOM_CODE UOM_CODE
, REQUESTED_SHIP_DATE REQUESTED_SHIP_DATE
, REQUESTED_ARRIVAL_DATE REQUESTED_ARRIVAL_DATE
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME
, FREIGHT_CARRIER FREIGHT_CARRIER
, SHIP_METHOD SHIP_METHOD
, DEMAND_CLASS DEMAND_CLASS
, SHIP_SET_NAME SHIP_SET_NAME
, SHIP_SET_ID SHIP_SET_ID
, ARRIVAL_SET_NAME ARRIVAL_SET_NAME
, ARRIVAL_SET_ID ARRIVAL_SET_ID
, OVERRIDE_FLAG OVERRIDE_FLAG
, SCHEDULED_SHIP_DATE SCHEDULED_SHIP_DATE
, SCHEDULED_ARRIVAL_DATE SCHEDULED_ARRIVAL_DATE
, AVAILABLE_QUANTITY AVAILABLE_QUANTITY
, REQUESTED_DATE_QUANTITY REQUESTED_DATE_QUANTITY
, GROUP_SHIP_DATE GROUP_SHIP_DATE
, GROUP_ARRIVAL_DATE GROUP_ARRIVAL_DATE
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, INSERT_FLAG INSERT_FLAG
, ERROR_CODE ERROR_CODE
, ERROR_MESSAGE ERROR_MESSAGE
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, FIRM_FLAG FIRM_FLAG
, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE
, INSTANCE_ID1 INSTANCE_ID1
, ORDER_LINE_NUMBER ORDER_LINE_NUMBER
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, OPTION_NUMBER OPTION_NUMBER
, PROMISE_DATE PROMISE_DATE
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_LOCATION CUSTOMER_LOCATION
, OLD_LINE_SCHEDULE_DATE OLD_LINE_SCHEDULE_DATE
, OLD_SOURCE_ORGANIZATION_CODE OLD_SOURCE_ORGANIZATION_CODE
, SCENARIO_ID SCENARIO_ID
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_NAME VENDOR_SITE_NAME
, STATUS_FLAG STATUS_FLAG
, MDI_ROWID MDI_ROWID
, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE
, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY
, ATP_LEAD_TIME ATP_LEAD_TIME
, OE_FLAG OE_FLAG
, ITEM_DESC ITEM_DESC
, INTRANSIT_LEAD_TIME INTRANSIT_LEAD_TIME
, SHIP_METHOD_TEXT SHIP_METHOD_TEXT
, END_PEGGING_ID END_PEGGING_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, EXCEPTION1 EXCEPTION1
, EXCEPTION2 EXCEPTION2
, EXCEPTION3 EXCEPTION3
, EXCEPTION4 EXCEPTION4
, EXCEPTION5 EXCEPTION5
, EXCEPTION6 EXCEPTION6
, EXCEPTION7 EXCEPTION7
, EXCEPTION8 EXCEPTION8
, EXCEPTION9 EXCEPTION9
, EXCEPTION10 EXCEPTION10
, EXCEPTION11 EXCEPTION11
, EXCEPTION12 EXCEPTION12
, EXCEPTION13 EXCEPTION13
, EXCEPTION14 EXCEPTION14
, EXCEPTION15 EXCEPTION15
, FIRM_SOURCE_ORG_ID FIRM_SOURCE_ORG_ID
, FIRM_SOURCE_ORG_CODE FIRM_SOURCE_ORG_CODE
, FIRM_SHIP_DATE FIRM_SHIP_DATE
, FIRM_ARRIVAL_DATE FIRM_ARRIVAL_DATE
, OLD_SOURCE_ORGANIZATION_ID OLD_SOURCE_ORGANIZATION_ID
, OLD_DEMAND_CLASS OLD_DEMAND_CLASS
, ATTRIBUTE_06 ATTRIBUTE_06
, REQUEST_ITEM_ID REQUEST_ITEM_ID
, REQUEST_ITEM_NAME REQUEST_ITEM_NAME
, REQ_ITEM_AVAILABLE_DATE REQ_ITEM_AVAILABLE_DATE
, REQ_ITEM_AVAILABLE_DATE_QTY REQ_ITEM_AVAILABLE_DATE_QTY
, REQ_ITEM_REQ_DATE_QTY REQ_ITEM_REQ_DATE_QTY
, SALES_REP SALES_REP
, CUSTOMER_CONTACT CUSTOMER_CONTACT
, SUBST_FLAG SUBST_FLAG
, SUBSTITUTION_TYP_CODE SUBSTITUTION_TYP_CODE
, REQ_ITEM_DETAIL_FLAG REQ_ITEM_DETAIL_FLAG
, OLD_INVENTORY_ITEM_ID OLD_INVENTORY_ITEM_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FLOW_STATUS_CODE FLOW_STATUS_CODE
, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, DIAGNOSTIC_ATP_FLAG DIAGNOSTIC_ATP_FLAG
, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, ATO_PARENT_MODEL_LINE_ID ATO_PARENT_MODEL_LINE_ID
, ATO_MODEL_LINE_ID ATO_MODEL_LINE_ID
, PARENT_LINE_ID PARENT_LINE_ID
, MATCH_ITEM_ID MATCH_ITEM_ID
, VALIDATION_ORG VALIDATION_ORG
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, COMPONENT_CODE COMPONENT_CODE
, INCLUDED_ITEM_FLAG INCLUDED_ITEM_FLAG
, LINE_NUMBER LINE_NUMBER
, BOM_ITEM_TYPE BOM_ITEM_TYPE
, CONFIG_ITEM_LINE_ID CONFIG_ITEM_LINE_ID
, OSS_ERROR_CODE OSS_ERROR_CODE
, SOURCE_DOC_ID SOURCE_DOC_ID
, PICK_COMPONENTS_FLAG PICK_COMPONENTS_FLAG
, MATCHED_ITEM_NAME MATCHED_ITEM_NAME
, ATP_FLAG ATP_FLAG
, ATP_COMPONENTS_FLAG ATP_COMPONENTS_FLAG
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, FIXED_LT FIXED_LT
, VARIABLE_LT VARIABLE_LT
, MANDATORY_ITEM_FLAG MANDATORY_ITEM_FLAG
, CASCADE_MODEL_INFO_TO_COMP CASCADE_MODEL_INFO_TO_COMP
, ORIGINAL_REQUEST_DATE ORIGINAL_REQUEST_DATE
, PLAN_ID PLAN_ID
, INTERNAL_ORG_ID INTERNAL_ORG_ID
, FIRST_VALID_SHIP_ARRIVAL_DATE FIRST_VALID_SHIP_ARRIVAL_DATE
, PART_OF_SET PART_OF_SET
, PARTY_SITE_ID PARTY_SITE_ID
, CUSTOMER_COUNTRY CUSTOMER_COUNTRY
, CUSTOMER_STATE CUSTOMER_STATE
, CUSTOMER_CITY CUSTOMER_CITY
, CUSTOMER_POSTAL_CODE CUSTOMER_POSTAL_CODE
FROM "MRP"."MRP_ATP_SCHEDULE_TEMP"