VIEW: MSC.MSC_EXCEPTIONS_F#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, PLAN_RUN_ID PLAN_RUN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, 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_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, 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, OWNING_ORG_ID OWNING_ORG_ID, OWNING_INST_ID OWNING_INST_ID, CUSTOMER_REGION_ID CUSTOMER_REGION_ID, SUPPLIER_REGION_ID SUPPLIER_REGION_ID, SHIP_METHOD SHIP_METHOD, AGGR_TYPE AGGR_TYPE, CATEGORY_SET_ID CATEGORY_SET_ID, SR_CATEGORY_ID SR_CATEGORY_ID, VMI_FLAG VMI_FLAG, ORDER_TYPE ORDER_TYPE from "MSC"."MSC_EXCEPTIONS_F"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, PLAN_RUN_ID PLAN_RUN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, 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_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, 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
, OWNING_ORG_ID OWNING_ORG_ID
, OWNING_INST_ID OWNING_INST_ID
, CUSTOMER_REGION_ID CUSTOMER_REGION_ID
, SUPPLIER_REGION_ID SUPPLIER_REGION_ID
, SHIP_METHOD SHIP_METHOD
, AGGR_TYPE AGGR_TYPE
, CATEGORY_SET_ID CATEGORY_SET_ID
, SR_CATEGORY_ID SR_CATEGORY_ID
, VMI_FLAG VMI_FLAG
, ORDER_TYPE ORDER_TYPE
FROM "MSC"."MSC_EXCEPTIONS_F"