VIEW: RLM.RLM_DEMAND_EXCEPTIONS#

Source

View Text - Preformatted

select EXCEPTION_ID EXCEPTION_ID, MESSAGE_NAME MESSAGE_NAME, EXCEPTION_LEVEL EXCEPTION_LEVEL, CUST_BILL_TO_EXT CUST_BILL_TO_EXT, CUST_INTERMD_SHIPTO_EXT CUST_INTERMD_SHIPTO_EXT, CUST_ITEM_DESCRIPTION CUST_ITEM_DESCRIPTION, CUST_JOB_NUMBER CUST_JOB_NUMBER, CUST_MODEL_SERIAL_NUM CUST_MODEL_SERIAL_NUM, CUST_NAME_EXT CUST_NAME_EXT, CUSTOMER_PROD_SEQ_NUM CUSTOMER_PROD_SEQ_NUM, CUST_SHIP_FROM_ORG_EXT CUST_SHIP_FROM_ORG_EXT, CUST_SHIP_TO_EXT CUST_SHIP_TO_EXT, CUST_UOM_EXT CUST_UOM_EXT, CUSTOMER_ITEM_EXT CUSTOMER_ITEM_EXT, DATE_TYPE_CODE DATE_TYPE_CODE, ECE_TP_LOCATION_CODE_EXT ECE_TP_LOCATION_CODE_EXT, ECE_TP_TRANSLATOR_CODE ECE_TP_TRANSLATOR_CODE, EDI_CONTROL_NUM_3 EDI_CONTROL_NUM_3, EDI_TEST_INDICATOR EDI_TEST_INDICATOR, EXCEPTION_ATTRIBUTE1 EXCEPTION_ATTRIBUTE1, EXCEPTION_ATTRIBUTE10 EXCEPTION_ATTRIBUTE10, EXCEPTION_ATTRIBUTE11 EXCEPTION_ATTRIBUTE11, EXCEPTION_ATTRIBUTE12 EXCEPTION_ATTRIBUTE12, EXCEPTION_ATTRIBUTE13 EXCEPTION_ATTRIBUTE13, EXCEPTION_ATTRIBUTE14 EXCEPTION_ATTRIBUTE14, EXCEPTION_ATTRIBUTE15 EXCEPTION_ATTRIBUTE15, EXCEPTION_ATTRIBUTE16 EXCEPTION_ATTRIBUTE16, EXCEPTION_ATTRIBUTE17 EXCEPTION_ATTRIBUTE17, EXCEPTION_ATTRIBUTE18 EXCEPTION_ATTRIBUTE18, EXCEPTION_ATTRIBUTE19 EXCEPTION_ATTRIBUTE19, EXCEPTION_ATTRIBUTE2 EXCEPTION_ATTRIBUTE2, EXCEPTION_ATTRIBUTE20 EXCEPTION_ATTRIBUTE20, EXCEPTION_ATTRIBUTE3 EXCEPTION_ATTRIBUTE3, EXCEPTION_ATTRIBUTE4 EXCEPTION_ATTRIBUTE4, EXCEPTION_ATTRIBUTE5 EXCEPTION_ATTRIBUTE5, EXCEPTION_ATTRIBUTE6 EXCEPTION_ATTRIBUTE6, EXCEPTION_ATTRIBUTE7 EXCEPTION_ATTRIBUTE7, EXCEPTION_ATTRIBUTE8 EXCEPTION_ATTRIBUTE8, EXCEPTION_ATTRIBUTE9 EXCEPTION_ATTRIBUTE9, ITEM_DETAIL_QUANTITY ITEM_DETAIL_QUANTITY, ITEM_DETAIL_SUBTYPE ITEM_DETAIL_SUBTYPE, ITEM_DETAIL_TYPE ITEM_DETAIL_TYPE, MESSAGE_TEXT MESSAGE_TEXT, QTY_TYPE_CODE QTY_TYPE_CODE, INTERFACE_HEADER_ID INTERFACE_HEADER_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, SCHEDULE_HEADER_ID SCHEDULE_HEADER_ID, SCHEDULE_LINE_ID SCHEDULE_LINE_ID, SCHEDULE_TYPE SCHEDULE_TYPE, SCHED_GENERATION_DATE SCHED_GENERATION_DATE, SCHEDULE_ITEM_NUM SCHEDULE_ITEM_NUM, SCHEDULE_PURPOSE SCHEDULE_PURPOSE, SCHEDULE_REFERENCE_NUM SCHEDULE_REFERENCE_NUM, SCHEDULE_SOURCE SCHEDULE_SOURCE, START_DATE_TIME START_DATE_TIME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, INVENTORY_ITEM INVENTORY_ITEM, SCHEDULE_LINE_NUMBER SCHEDULE_LINE_NUMBER, HORIZON_START_DATE HORIZON_START_DATE, HORIZON_END_DATE HORIZON_END_DATE, ORDER_HEADER_ID ORDER_HEADER_ID, ORDER_LINE_ID ORDER_LINE_ID, REQUEST_DATE REQUEST_DATE, INDUSTRY_ATTRIBUTE1 INDUSTRY_ATTRIBUTE1, SCHEDULE_DATE SCHEDULE_DATE, CUST_PO_NUMBER CUST_PO_NUMBER, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE, CUST_PRODUCTION_LINE CUST_PRODUCTION_LINE, PURGE_STATUS PURGE_STATUS, ORIGIN_TABLE ORIGIN_TABLE, REPORT_SUMMARY REPORT_SUMMARY from "RLM"."RLM_DEMAND_EXCEPTIONS"

View Text - HTML Formatted

