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

Object Details

Object Name:	OE_WF_ORDER_ASSIGN_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_WF_ORDER_ASSIGN_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View to show workflow assignments for a order transaction type and is used by UI.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_ID	NUMBER		Yes	Assignment ID
ORDER_TYPE_ID	NUMBER		Yes	Order Transaction Type
ORDER_TYPE_NAME	VARCHAR2	(30)	Yes	Name in translated language
WF_ITEM_TYPE	VARCHAR2	(30)		Item type of the Process name to identify if it is a quote flow or order flow

Query Text

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


SELECT ASSIGNMENT_ID
,      ORDER_TYPE_ID
,      ORDER_TYPE_NAME
,      WF_ITEM_TYPE
FROM APPS.OE_WF_ORDER_ASSIGN_V;

Dependencies

[top of page]

APPS.OE_WF_ORDER_ASSIGN_V references the following:

APPS: OE_TRANSACTION_TYPES_VL; OE_WORKFLOW_ASSIGNMENTS

APPS.OE_WF_ORDER_ASSIGN_V is referenced by following:

APPS: JAI_AR_IMPORT_POPU_PKG - show dependent code; JAI_AR_RCTLA_TRIGGER_PKG - show dependent code