VIEW: APPS.OE_WF_ORDER_ASSIGN_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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