SELECT EXCEPTION_ID EXCEPTION_ID
, MESSAGE_NAME MESSAGE_NAME
, EXCEPTION_LEVEL EXCEPTION_LEVEL
, CUST_BILL_TO_EXT CUST_BILL_TO_EXT
, CUST_INTERMD_SHIPTO_EXT CUST_INTERMD_SHIPTO_EXT
, CUST_ITEM_DESCRIPTION CUST_ITEM_DESCRIPTION
, CUST_JOB_NUMBER CUST_JOB_NUMBER
, CUST_MODEL_SERIAL_NUM CUST_MODEL_SERIAL_NUM
, CUST_NAME_EXT CUST_NAME_EXT
, CUSTOMER_PROD_SEQ_NUM CUSTOMER_PROD_SEQ_NUM
, CUST_SHIP_FROM_ORG_EXT CUST_SHIP_FROM_ORG_EXT
, CUST_SHIP_TO_EXT CUST_SHIP_TO_EXT
, CUST_UOM_EXT CUST_UOM_EXT
, CUSTOMER_ITEM_EXT CUSTOMER_ITEM_EXT
, DATE_TYPE_CODE DATE_TYPE_CODE
, ECE_TP_LOCATION_CODE_EXT ECE_TP_LOCATION_CODE_EXT
, ECE_TP_TRANSLATOR_CODE ECE_TP_TRANSLATOR_CODE
, EDI_CONTROL_NUM_3 EDI_CONTROL_NUM_3
, EDI_TEST_INDICATOR EDI_TEST_INDICATOR
, EXCEPTION_ATTRIBUTE1 EXCEPTION_ATTRIBUTE1
, EXCEPTION_ATTRIBUTE10 EXCEPTION_ATTRIBUTE10
, EXCEPTION_ATTRIBUTE11 EXCEPTION_ATTRIBUTE11
, EXCEPTION_ATTRIBUTE12 EXCEPTION_ATTRIBUTE12
, EXCEPTION_ATTRIBUTE13 EXCEPTION_ATTRIBUTE13
, EXCEPTION_ATTRIBUTE14 EXCEPTION_ATTRIBUTE14
, EXCEPTION_ATTRIBUTE15 EXCEPTION_ATTRIBUTE15
, EXCEPTION_ATTRIBUTE16 EXCEPTION_ATTRIBUTE16
, EXCEPTION_ATTRIBUTE17 EXCEPTION_ATTRIBUTE17
, EXCEPTION_ATTRIBUTE18 EXCEPTION_ATTRIBUTE18
, EXCEPTION_ATTRIBUTE19 EXCEPTION_ATTRIBUTE19
, EXCEPTION_ATTRIBUTE2 EXCEPTION_ATTRIBUTE2
, EXCEPTION_ATTRIBUTE20 EXCEPTION_ATTRIBUTE20
, EXCEPTION_ATTRIBUTE3 EXCEPTION_ATTRIBUTE3
, EXCEPTION_ATTRIBUTE4 EXCEPTION_ATTRIBUTE4
, EXCEPTION_ATTRIBUTE5 EXCEPTION_ATTRIBUTE5
, EXCEPTION_ATTRIBUTE6 EXCEPTION_ATTRIBUTE6
, EXCEPTION_ATTRIBUTE7 EXCEPTION_ATTRIBUTE7
, EXCEPTION_ATTRIBUTE8 EXCEPTION_ATTRIBUTE8
, EXCEPTION_ATTRIBUTE9 EXCEPTION_ATTRIBUTE9
, ITEM_DETAIL_QUANTITY ITEM_DETAIL_QUANTITY
, ITEM_DETAIL_SUBTYPE ITEM_DETAIL_SUBTYPE
, ITEM_DETAIL_TYPE ITEM_DETAIL_TYPE
, MESSAGE_TEXT MESSAGE_TEXT
, QTY_TYPE_CODE QTY_TYPE_CODE
, INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, SCHEDULE_HEADER_ID SCHEDULE_HEADER_ID
, SCHEDULE_LINE_ID SCHEDULE_LINE_ID
, SCHEDULE_TYPE SCHEDULE_TYPE
, SCHED_GENERATION_DATE SCHED_GENERATION_DATE
, SCHEDULE_ITEM_NUM SCHEDULE_ITEM_NUM
, SCHEDULE_PURPOSE SCHEDULE_PURPOSE
, SCHEDULE_REFERENCE_NUM SCHEDULE_REFERENCE_NUM
, SCHEDULE_SOURCE SCHEDULE_SOURCE
, START_DATE_TIME START_DATE_TIME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, INVENTORY_ITEM INVENTORY_ITEM
, SCHEDULE_LINE_NUMBER SCHEDULE_LINE_NUMBER
, HORIZON_START_DATE HORIZON_START_DATE
, HORIZON_END_DATE HORIZON_END_DATE
, ORDER_HEADER_ID ORDER_HEADER_ID
, ORDER_LINE_ID ORDER_LINE_ID
, REQUEST_DATE REQUEST_DATE
, INDUSTRY_ATTRIBUTE1 INDUSTRY_ATTRIBUTE1
, SCHEDULE_DATE SCHEDULE_DATE
, CUST_PO_NUMBER CUST_PO_NUMBER
, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE
, CUST_PRODUCTION_LINE CUST_PRODUCTION_LINE
, PURGE_STATUS PURGE_STATUS
, ORIGIN_TABLE ORIGIN_TABLE
, REPORT_SUMMARY REPORT_SUMMARY
FROM "RLM"."RLM_DEMAND_EXCEPTIONS"