VIEW: MSC.MSC_X_EXCEPTION_DETAILS#

Source

View Text - Preformatted

select EXCEPTION_DETAIL_ID EXCEPTION_DETAIL_ID, PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, EXCEPTION_TYPE EXCEPTION_TYPE, EXCEPTION_TYPE_NAME EXCEPTION_TYPE_NAME, EXCEPTION_GROUP EXCEPTION_GROUP, EXCEPTION_GROUP_NAME EXCEPTION_GROUP_NAME, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, COMPANY_SITE_ID COMPANY_SITE_ID, COMPANY_SITE_NAME COMPANY_SITE_NAME, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_NAME ITEM_NAME, TRADING_PARTNER_ITEM_NAME TRADING_PARTNER_ITEM_NAME, TRANSACTION_ID1 TRANSACTION_ID1, TRANSACTION_ID2 TRANSACTION_ID2, TRANSACTION_ID3 TRANSACTION_ID3, ORDER_NUMBER ORDER_NUMBER, RELEASE_NUMBER RELEASE_NUMBER, LINE_NUMBER LINE_NUMBER, END_ORDER_NUMBER END_ORDER_NUMBER, END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER, VERSION VERSION, ORDER_CREATION_DATE1 ORDER_CREATION_DATE1, ORDER_CREATION_DATE2 ORDER_CREATION_DATE2, DATE1 DATE1, DATE2 DATE2, DATE3 DATE3, DATE4 DATE4, DATE5 DATE5, DATE6 DATE6, DATE7 DATE7, NUMBER1 NUMBER1, NUMBER2 NUMBER2, NUMBER3 NUMBER3, NUMBER4 NUMBER4, NUMBER5 NUMBER5, NUMBER6 NUMBER6, NUMBER7 NUMBER7, LEAD_TIME LEAD_TIME, ITEM_MIN_QTY ITEM_MIN_QTY, ITEM_MAX_QTY ITEM_MAX_QTY, THRESHOLD THRESHOLD, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, USER_ATTRIBUTE6 USER_ATTRIBUTE6, USER_ATTRIBUTE7 USER_ATTRIBUTE7, USER_ATTRIBUTE8 USER_ATTRIBUTE8, USER_ATTRIBUTE9 USER_ATTRIBUTE9, USER_ATTRIBUTE10 USER_ATTRIBUTE10, USER_ATTRIBUTE11 USER_ATTRIBUTE11, USER_ATTRIBUTE12 USER_ATTRIBUTE12, USER_ATTRIBUTE13 USER_ATTRIBUTE13, USER_ATTRIBUTE14 USER_ATTRIBUTE14, USER_ATTRIBUTE15 USER_ATTRIBUTE15, USER_ATTRIBUTE16 USER_ATTRIBUTE16, USER_ATTRIBUTE17 USER_ATTRIBUTE17, USER_ATTRIBUTE18 USER_ATTRIBUTE18, USER_ATTRIBUTE19 USER_ATTRIBUTE19, USER_ATTRIBUTE20 USER_ATTRIBUTE20, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NUMBER8 NUMBER8, NUMBER9 NUMBER9, NUMBER10 NUMBER10, ITEM_DESCRIPTION ITEM_DESCRIPTION, OWNING_COMPANY_ID OWNING_COMPANY_ID, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME, REPLENISHMENT_METHOD REPLENISHMENT_METHOD, EXCEPTION_BASIS EXCEPTION_BASIS from "MSC"."MSC_X_EXCEPTION_DETAILS"

View Text - HTML Formatted

SELECT EXCEPTION_DETAIL_ID EXCEPTION_DETAIL_ID
, PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, EXCEPTION_TYPE EXCEPTION_TYPE
, EXCEPTION_TYPE_NAME EXCEPTION_TYPE_NAME
, EXCEPTION_GROUP EXCEPTION_GROUP
, EXCEPTION_GROUP_NAME EXCEPTION_GROUP_NAME
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, COMPANY_SITE_ID COMPANY_SITE_ID
, COMPANY_SITE_NAME COMPANY_SITE_NAME
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, CUSTOMER_SITE_NAME CUSTOMER_SITE_NAME
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_NAME ITEM_NAME
, TRADING_PARTNER_ITEM_NAME TRADING_PARTNER_ITEM_NAME
, TRANSACTION_ID1 TRANSACTION_ID1
, TRANSACTION_ID2 TRANSACTION_ID2
, TRANSACTION_ID3 TRANSACTION_ID3
, ORDER_NUMBER ORDER_NUMBER
, RELEASE_NUMBER RELEASE_NUMBER
, LINE_NUMBER LINE_NUMBER
, END_ORDER_NUMBER END_ORDER_NUMBER
, END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER
, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER
, VERSION VERSION
, ORDER_CREATION_DATE1 ORDER_CREATION_DATE1
, ORDER_CREATION_DATE2 ORDER_CREATION_DATE2
, DATE1 DATE1
, DATE2 DATE2
, DATE3 DATE3
, DATE4 DATE4
, DATE5 DATE5
, DATE6 DATE6
, DATE7 DATE7
, NUMBER1 NUMBER1
, NUMBER2 NUMBER2
, NUMBER3 NUMBER3
, NUMBER4 NUMBER4
, NUMBER5 NUMBER5
, NUMBER6 NUMBER6
, NUMBER7 NUMBER7
, LEAD_TIME LEAD_TIME
, ITEM_MIN_QTY ITEM_MIN_QTY
, ITEM_MAX_QTY ITEM_MAX_QTY
, THRESHOLD THRESHOLD
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, USER_ATTRIBUTE6 USER_ATTRIBUTE6
, USER_ATTRIBUTE7 USER_ATTRIBUTE7
, USER_ATTRIBUTE8 USER_ATTRIBUTE8
, USER_ATTRIBUTE9 USER_ATTRIBUTE9
, USER_ATTRIBUTE10 USER_ATTRIBUTE10
, USER_ATTRIBUTE11 USER_ATTRIBUTE11
, USER_ATTRIBUTE12 USER_ATTRIBUTE12
, USER_ATTRIBUTE13 USER_ATTRIBUTE13
, USER_ATTRIBUTE14 USER_ATTRIBUTE14
, USER_ATTRIBUTE15 USER_ATTRIBUTE15
, USER_ATTRIBUTE16 USER_ATTRIBUTE16
, USER_ATTRIBUTE17 USER_ATTRIBUTE17
, USER_ATTRIBUTE18 USER_ATTRIBUTE18
, USER_ATTRIBUTE19 USER_ATTRIBUTE19
, USER_ATTRIBUTE20 USER_ATTRIBUTE20
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NUMBER8 NUMBER8
, NUMBER9 NUMBER9
, NUMBER10 NUMBER10
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, OWNING_COMPANY_ID OWNING_COMPANY_ID
, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME
, SUPPLIER_ITEM_NAME SUPPLIER_ITEM_NAME
, REPLENISHMENT_METHOD REPLENISHMENT_METHOD
, EXCEPTION_BASIS EXCEPTION_BASIS
FROM "MSC"."MSC_X_EXCEPTION_DETAILS"