VIEW: MSC.MSC_ST_EXCEPTIONS_F#

Source

View Text - Preformatted

select ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_CODE ERROR_CODE, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, OWNING_INST_ID OWNING_INST_ID, OWNING_ORG_ID OWNING_ORG_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, CUSTOMER_REGION_ID CUSTOMER_REGION_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_REGION_ID SUPPLIER_REGION_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, ORGANIZATION_CODE ORGANIZATION_CODE, OWNING_ORG_CODE OWNING_ORG_CODE, ITEM_NAME ITEM_NAME, DEPARTMENT_CODE DEPARTMENT_CODE, DEPARTMENT_CLASS DEPARTMENT_CLASS, RESOURCE_CODE RESOURCE_CODE, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE, CUSTOMER_ZONE CUSTOMER_ZONE, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, SUPPLIER_ZONE SUPPLIER_ZONE, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, SHIP_METHOD SHIP_METHOD, ANALYSIS_DATE ANALYSIS_DATE, EXCEPTION_TYPE EXCEPTION_TYPE, EXCEPTION_COUNT EXCEPTION_COUNT, EXCEPTION_VALUE EXCEPTION_VALUE, EXCEPTION_VALUE2 EXCEPTION_VALUE2, EXCEPTION_DAYS EXCEPTION_DAYS, EXCEPTION_QUANTITY EXCEPTION_QUANTITY, EXCEPTION_RATIO EXCEPTION_RATIO, 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, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, VMI_FLAG VMI_FLAG, ORDER_TYPE ORDER_TYPE from "MSC"."MSC_ST_EXCEPTIONS_F"

View Text - HTML Formatted

SELECT ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_CODE ERROR_CODE
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, OWNING_INST_ID OWNING_INST_ID
, OWNING_ORG_ID OWNING_ORG_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, CUSTOMER_REGION_ID CUSTOMER_REGION_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_REGION_ID SUPPLIER_REGION_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, OWNING_ORG_CODE OWNING_ORG_CODE
, ITEM_NAME ITEM_NAME
, DEPARTMENT_CODE DEPARTMENT_CODE
, DEPARTMENT_CLASS DEPARTMENT_CLASS
, RESOURCE_CODE RESOURCE_CODE
, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_SITE_CODE CUSTOMER_SITE_CODE
, CUSTOMER_ZONE CUSTOMER_ZONE
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, SUPPLIER_ZONE SUPPLIER_ZONE
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, SHIP_METHOD SHIP_METHOD
, ANALYSIS_DATE ANALYSIS_DATE
, EXCEPTION_TYPE EXCEPTION_TYPE
, EXCEPTION_COUNT EXCEPTION_COUNT
, EXCEPTION_VALUE EXCEPTION_VALUE
, EXCEPTION_VALUE2 EXCEPTION_VALUE2
, EXCEPTION_DAYS EXCEPTION_DAYS
, EXCEPTION_QUANTITY EXCEPTION_QUANTITY
, EXCEPTION_RATIO EXCEPTION_RATIO
, 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
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, VMI_FLAG VMI_FLAG
, ORDER_TYPE ORDER_TYPE
FROM "MSC"."MSC_ST_EXCEPTIONS_F"