1. Tables and Views for Project Management
  2. PJT_GATE_APPROVERS_VL

PJT_GATE_APPROVERS_VL

Details

  • Schema: FUSION

  • Object owner: PJT

  • Object type: VIEW

Columns

Name

APPROVAL_ID

GATE_ELEMENT_ID

PROJECT_ID

LAST_REVIEWED_BY_ID

APPROVAL_RESOURCE_ID

APPROVAL_STATUS

APPROVAL_DECISION_DATE

APPROVAL_INIT_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

DECISION_COMMENTS

Query

SQL_Statement

SELECT

B.APPROVAL_ID APPROVAL_ID,

B.GATE_ELEMENT_ID GATE_ELEMENT_ID,

B.PROJECT_ID PROJECT_ID,

B.LAST_REVIEWED_BY_ID LAST_REVIEWED_BY_ID,

B.APPROVAL_RESOURCE_ID APPROVAL_RESOURCE_ID,

B.APPROVAL_STATUS APPROVAL_STATUS,

B.APPROVAL_DECISION_DATE APPROVAL_DECISION_DATE,

B.APPROVAL_INIT_DATE APPROVAL_INIT_DATE,

B.CREATED_BY CREATED_BY,

B.CREATION_DATE CREATION_DATE,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

TL.DECISION_COMMENTS DECISION_COMMENTS

FROM

PJT_GATE_APPROVERS_B B,

PJT_GATE_APPROVERS_TL TL

WHERE

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