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_X_EXCEPTION_SEARCH_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER			Plan identifier
SR_INSTANCE_ID	NUMBER			Source application instance identifier
EXCEPTION_GROUP	NUMBER			Exception group
EXCEPTION_GROUP_NAME	VARCHAR2	(80)		Exception group name
COMPANY_ID	NUMBER			Company identifier
COMPANY_NAME	VARCHAR2	(255)		Company name
COMPANY_SITE_ID	NUMBER			Company site identifier
SUPPLIER_ID	NUMBER			Supplier identifier
SUPPLIER_SITE_ID	NUMBER			Supplier site identifier
CUSTOMER_ID	NUMBER			Customer identifier
CUSTOMER_SITE_ID	NUMBER			Customer site identifier
TRANSACTION_ID1	NUMBER			Transaction identifier 1
TRANSACTION_ID2	NUMBER			Transaction idenfitifier 2
TRANSACTION_ID3	NUMBER			Transaction identifier 3
VERSION	VARCHAR2	(80)		Version
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
TRADING_PARTNER_ITEM_NAME	VARCHAR2	(250)		Trading partner item name
COMPANY_SITE_NAME	VARCHAR2	(40)		Company site name
CUSTOMER_NAME	VARCHAR2	(255)		Customer name
CUSTOMER_SITE_NAME	VARCHAR2	(40)		Customer site name
SUPPLIER_NAME	VARCHAR2	(255)		Supplier name
SUPPLIER_SITE_NAME	VARCHAR2	(40)		Supplier site name
ITEM_NAME	VARCHAR2	(250)		Item name
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
CUSTOMER_ITEM_NAME	VARCHAR2	(250)		Customer item name
SUPPLIER_ITEM_NAME	VARCHAR2	(250)		Supplier item name
DATE1	DATE			Date 1
DATE2	DATE			Date 2
DATE3	DATE			Date 3
DATE4	DATE			Date 4
DATE5	DATE			Date 5
DATE6	DATE			Date 6
DATE7	DATE			Date 7
ORDER_CREATION_DATE1	DATE			Order creation date 1
ORDER_CREATION_DATE2	DATE			Order creation date 2
ITEM_MIN_QTY	NUMBER
ITEM_MAX_QTY	NUMBER
NUMBER1	NUMBER
NUMBER2	NUMBER
NUMBER3	NUMBER
NUMBER4	NUMBER
NUMBER5	NUMBER
NUMBER6	NUMBER
NUMBER7	NUMBER
NUMBER8	NUMBER
NUMBER9	NUMBER
NUMBER10	NUMBER
THRESHOLD	NUMBER
LEAD_TIME	NUMBER
ORDER_NUMBER	VARCHAR2	(240)
LINE_NUMBER	VARCHAR2	(20)
RELEASE_NUMBER	VARCHAR2	(20)
END_ORDER_NUMBER	VARCHAR2	(240)
END_ORDER_LINE_NUMBER	VARCHAR2	(20)
END_ORDER_REL_NUMBER	VARCHAR2	(20)
DAYS_DIFFERENCE	NUMBER
DAYS_PAST_DUE	NUMBER
COMPRESSION_DAYS	NUMBER
QUANTITY_DIFFERENCE	NUMBER
VMI_SHORTAGE	NUMBER
VMI_EXCESS	NUMBER
EXCEPTION_TYPE	NUMBER
EXCEPTION_DETAIL_ID	NUMBER		Yes
INVENTORY_ITEM_ID	NUMBER
REPLENISHMENT_METHOD	NUMBER
EXCEPTION_BASIS	VARCHAR2	(100)
EXCEPTION_TYPE_NAME	VARCHAR2	(80)
OWNING_COMPANY_ID	NUMBER
PLANNER_CODE	VARCHAR2	(10)
BUYER_NAME	VARCHAR2	(240)

Query Text

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


SELECT PLAN_ID
,      SR_INSTANCE_ID
,      EXCEPTION_GROUP
,      EXCEPTION_GROUP_NAME
,      COMPANY_ID
,      COMPANY_NAME
,      COMPANY_SITE_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      TRANSACTION_ID1
,      TRANSACTION_ID2
,      TRANSACTION_ID3
,      VERSION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRADING_PARTNER_ITEM_NAME
,      COMPANY_SITE_NAME
,      CUSTOMER_NAME
,      CUSTOMER_SITE_NAME
,      SUPPLIER_NAME
,      SUPPLIER_SITE_NAME
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      CUSTOMER_ITEM_NAME
,      SUPPLIER_ITEM_NAME
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      DATE6
,      DATE7
,      ORDER_CREATION_DATE1
,      ORDER_CREATION_DATE2
,      ITEM_MIN_QTY
,      ITEM_MAX_QTY
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      THRESHOLD
,      LEAD_TIME
,      ORDER_NUMBER
,      LINE_NUMBER
,      RELEASE_NUMBER
,      END_ORDER_NUMBER
,      END_ORDER_LINE_NUMBER
,      END_ORDER_REL_NUMBER
,      DAYS_DIFFERENCE
,      DAYS_PAST_DUE
,      COMPRESSION_DAYS
,      QUANTITY_DIFFERENCE
,      VMI_SHORTAGE
,      VMI_EXCESS
,      EXCEPTION_TYPE
,      EXCEPTION_DETAIL_ID
,      INVENTORY_ITEM_ID
,      REPLENISHMENT_METHOD
,      EXCEPTION_BASIS
,      EXCEPTION_TYPE_NAME
,      OWNING_COMPANY_ID
,      PLANNER_CODE
,      BUYER_NAME
FROM APPS.MSC_X_EXCEPTION_SEARCH_V;

Dependencies

[top of page]

APPS.MSC_X_EXCEPTION_SEARCH_V references the following:

APPS: MSC_COMPANY_SITES; MSC_SYSTEM_ITEMS; MSC_TRADING_PARTNERS; MSC_TRADING_PARTNER_MAPS; MSC_X_EXCEPTION_DETAILS

APPS.MSC_X_EXCEPTION_SEARCH_V is not referenced by any database object