VIEW: MSC.MSC_EXCEPTION_DETAILS#

Source

View Text - Preformatted

select EXCEPTION_DETAIL_ID EXCEPTION_DETAIL_ID, EXCEPTION_TYPE EXCEPTION_TYPE, QUANTITY QUANTITY, DATE1 DATE1, DATE2 DATE2, DATE3 DATE3, DATE4 DATE4, NUMBER1 NUMBER1, NUMBER2 NUMBER2, NUMBER3 NUMBER3, NUMBER4 NUMBER4, CHAR1 CHAR1, CHAR2 CHAR2, PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, RESOURCE_ID RESOURCE_ID, DEPARTMENT_ID DEPARTMENT_ID, SR_INSTANCE_ID SR_INSTANCE_ID, 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, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, ORDER_NUMBER ORDER_NUMBER, ORDER_REL_NUMBER ORDER_REL_NUMBER, ORDER_LINE_NUMBER ORDER_LINE_NUMBER, END_ORDER_NUMBER END_ORDER_NUMBER, END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER, DATE5 DATE5, NUMBER5 NUMBER5, TRANSACTION_ID TRANSACTION_ID, DEMAND_ID DEMAND_ID, ACTION_TAKEN ACTION_TAKEN, NUMBER6 NUMBER6, NUMBER7 NUMBER7, NUMBER8 NUMBER8, CAUSE CAUSE, NEW_EXCEPTION NEW_EXCEPTION, ACTION_TAKEN_BY ACTION_TAKEN_BY, ACTION_TAKEN_DATE ACTION_TAKEN_DATE, FIRST_GENERATED_DATE FIRST_GENERATED_DATE, PART_CONDITION PART_CONDITION, ZONE_ID ZONE_ID, DATE6 DATE6 from "MSC"."MSC_EXCEPTION_DETAILS"

View Text - HTML Formatted

SELECT EXCEPTION_DETAIL_ID EXCEPTION_DETAIL_ID
, EXCEPTION_TYPE EXCEPTION_TYPE
, QUANTITY QUANTITY
, DATE1 DATE1
, DATE2 DATE2
, DATE3 DATE3
, DATE4 DATE4
, NUMBER1 NUMBER1
, NUMBER2 NUMBER2
, NUMBER3 NUMBER3
, NUMBER4 NUMBER4
, CHAR1 CHAR1
, CHAR2 CHAR2
, PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, RESOURCE_ID RESOURCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, 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
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, ORDER_NUMBER ORDER_NUMBER
, ORDER_REL_NUMBER ORDER_REL_NUMBER
, ORDER_LINE_NUMBER ORDER_LINE_NUMBER
, END_ORDER_NUMBER END_ORDER_NUMBER
, END_ORDER_REL_NUMBER END_ORDER_REL_NUMBER
, END_ORDER_LINE_NUMBER END_ORDER_LINE_NUMBER
, DATE5 DATE5
, NUMBER5 NUMBER5
, TRANSACTION_ID TRANSACTION_ID
, DEMAND_ID DEMAND_ID
, ACTION_TAKEN ACTION_TAKEN
, NUMBER6 NUMBER6
, NUMBER7 NUMBER7
, NUMBER8 NUMBER8
, CAUSE CAUSE
, NEW_EXCEPTION NEW_EXCEPTION
, ACTION_TAKEN_BY ACTION_TAKEN_BY
, ACTION_TAKEN_DATE ACTION_TAKEN_DATE
, FIRST_GENERATED_DATE FIRST_GENERATED_DATE
, PART_CONDITION PART_CONDITION
, ZONE_ID ZONE_ID
, DATE6 DATE6
FROM "MSC"."MSC_EXCEPTION_DETAILS"