ACA_WF_TEMPLATE_VL

Details

• Schema: FUSION

• Object owner: ACA

• Object type: VIEW

Columns

Name
WORKFLOW_TEMPLATE_ID OBJECT_VERSION_NUMBER INTERNAL_NAME NAME DESCRIPTION START_DATE END_DATE SEED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT ACA_WF_TEMPLATE_B.WORKFLOW_TEMPLATE_ID WORKFLOW_TEMPLATE_ID, ACA_WF_TEMPLATE_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACA_WF_TEMPLATE_B.INTERNAL_NAME INTERNAL_NAME, ACA_WF_TEMPLATE_TL.NAME NAME, ACA_WF_TEMPLATE_TL.DESCRIPTION DESCRIPTION, ACA_WF_TEMPLATE_B.START_DATE START_DATE, ACA_WF_TEMPLATE_B.END_DATE END_DATE, ACA_WF_TEMPLATE_B.SEED_FLAG SEED_FLAG, ACA_WF_TEMPLATE_B.CREATED_BY CREATED_BY, ACA_WF_TEMPLATE_B.CREATION_DATE CREATION_DATE, ACA_WF_TEMPLATE_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACA_WF_TEMPLATE_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACA_WF_TEMPLATE_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM ACA_WF_TEMPLATE_B, ACA_WF_TEMPLATE_TL WHERE ACA_WF_TEMPLATE_B.WORKFLOW_TEMPLATE_ID = ACA_WF_TEMPLATE_TL.WORKFLOW_TEMPLATE_ID AND ACA_WF_TEMPLATE_TL.LANGUAGE = USERENV('LANG')