1. Tables and Views for SCM
  2. EGO_SUBJECTS_VL

EGO_SUBJECTS_VL

Details

  • Schema: FUSION

  • Object owner: EGO

  • Object type: VIEW

Columns

Name

SUBJECT_INTERNAL_NAME

SUBJECT_TYPE

OBJECT_VERSION_NUMBER

SUBJECT_NAME

IMPORT_API

APPLICATION_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

Query

SQL_Statement

SELECT

EGO_SUBJECTS_B.SUBJECT_INTERNAL_NAME SUBJECT_INTERNAL_NAME,

EGO_SUBJECTS_B.SUBJECT_TYPE SUBJECT_TYPE,

EGO_SUBJECTS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

EGO_SUBJECTS_TL.SUBJECT_NAME SUBJECT_NAME,

EGO_SUBJECTS_B.IMPORT_API IMPORT_API,

EGO_SUBJECTS_B.APPLICATION_ID APPLICATION_ID,

EGO_SUBJECTS_B.CREATED_BY CREATED_BY,

EGO_SUBJECTS_B.CREATION_DATE CREATION_DATE,

EGO_SUBJECTS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

EGO_SUBJECTS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

EGO_SUBJECTS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE

FROM

EGO_SUBJECTS_B,

EGO_SUBJECTS_TL

WHERE

EGO_SUBJECTS_B.SUBJECT_INTERNAL_NAME = EGO_SUBJECTS_TL.SUBJECT_INTERNAL_NAME AND EGO_SUBJECTS_TL.LANGUAGE = USERENV('LANG')