[Home] [Help] [Dependency Information]
Object Name: | MSC_PQ_RESULTS# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_ID | NUMBER | Yes | ||
PLAN_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
SR_INSTANCE_ID | NUMBER | Yes | ||
SUMMARY_DATA | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
EXCEPTION_TYPE | NUMBER | |||
EXCEPTION_ID | NUMBER | |||
DEPARTMENT_ID | NUMBER | |||
SUPPLIER_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
SUPPLIER_SITE_ID | NUMBER | |||
CATEGORY_ID | NUMBER | |||
EXCEPTION_COUNT | NUMBER | |||
SOURCE_TYPE | NUMBER | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
RESOURCE_TYPE | NUMBER | |||
FROM_ORG_ID | NUMBER | |||
FROM_ORG_INSTANCE_ID | NUMBER | |||
TO_ORG_ID | NUMBER | |||
TO_ORG_INSTANCE_ID | NUMBER | |||
SHIPMENT_ID | NUMBER | |||
CHAR1 | VARCHAR2 | (2000) | ||
CHAR2 | VARCHAR2 | (2000) | ||
CHAR3 | VARCHAR2 | (2000) | ||
CHAR4 | VARCHAR2 | (2000) | ||
CHAR5 | VARCHAR2 | (2000) | ||
GROUPBY_ORG | VARCHAR2 | (10) | ||
GROUPBY_ITEM | VARCHAR2 | (250) | ||
GROUPBY_SUPPLY_ITEM | VARCHAR2 | (250) | ||
GROUPBY_CATEGORY | VARCHAR2 | (250) | ||
GROUPBY_PLANNER | VARCHAR2 | (250) | ||
GROUPBY_DEPT | VARCHAR2 | (250) | ||
GROUPBY_RES | VARCHAR2 | (250) | ||
GROUPBY_CUSTOMER | VARCHAR2 | (250) | ||
GROUPBY_SUPPLIER | VARCHAR2 | (250) | ||
SEQUENCE_ID | NUMBER | |||
TRANSACTION_ID | NUMBER | |||
DETAIL_QUERY_ID | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
CUSTOMER_SITE_ID | NUMBER | |||
PRIORITY | NUMBER | |||
GROUPBY_SUPPLIER_SITE | VARCHAR2 | (250) | ||
GROUPBY_CUSTOMER_SITE | VARCHAR2 | (250) | ||
PLANNER_CODE | VARCHAR2 | (10) | ||
SOURCE_TABLE | VARCHAR2 | (30) | ||
ORDER_TYPE | NUMBER | |||
ROW_ID | ROWID | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT QUERY_ID
, PLAN_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, SUMMARY_DATA
, INVENTORY_ITEM_ID
, EXCEPTION_TYPE
, EXCEPTION_ID
, DEPARTMENT_ID
, SUPPLIER_ID
, RESOURCE_ID
, SUPPLIER_SITE_ID
, CATEGORY_ID
, EXCEPTION_COUNT
, SOURCE_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RESOURCE_TYPE
, FROM_ORG_ID
, FROM_ORG_INSTANCE_ID
, TO_ORG_ID
, TO_ORG_INSTANCE_ID
, SHIPMENT_ID
, CHAR1
, CHAR2
, CHAR3
, CHAR4
, CHAR5
, GROUPBY_ORG
, GROUPBY_ITEM
, GROUPBY_SUPPLY_ITEM
, GROUPBY_CATEGORY
, GROUPBY_PLANNER
, GROUPBY_DEPT
, GROUPBY_RES
, GROUPBY_CUSTOMER
, GROUPBY_SUPPLIER
, SEQUENCE_ID
, TRANSACTION_ID
, DETAIL_QUERY_ID
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, PRIORITY
, GROUPBY_SUPPLIER_SITE
, GROUPBY_CUSTOMER_SITE
, PLANNER_CODE
, SOURCE_TABLE
, ORDER_TYPE
, ROW_ID
FROM MSC.MSC_PQ_RESULTS#;
|
|
|