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: APPS.MSC_PQ_RESULTS_V

Object Details

Object Name:	MSC_PQ_RESULTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
QUERY_ID	NUMBER
QUERY_TYPE	NUMBER
PLAN_ID	NUMBER
SR_INSTANCE_ID	NUMBER
ORGANIZATION_ID	NUMBER
EXCEPTION_TYPE	NUMBER
SOURCE_TYPE	NUMBER
EXCEPTION_TYPE_TEXT	VARCHAR2	(4000)
EXCEPTION_COUNT	NUMBER
INVENTORY_ITEM_ID	NUMBER
ITEM_NAME	VARCHAR2	(4000)
ITEM_DESC	VARCHAR2	(4000)
DEPARTMENT_ID	NUMBER
DEPARTMENT_CODE	VARCHAR2	(4000)
RESOURCE_ID	NUMBER
RESOURCE_CODE	VARCHAR2	(4000)
RESOURCE_DESC	VARCHAR2	(4000)
RESOURCE_TYPE	NUMBER		resource type
SUPPLIER_ID	NUMBER
SUPPLIER_SITE_ID	NUMBER
SUPPLIER_NAME	VARCHAR2	(4000)
SUPPLIER_SITE_NAME	VARCHAR2	(4000)
ORG_CODE	VARCHAR2	(4000)
FROM_ORG_ID	NUMBER		From Org Id
FROM_ORG_INSTANCE_ID	NUMBER		From Org Instance Id
FROM_ORG_CODE	VARCHAR2	(4000)	From Org Code
TO_ORG_ID	NUMBER		To Org Org Id
TO_ORG_INSTANCE_ID	NUMBER		To Org Instance Id
TO_ORG_CODE	VARCHAR2	(4000)	To Org Code
SHIPMENT_ID	NUMBER		Shipment Id
SEQUENCE_ID	NUMBER		Sequence Id
CREATED_BY	NUMBER
CREATION_DATE	DATE
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
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 Org
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUERY_ID
,      QUERY_TYPE
,      PLAN_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      EXCEPTION_TYPE
,      SOURCE_TYPE
,      EXCEPTION_TYPE_TEXT
,      EXCEPTION_COUNT
,      INVENTORY_ITEM_ID
,      ITEM_NAME
,      ITEM_DESC
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      RESOURCE_ID
,      RESOURCE_CODE
,      RESOURCE_DESC
,      RESOURCE_TYPE
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_NAME
,      ORG_CODE
,      FROM_ORG_ID
,      FROM_ORG_INSTANCE_ID
,      FROM_ORG_CODE
,      TO_ORG_ID
,      TO_ORG_INSTANCE_ID
,      TO_ORG_CODE
,      SHIPMENT_ID
,      SEQUENCE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      GROUPBY_ORG
,      GROUPBY_ITEM
,      GROUPBY_SUPPLY_ITEM
,      GROUPBY_CATEGORY
,      GROUPBY_PLANNER
,      GROUPBY_DEPT
,      GROUPBY_RES
,      GROUPBY_CUSTOMER
,      GROUPBY_SUPPLIER
FROM APPS.MSC_PQ_RESULTS_V;

Dependencies

[top of page]

APPS.MSC_PQ_RESULTS_V references the following:

APPS: MSC_GET_NAME - show dependent code; MSC_PERSONAL_QUERIES; MSC_PLANS; MSC_PQ_RESULTS; MSC_PQ_TYPES

APPS.MSC_PQ_RESULTS_V is not referenced by any database object