[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_PQ_RESULTS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_PQ_RESULTS
|
| Subobject Name: | |
| Status: | VALID |
Stores results of different types of personal queries.
| Tablespace: |  |
|---|---|
| PCT Free: | |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| QUERY_ID | NUMBER | Yes | Query Id | |
| PLAN_ID | NUMBER | Yes | Plan Id | |
| ORGANIZATION_ID | NUMBER | Yes | Organization Id | |
| SR_INSTANCE_ID | NUMBER | Yes | Source Instance Id | |
| SUMMARY_DATA | NUMBER | Summary Data | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory Item Id | ||
| EXCEPTION_TYPE | NUMBER | Exception Type | ||
| EXCEPTION_ID | NUMBER | Exception Id | ||
| DEPARTMENT_ID | NUMBER | Department Id | ||
| SUPPLIER_ID | NUMBER | Supplier Id | ||
| RESOURCE_ID | NUMBER | Resource Id | ||
| SUPPLIER_SITE_ID | NUMBER | Supplier Site Id | ||
| CATEGORY_ID | NUMBER | Category Id | ||
| EXCEPTION_COUNT | NUMBER | Exception Count | ||
| SOURCE_TYPE | NUMBER | Source Type | ||
| CREATED_BY | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| RESOURCE_TYPE | NUMBER | Resource Type | ||
| FROM_ORG_ID | NUMBER | From Organization Id | ||
| FROM_ORG_INSTANCE_ID | NUMBER | From Organization Instance Id | ||
| TO_ORG_ID | NUMBER | To Organization Id | ||
| TO_ORG_INSTANCE_ID | NUMBER | To Organization Instance Id | ||
| SHIPMENT_ID | NUMBER | Shipment Id | ||
| CHAR1 | VARCHAR2 | (2000) | Char1 | |
| CHAR2 | VARCHAR2 | (2000) | Char2 | |
| CHAR3 | VARCHAR2 | (2000) | Char3 | |
| CHAR4 | VARCHAR2 | (2000) | Char4 | |
| CHAR5 | VARCHAR2 | (2000) | Char5 | |
| GROUPBY_ORG | VARCHAR2 | (10) | Groupby Organization | |
| GROUPBY_ITEM | VARCHAR2 | (250) | Groupby Item | |
| GROUPBY_SUPPLY_ITEM | VARCHAR2 | (250) | Groupby Supply Item | |
| GROUPBY_CATEGORY | VARCHAR2 | (250) | Groupby Category | |
| GROUPBY_PLANNER | VARCHAR2 | (250) | Groupby Planner | |
| GROUPBY_DEPT | VARCHAR2 | (250) | Groupby Department | |
| GROUPBY_RES | VARCHAR2 | (250) | Groupby Resource | |
| GROUPBY_CUSTOMER | VARCHAR2 | (250) | Groupby Customer | |
| GROUPBY_SUPPLIER | VARCHAR2 | (250) | Groupby Supplier | |
| SEQUENCE_ID | NUMBER | Sequence Id | ||
| 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) |
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
FROM MSC.MSC_PQ_RESULTS;
MSC.MSC_PQ_RESULTS does not reference any database object
MSC.MSC_PQ_RESULTS is referenced by following:
APPS
MSC_PQ_RESULTS
|
|
|
|