View: OE_WF_ORDER_ASSIGN_V

Product:	ONT - Order Management
Description:	View to show workflow assignments for a order transaction type and is used by UI.
Implementation/DBA Data:	APPS.OE_WF_ORDER_ASSIGN_V

View Text

SELECT WF.ASSIGNMENT_ID
, WF.ORDER_TYPE_ID
, VL.NAME
, WF.WF_ITEM_TYPE
FROM OE_WORKFLOW_ASSIGNMENTS WF
, OE_TRANSACTION_TYPES_VL VL
WHERE WF.ORDER_TYPE_ID = VL.TRANSACTION_TYPE_ID
AND WF.LINE_TYPE_ID IS NOT NULL

Columns