1. Tables and Views for SCM
  2. ENQ_ACTION_WORKFLOW_DATES_V

ENQ_ACTION_WORKFLOW_DATES_V

Details

  • Schema: FUSION

  • Object owner: ENQ

  • Object type: VIEW

Columns

Name

OBJECT_PK1

WORKFLOW_START_DATE

APPROVAL_WORKFLOW_START_DATE

WORKFLOW_END_DATE

Query

SQL_Statement

SELECT wf.object_pk1,

(SELECT MIN(start_date)

FROM fusion.ACA_WF_LIFECYCLE_STATUSES wf_status,

fusion.ACA_WF_STATUS_VL VL

WHERE wf_status.entity_id1 = wf.workflow_id

AND wf_status.STATUS_CODE IN (1,101)

AND VL.STATUS_CODE = wf_status.STATUS_CODE

AND VL.STATUS_TYPE = 1

) Workflow_Start_Date,

(SELECT MIN(start_date)

FROM fusion.ACA_WF_LIFECYCLE_STATUSES wf_appr_status,

fusion.ACA_WF_STATUS_VL appr_VL

WHERE wf_appr_status.entity_id1 = wf.workflow_id

AND wf_appr_status.STATUS_CODE IN (8,37)

AND appr_VL.STATUS_CODE = wf_appr_status.STATUS_CODE

AND appr_VL.STATUS_TYPE = 8

) Approval_Workflow_Start_Date,

(SELECT MAX(completion_date)

FROM fusion.ACA_WF_LIFECYCLE_STATUSES wf_end_status,

fusion.ACA_WF_STATUS_VL END_VL

WHERE wf_end_status.entity_id1 = wf.workflow_id

AND wf_end_status.STATUS_CODE IN (8,37)

AND END_VL.STATUS_CODE = wf_end_status.STATUS_CODE

AND END_VL.STATUS_TYPE = 8

) Workflow_End_Date

FROM fusion.ACA_WF_INSTANCE wf,

fusion.ACA_WF_STATUS_VL status

WHERE wf.status_code = status.status_code

AND status.status_type <> 0

and wf.object_type_id =

(SELECT object_type_id

FROM FUSION.ACA_WF_OBJECT_TYPES_B

WHERE OBJECT_CODE = 'ORA_ENQ_QUALITY_ACTION')