PJF_PROJECT_STATUS_TYPES_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
STATUS_TYPE STATUS_TYPE_NAME DESCRIPTION INITIAL_STATUS_FLAG WORKFLOW_FLAG STATUS_CONTROLS_FLAG NEXT_ALLOWABLE_STATUSES_FLAG NEXT_ALLOW_STATUS_TYPE_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT base.STATUS_TYPE, tl.STATUS_TYPE_NAME, tl.DESCRIPTION, base.INITIAL_STATUS_FLAG, base.WORKFLOW_FLAG, base.STATUS_CONTROLS_FLAG, base.NEXT_ALLOWABLE_STATUSES_FLAG, base.NEXT_ALLOW_STATUS_TYPE_FLAG, base.CREATED_BY, base.CREATION_DATE, base.LAST_UPDATED_BY, base.LAST_UPDATE_DATE, base.LAST_UPDATE_LOGIN, base.OBJECT_VERSION_NUMBER FROM pjf_project_status_types_b base, pjf_project_status_types_tl tl WHERE base.STATUS_TYPE = tl.STATUS_TYPE AND tl.LANGUAGE = USERENV('LANG')