VIEW: MSC.MSC_ITEM_EXCEPTIONS#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, VERSION VERSION, PLANNING_GROUP PLANNING_GROUP, EXCEPTION_TYPE EXCEPTION_TYPE, DISPLAY DISPLAY, EXCEPTION_COUNT EXCEPTION_COUNT, RESOURCE_ID RESOURCE_ID, DEPARTMENT_ID DEPARTMENT_ID, EXCEPTION_GROUP EXCEPTION_GROUP, 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, NEW_EXCEPTION_COUNT NEW_EXCEPTION_COUNT, COMPANY_ID COMPANY_ID, COMPANY_SITE_ID COMPANY_SITE_ID from "MSC"."MSC_ITEM_EXCEPTIONS"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, VERSION VERSION
, PLANNING_GROUP PLANNING_GROUP
, EXCEPTION_TYPE EXCEPTION_TYPE
, DISPLAY DISPLAY
, EXCEPTION_COUNT EXCEPTION_COUNT
, RESOURCE_ID RESOURCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
, EXCEPTION_GROUP EXCEPTION_GROUP
, 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
, NEW_EXCEPTION_COUNT NEW_EXCEPTION_COUNT
, COMPANY_ID COMPANY_ID
, COMPANY_SITE_ID COMPANY_SITE_ID
FROM "MSC"."MSC_ITEM_EXCEPTIONS"