1. Tables and Views for SCM
  2. ENQ_WORKFLOW_STATUSES_VL

ENQ_WORKFLOW_STATUSES_VL

Details

  • Schema: FUSION

  • Object owner: ENQ

  • Object type: VIEW

Columns

Name

WORKFLOW_STATUS_ID

OBJECT_VERSION_NUMBER

STATUS_CODE

STATUS_TYPE

OBJECT_NAME

SORT_SEQUENCE_NUM

DISABLE_DATE

SEEDED_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

STATUS_NAME

DESCRIPTION

Query

SQL_Statement

SELECT

ENQ_WORKFLOW_STATUSES_B.WORKFLOW_STATUS_ID WORKFLOW_STATUS_ID,

ENQ_WORKFLOW_STATUSES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ENQ_WORKFLOW_STATUSES_B.STATUS_CODE STATUS_CODE,

ENQ_WORKFLOW_STATUSES_B.STATUS_TYPE STATUS_TYPE,

ENQ_WORKFLOW_STATUSES_B.OBJECT_NAME OBJECT_NAME,

ENQ_WORKFLOW_STATUSES_B.SORT_SEQUENCE_NUM SORT_SEQUENCE_NUM,

ENQ_WORKFLOW_STATUSES_B.DISABLE_DATE DISABLE_DATE,

ENQ_WORKFLOW_STATUSES_B.SEEDED_FLAG SEEDED_FLAG,

ENQ_WORKFLOW_STATUSES_B.CREATED_BY CREATED_BY,

ENQ_WORKFLOW_STATUSES_B.CREATION_DATE CREATION_DATE,

ENQ_WORKFLOW_STATUSES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ENQ_WORKFLOW_STATUSES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ENQ_WORKFLOW_STATUSES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ENQ_WORKFLOW_STATUSES_TL.STATUS_NAME STATUS_NAME,

ENQ_WORKFLOW_STATUSES_TL.DESCRIPTION DESCRIPTION

FROM

ENQ_WORKFLOW_STATUSES_B,

ENQ_WORKFLOW_STATUSES_TL

WHERE

ENQ_WORKFLOW_STATUSES_B.WORKFLOW_STATUS_ID = ENQ_WORKFLOW_STATUSES_TL.WORKFLOW_STATUS_ID AND ENQ_WORKFLOW_STATUSES_TL.LANGUAGE = USERENV('LANG')