VIEW: MSC.MSC_PQ_RESULTS#

Source

View Text - Preformatted

select QUERY_ID QUERY_ID, PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, SUMMARY_DATA SUMMARY_DATA, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, EXCEPTION_TYPE EXCEPTION_TYPE, EXCEPTION_ID EXCEPTION_ID, DEPARTMENT_ID DEPARTMENT_ID, SUPPLIER_ID SUPPLIER_ID, RESOURCE_ID RESOURCE_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, CATEGORY_ID CATEGORY_ID, EXCEPTION_COUNT EXCEPTION_COUNT, SOURCE_TYPE SOURCE_TYPE, 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, RESOURCE_TYPE RESOURCE_TYPE, FROM_ORG_ID FROM_ORG_ID, FROM_ORG_INSTANCE_ID FROM_ORG_INSTANCE_ID, TO_ORG_ID TO_ORG_ID, TO_ORG_INSTANCE_ID TO_ORG_INSTANCE_ID, SHIPMENT_ID SHIPMENT_ID, CHAR1 CHAR1, CHAR2 CHAR2, CHAR3 CHAR3, CHAR4 CHAR4, CHAR5 CHAR5, GROUPBY_ORG GROUPBY_ORG, GROUPBY_ITEM GROUPBY_ITEM, GROUPBY_SUPPLY_ITEM GROUPBY_SUPPLY_ITEM, GROUPBY_CATEGORY GROUPBY_CATEGORY, GROUPBY_PLANNER GROUPBY_PLANNER, GROUPBY_DEPT GROUPBY_DEPT, GROUPBY_RES GROUPBY_RES, GROUPBY_CUSTOMER GROUPBY_CUSTOMER, GROUPBY_SUPPLIER GROUPBY_SUPPLIER, SEQUENCE_ID SEQUENCE_ID, TRANSACTION_ID TRANSACTION_ID, DETAIL_QUERY_ID DETAIL_QUERY_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, PRIORITY PRIORITY, GROUPBY_SUPPLIER_SITE GROUPBY_SUPPLIER_SITE, GROUPBY_CUSTOMER_SITE GROUPBY_CUSTOMER_SITE, PLANNER_CODE PLANNER_CODE, SOURCE_TABLE SOURCE_TABLE, ORDER_TYPE ORDER_TYPE, ROW_ID ROW_ID from "MSC"."MSC_PQ_RESULTS"

View Text - HTML Formatted

SELECT QUERY_ID QUERY_ID
, PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, SUMMARY_DATA SUMMARY_DATA
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, EXCEPTION_TYPE EXCEPTION_TYPE
, EXCEPTION_ID EXCEPTION_ID
, DEPARTMENT_ID DEPARTMENT_ID
, SUPPLIER_ID SUPPLIER_ID
, RESOURCE_ID RESOURCE_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, CATEGORY_ID CATEGORY_ID
, EXCEPTION_COUNT EXCEPTION_COUNT
, SOURCE_TYPE SOURCE_TYPE
, 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
, RESOURCE_TYPE RESOURCE_TYPE
, FROM_ORG_ID FROM_ORG_ID
, FROM_ORG_INSTANCE_ID FROM_ORG_INSTANCE_ID
, TO_ORG_ID TO_ORG_ID
, TO_ORG_INSTANCE_ID TO_ORG_INSTANCE_ID
, SHIPMENT_ID SHIPMENT_ID
, CHAR1 CHAR1
, CHAR2 CHAR2
, CHAR3 CHAR3
, CHAR4 CHAR4
, CHAR5 CHAR5
, GROUPBY_ORG GROUPBY_ORG
, GROUPBY_ITEM GROUPBY_ITEM
, GROUPBY_SUPPLY_ITEM GROUPBY_SUPPLY_ITEM
, GROUPBY_CATEGORY GROUPBY_CATEGORY
, GROUPBY_PLANNER GROUPBY_PLANNER
, GROUPBY_DEPT GROUPBY_DEPT
, GROUPBY_RES GROUPBY_RES
, GROUPBY_CUSTOMER GROUPBY_CUSTOMER
, GROUPBY_SUPPLIER GROUPBY_SUPPLIER
, SEQUENCE_ID SEQUENCE_ID
, TRANSACTION_ID TRANSACTION_ID
, DETAIL_QUERY_ID DETAIL_QUERY_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, PRIORITY PRIORITY
, GROUPBY_SUPPLIER_SITE GROUPBY_SUPPLIER_SITE
, GROUPBY_CUSTOMER_SITE GROUPBY_CUSTOMER_SITE
, PLANNER_CODE PLANNER_CODE
, SOURCE_TABLE SOURCE_TABLE
, ORDER_TYPE ORDER_TYPE
, ROW_ID ROW_ID
FROM "MSC"."MSC_PQ_RESULTS"