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.WMS_WAVEPLAN_TASK_EXCEPTIONS_V

Object Details

Object Name:	WMS_WAVEPLAN_TASK_EXCEPTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WMS.WMS_WAVEPLAN_TASK_EXCEPTIONS_V
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
ORGANIZATION_ID	NUMBER		Organization identifier
TASK_ID	NUMBER		Task Identifier
TRANSACTION_ID	NUMBER
REASON_ID	NUMBER		Reason Identifier
REASON_NAME	VARCHAR2	(30)	Reason Name
REASON_DESCRIPTION	VARCHAR2	(240)	Reason Description
EXCEPTION_TIME	DATE		Exception Time
PERSON_ID	NUMBER		Employee Identifier of the person who generated the exception
FULL_NAME	VARCHAR2	(240)	Full Name of the person who generated the exception
SUBINVENTORY_CODE	VARCHAR2	(10)	Subinventory Code for the generated exception
LOCATOR_ID	NUMBER		Locator Identifier for the generated exception
LOCATOR	CHAR	(1)	Locator for the generated exception
INVENTORY_ITEM_ID	NUMBER		Inventory Item Identifier for the generated exception
ITEM	VARCHAR2	(40)	Inventory Item for the generated exception
LINE_ID	NUMBER
MOVE_ORDER_LINE_NUMBER	NUMBER
MOVE_ORDER_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT ORGANIZATION_ID
,      TASK_ID
,      TRANSACTION_ID
,      REASON_ID
,      REASON_NAME
,      REASON_DESCRIPTION
,      EXCEPTION_TIME
,      PERSON_ID
,      FULL_NAME
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOCATOR
,      INVENTORY_ITEM_ID
,      ITEM
,      LINE_ID
,      MOVE_ORDER_LINE_NUMBER
,      MOVE_ORDER_NUMBER
FROM APPS.WMS_WAVEPLAN_TASK_EXCEPTIONS_V;

Dependencies

[top of page]

APPS.WMS_WAVEPLAN_TASK_EXCEPTIONS_V references the following:

APPS: MTL_ITEM_LOCATIONS_KFV; MTL_MATERIAL_TRANSACTIONS; MTL_SYSTEM_ITEMS_KFV; MTL_TRANSACTION_REASONS; MTL_TXN_REQUEST_HEADERS; MTL_TXN_REQUEST_LINES; PER_ALL_PEOPLE_F; WMS_DISPATCHED_TASKS; WMS_DISPATCHED_TASKS_HISTORY; WMS_EXCEPTIONS; WMS_WAVEPLAN_TASKS_TEMP

APPS.WMS_WAVEPLAN_TASK_EXCEPTIONS_V is not referenced by any database object