VIEW: APPS.OE_WF_LINE_ASSIGN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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