1. Tables and Views for Project Management
  2. PJT_GATE_STATUSES_VL

PJT_GATE_STATUSES_VL

Details

  • Schema: FUSION

  • Object owner: PJT

  • Object type: VIEW

Columns

Name

GATE_STATUS_CODE

GATE_SYSTEM_STATUS_CODE

GATE_STATUS_NAME

GATE_STATUS_DESCRIPTION

IS_SEEDED_STATUS

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

B.GATE_STATUS_CODE,

B.GATE_SYSTEM_STATUS_CODE,

TL.GATE_STATUS_NAME,

TL.GATE_STATUS_DESCRIPTION,

B.IS_SEEDED_STATUS,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER

FROM

PJT_GATE_STATUSES_B B,

PJT_GATE_STATUSES_TL TL

WHERE

B.GATE_STATUS_CODE = TL.GATE_STATUS_CODE AND TL.LANGUAGE = USERENV('LANG')