ENQ_WORKFLOW_OTBI_VL

Details

• Schema: FUSION

• Object owner: ENQ

• Object type: VIEW

Columns

Name
OBJECT_PK1 STATUS_NAME STATUS_TYPE STATUS_TYPE_NAME SUB_STATUS_NAME SUB_STATUS_TYPE NAME OBJECT_CODE

Query

SQL_Statement

SELECT WF.object_pk1, VL.STATUS_NAME, VL.STATUS_TYPE, VL1.STATUS_NAME STATUS_TYPE_NAME, SUBTYPE_VL.STATUS_NAME SUB_STATUS_NAME, SUBTYPE_VL.STATUS_TYPE SUB_STATUS_TYPE, TMPLTTL.NAME , OT.OBJECT_CODE FROM fusion.ACA_WF_INSTANCE WF, fusion.ACA_WF_STATUS_VL VL, fusion.ACA_WF_STATUS_VL SUBTYPE_VL, fusion.ACA_WF_TEMPLATE_B TMPLT, fusion.ACA_WF_TEMPLATE_TL TMPLTTL, fusion.aca_wf_object_types_b OT, fusion.ACA_WF_STATUS_VL VL1 WHERE (case when WF.STATUS_TYPE = 5 then 5 ELSE WF.STATUS_CODE END) = VL.STATUS_CODE AND TMPLT.WORKFLOW_TEMPLATE_ID = WF.WORKFLOW_TEMPLATE_ID AND TMPLT.WORKFLOW_TEMPLATE_ID = TMPLTTL.WORKFLOW_TEMPLATE_ID AND TMPLTTL.LANGUAGE = USERENV('LANG') AND wf.object_type_id = OT.object_type_id AND VL1.STATUS_CODE = VL.STATUS_TYPE AND (case when WF.Status_code = 0 then 0 ELSE WF.APPROVAL_STATUS_TYPE END) = SUBTYPE_VL.STATUS_TYPE