VIEW: MSC.MSC_EXC_DETAILS_ALL#

Source

View Text - Preformatted

select EXCEPTION_DETAIL_ID EXCEPTION_DETAIL_ID, EXCEPTION_TYPE EXCEPTION_TYPE, QUANTITY QUANTITY, ID_KEY ID_KEY, COMPARE_KEY COMPARE_KEY, DATE1 DATE1, DATE2 DATE2, DATE3 DATE3, DATE4 DATE4, DATE5 DATE5, NUMBER1 NUMBER1, NUMBER2 NUMBER2, NUMBER3 NUMBER3, NUMBER4 NUMBER4, NUMBER5 NUMBER5, NUMBER6 NUMBER6, CHAR1 CHAR1, CHAR2 CHAR2, CHAR3 CHAR3, CHAR4 CHAR4, CHAR5 CHAR5, CHAR6 CHAR6, CHAR7 CHAR7, CHAR8 CHAR8, CHAR9 CHAR9, CHAR10 CHAR10, CHAR11 CHAR11, CHAR12 CHAR12, CHAR13 CHAR13, PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_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, LOAD_RATIO LOAD_RATIO, ORGANIZATION_CODE ORGANIZATION_CODE from "MSC"."MSC_EXC_DETAILS_ALL"

View Text - HTML Formatted

SELECT EXCEPTION_DETAIL_ID EXCEPTION_DETAIL_ID
, EXCEPTION_TYPE EXCEPTION_TYPE
, QUANTITY QUANTITY
, ID_KEY ID_KEY
, COMPARE_KEY COMPARE_KEY
, DATE1 DATE1
, DATE2 DATE2
, DATE3 DATE3
, DATE4 DATE4
, DATE5 DATE5
, NUMBER1 NUMBER1
, NUMBER2 NUMBER2
, NUMBER3 NUMBER3
, NUMBER4 NUMBER4
, NUMBER5 NUMBER5
, NUMBER6 NUMBER6
, CHAR1 CHAR1
, CHAR2 CHAR2
, CHAR3 CHAR3
, CHAR4 CHAR4
, CHAR5 CHAR5
, CHAR6 CHAR6
, CHAR7 CHAR7
, CHAR8 CHAR8
, CHAR9 CHAR9
, CHAR10 CHAR10
, CHAR11 CHAR11
, CHAR12 CHAR12
, CHAR13 CHAR13
, PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_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
, LOAD_RATIO LOAD_RATIO
, ORGANIZATION_CODE ORGANIZATION_CODE
FROM "MSC"."MSC_EXC_DETAILS_ALL"