ACA_WF_ACTIONS_VL

Details

• Schema: FUSION

• Object owner: ACA

• Object type: VIEW

Columns

Name
ACTION_ID ACTION_TYPE DESCRIPTION WORKFLOW_ID FROM_STATUS_CODE TO_STATUS_CODE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN WF_LIFECYCLE_STATUS_ID

Query

SQL_Statement

SELECT ACA_WF_ACTIONS_B.ACTION_ID ACTION_ID, ACA_WF_ACTIONS_B.ACTION_TYPE ACTION_TYPE, ACA_WF_ACTIONS_TL.DESCRIPTION DESCRIPTION, ACA_WF_ACTIONS_B.WORKFLOW_ID WORKFLOW_ID, ACA_WF_ACTIONS_B.FROM_STATUS_CODE FROM_STATUS_CODE, ACA_WF_ACTIONS_B.TO_STATUS_CODE TO_STATUS_CODE, ACA_WF_ACTIONS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACA_WF_ACTIONS_B.CREATED_BY CREATED_BY, ACA_WF_ACTIONS_B.CREATION_DATE CREATION_DATE, ACA_WF_ACTIONS_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACA_WF_ACTIONS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACA_WF_ACTIONS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACA_WF_ACTIONS_B.WF_LIFECYCLE_STATUS_ID WF_LIFECYCLE_STATUS_ID FROM ACA_WF_ACTIONS_B, ACA_WF_ACTIONS_TL WHERE ACA_WF_ACTIONS_B.ACTION_ID = ACA_WF_ACTIONS_TL.ACTION_ID AND ACA_WF_ACTIONS_TL.LANGUAGE = USERENV('LANG')