1. Tables and Views for Project Management
  2. PJF_PROJ_COPY_OVERRIDES_VL

PJF_PROJ_COPY_OVERRIDES_VL

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

PROJECT_ID

OVERRIDE_ID

OBJECT_VERSION_NUMBER

FIELD_NAME

DISPLAY_NAME

LIMITING_VALUE

MANDATORY_FLAG

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement

select

b.PROJECT_ID,

b.OVERRIDE_ID,

b.OBJECT_VERSION_NUMBER,

b.FIELD_NAME,

tl.display_name,

b.LIMITING_VALUE,

b.MANDATORY_FLAG,

b.LAST_UPDATE_DATE,

b.LAST_UPDATED_BY,

b.CREATION_DATE,

b.CREATED_BY,

b.LAST_UPDATE_LOGIN

from

pjf_proj_copy_overrides_b b,

pjf_proj_copy_overrides_tl tl

where b.project_id = tl.project_id and

b.override_id = tl.override_id and

tl.LANGUAGE = userenv('LANG')