View: OE_WF_LINE_ASSIGN_V

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

View Text

SELECT WF.ASSIGNMENT_ID
, WF.ORDER_TYPE_ID
, WF.LINE_TYPE_ID
, VL.NAME
, WF.PROCESS_NAME
, WF.START_DATE_ACTIVE
, WF.END_DATE_ACTIVE
, WF.CREATION_DATE
, WF.CREATED_BY
, WF.LAST_UPDATE_DATE
, WF.LAST_UPDATED_BY
, WF.LAST_UPDATE_LOGIN
, WF.PROGRAM_APPLICATION_ID
, WF.PROGRAM_ID
, WF.REQUEST_ID
, WF.ITEM_TYPE_CODE
, WF.WF_ITEM_TYPE
, WF.CONTEXT
, WF.ATTRIBUTE1
, WF.ATTRIBUTE2
, WF.ATTRIBUTE3
, WF.ATTRIBUTE4
, WF.ATTRIBUTE5
, WF.ATTRIBUTE6
, WF.ATTRIBUTE7
, WF.ATTRIBUTE8
, WF.ATTRIBUTE9
, WF.ATTRIBUTE10
, WF.ATTRIBUTE11
, WF.ATTRIBUTE12
, WF.ATTRIBUTE13
, WF.ATTRIBUTE14
, WF.ATTRIBUTE15
FROM OE_WORKFLOW_ASSIGNMENTS WF
, OE_TRANSACTION_TYPES_VL VL
WHERE WF.LINE_TYPE_ID = VL.TRANSACTION_TYPE_ID
AND WF.LINE_TYPE_ID IS NOT NULL

Columns