1. Tables and Views for Project Management
  2. PJT_RELEASE_VL

PJT_RELEASE_VL

Details

  • Schema: FUSION

  • Object owner: PJT

  • Object type: VIEW

Columns

Name

RELEASE_ID

RELEASE_NUM

ENTERPRISE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

RELEASE_NAME

RELEASE_DESC

LANGUAGE

Query

SQL_Statement

SELECT

PJT_RELEASE_B.RELEASE_ID RELEASE_ID,

PJT_RELEASE_B.RELEASE_NUM RELEASE_NUM,

PJT_RELEASE_B.ENTERPRISE_ID ENTERPRISE_ID,

PJT_RELEASE_B.CREATED_BY CREATED_BY,

PJT_RELEASE_B.CREATION_DATE CREATION_DATE,

PJT_RELEASE_B.LAST_UPDATED_BY LAST_UPDATED_BY,

PJT_RELEASE_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PJT_RELEASE_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PJT_RELEASE_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PJT_RELEASE_TL.RELEASE_NAME RELEASE_NAME,

PJT_RELEASE_TL.RELEASE_DESC RELEASE_DESC,

PJT_RELEASE_TL.LANGUAGE LANGUAGE

FROM

PJT_RELEASE_B,

PJT_RELEASE_TL

WHERE

PJT_RELEASE_B.RELEASE_ID = PJT_RELEASE_TL.RELEASE_ID AND PJT_RELEASE_TL.LANGUAGE = USERENV('LANG')