ACA_WF_STATUS_VL

Details

• Schema: FUSION

• Object owner: ACA

• Object type: VIEW

Columns

Name
STATUS_CODE OBJECT_VERSION_NUMBER STATUS_TYPE OBJECT_TYPE_ID INTERNAL_NAME STATUS_NAME DESCRIPTION SORT_SEQUENCE_NUM DISABLE_DATE APPLICATION_ID SEED_FLAG DELETE_FLAG IS_SYSTEM CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT ACA_WF_STATUS_B.STATUS_CODE STATUS_CODE, ACA_WF_STATUS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACA_WF_STATUS_B.STATUS_TYPE STATUS_TYPE, ACA_WF_STATUS_B.OBJECT_TYPE_ID OBJECT_TYPE_ID, ACA_WF_STATUS_B.INTERNAL_NAME INTERNAL_NAME, ACA_WF_STATUS_TL.STATUS_NAME STATUS_NAME, ACA_WF_STATUS_TL.DESCRIPTION DESCRIPTION, ACA_WF_STATUS_B.SORT_SEQUENCE_NUM SORT_SEQUENCE_NUM, ACA_WF_STATUS_B.DISABLE_DATE DISABLE_DATE, ACA_WF_STATUS_B.APPLICATION_ID APPLICATION_ID, ACA_WF_STATUS_B.SEED_FLAG SEED_FLAG, ACA_WF_STATUS_B.DELETE_FLAG DELETE_FLAG, ACA_WF_STATUS_B.IS_SYSTEM IS_SYSTEM, ACA_WF_STATUS_B.CREATED_BY CREATED_BY, ACA_WF_STATUS_B.CREATION_DATE CREATION_DATE, ACA_WF_STATUS_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACA_WF_STATUS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACA_WF_STATUS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM ACA_WF_STATUS_B, ACA_WF_STATUS_TL WHERE ACA_WF_STATUS_B.STATUS_CODE = ACA_WF_STATUS_TL.STATUS_CODE AND ACA_WF_STATUS_TL.LANGUAGE = USERENV('LANG')