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_WL_RESULTS_V

Object Details

Object Name:	MSC_WL_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	Mandatory	Comments
QUERY_ID	NUMBER		Yes	Query id
QUERY_TYPE	NUMBER		Yes	Query Type
PLAN_ID	NUMBER		Yes	Plan ID
SR_INSTANCE_ID	NUMBER		Yes	Instance ID
ORGANIZATION_ID	NUMBER		Yes	Organization ID
EXCEPTION_TYPE	NUMBER			Exception Type
SOURCE_TYPE	NUMBER			Source Type, 1- ascp, 2- cp
EXCEPTION_TYPE_TEXT	VARCHAR2	(4000)		Exception Text
EXCEPTION_COUNT	NUMBER			Exception count
INVENTORY_ITEM_ID	NUMBER			Item Id
ITEM_NAME	VARCHAR2	(4000)		Item Name
ITEM_DESC	VARCHAR2	(4000)		Item Description
SUPPLIER_ID	NUMBER			Supplier ID
SUPPLIER_SITE_ID	NUMBER			Supplier Site ID
SUPPLIER_NAME	VARCHAR2	(4000)		Supplier Name
SUPPLIER_SITE_NAME	VARCHAR2	(4000)		Supplier Site Name
CUSTOMER_ID	NUMBER
CUSTOMER_SITE_ID	NUMBER
CUSTOMER_NAME	VARCHAR2	(4000)
CUSTOMER_SITE_NAME	VARCHAR2	(4000)
ORG_CODE	VARCHAR2	(4000)		Org Code
CATEGORY_NAME	VARCHAR2	(4000)
PLANNER_CODE	VARCHAR2	(10)
SEQUENCE_ID	NUMBER			Sequence ID
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
GROUPBY_ORG	VARCHAR2	(10)		Group By: Org
GROUPBY_ITEM	VARCHAR2	(250)		Group By: Item
GROUPBY_CATEGORY	VARCHAR2	(250)		Group By: Category
GROUPBY_PLANNER	VARCHAR2	(250)		Group By: Planner
GROUPBY_CUSTOMER	VARCHAR2	(250)		Group By: Customer
GROUPBY_CUSTOMER_SITE	VARCHAR2	(250)
GROUPBY_SUPPLIER	VARCHAR2	(250)		Group By: Suppleir
GROUPBY_SUPPLIER_SITE	VARCHAR2	(250)
PRIORITY	NUMBER
DETAIL_QUERY_ID	NUMBER
TRANSACTION_ID	NUMBER			Transaction identifier related to Order query results
CATEGORY_ID	NUMBER			Category identifier related to items in Worklist results

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
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_NAME
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      CUSTOMER_NAME
,      CUSTOMER_SITE_NAME
,      ORG_CODE
,      CATEGORY_NAME
,      PLANNER_CODE
,      SEQUENCE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      GROUPBY_ORG
,      GROUPBY_ITEM
,      GROUPBY_CATEGORY
,      GROUPBY_PLANNER
,      GROUPBY_CUSTOMER
,      GROUPBY_CUSTOMER_SITE
,      GROUPBY_SUPPLIER
,      GROUPBY_SUPPLIER_SITE
,      PRIORITY
,      DETAIL_QUERY_ID
,      TRANSACTION_ID
,      CATEGORY_ID
FROM APPS.MSC_WL_RESULTS_V;

Dependencies

[top of page]

APPS.MSC_WL_RESULTS_V references the following:

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

APPS.MSC_WL_RESULTS_V is not referenced by any database object