eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: MSC.MSC_PQ_RESULTS#

Object Details

Object Name:	MSC_PQ_RESULTS#
Object Type:	VIEW
Owner:	MSC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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#;

Dependencies

[top of page]

MSC.MSC_PQ_RESULTS# references the following:

MSC: MSC_PQ_RESULTS

MSC.MSC_PQ_RESULTS# is referenced by following:

APPS: MSC_PQ_RESULTS