EGO_SUBJECT_CRITERIA

Details

Schema: FUSION
Object owner: EGO
Object type: VIEW

Columns

Name
SUBJECT_INTERNAL_NAME ATTRIBUTE_CODE OBJECT_VERSION_NUMBER ATTRIBUTE_NAME LOV_SQL LOV_VIEW_OBJECT CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE APPLICATION_ID

Name

SUBJECT_INTERNAL_NAME

ATTRIBUTE_CODE

OBJECT_VERSION_NUMBER

ATTRIBUTE_NAME

LOV_SQL

LOV_VIEW_OBJECT

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

APPLICATION_ID

Query

SQL_Statement
SELECT EGO_SUBJECT_CRITERIA_B.SUBJECT_INTERNAL_NAME SUBJECT_INTERNAL_NAME, EGO_SUBJECT_CRITERIA_B.ATTRIBUTE_CODE ATTRIBUTE_CODE, EGO_SUBJECT_CRITERIA_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_SUBJECT_CRITERIA_TL.ATTRIBUTE_NAME ATTRIBUTE_NAME, EGO_SUBJECT_CRITERIA_B.LOV_SQL LOV_SQL, EGO_SUBJECT_CRITERIA_B.LOV_VIEW_OBJECT LOV_VIEW_OBJECT, EGO_SUBJECT_CRITERIA_B.CREATED_BY CREATED_BY, EGO_SUBJECT_CRITERIA_B.CREATION_DATE CREATION_DATE, EGO_SUBJECT_CRITERIA_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_SUBJECT_CRITERIA_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EGO_SUBJECT_CRITERIA_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_SUBJECT_CRITERIA_B.APPLICATION_ID APPLICATION_ID FROM EGO_SUBJECT_CRITERIA_B, EGO_SUBJECT_CRITERIA_TL WHERE EGO_SUBJECT_CRITERIA_B.SUBJECT_INTERNAL_NAME = EGO_SUBJECT_CRITERIA_TL.SUBJECT_INTERNAL_NAME AND EGO_SUBJECT_CRITERIA_B.ATTRIBUTE_CODE = EGO_SUBJECT_CRITERIA_TL.ATTRIBUTE_CODE AND EGO_SUBJECT_CRITERIA_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

EGO_SUBJECT_CRITERIA_B.SUBJECT_INTERNAL_NAME SUBJECT_INTERNAL_NAME,

EGO_SUBJECT_CRITERIA_B.ATTRIBUTE_CODE ATTRIBUTE_CODE,

EGO_SUBJECT_CRITERIA_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

EGO_SUBJECT_CRITERIA_TL.ATTRIBUTE_NAME ATTRIBUTE_NAME,

EGO_SUBJECT_CRITERIA_B.LOV_SQL LOV_SQL,

EGO_SUBJECT_CRITERIA_B.LOV_VIEW_OBJECT LOV_VIEW_OBJECT,

EGO_SUBJECT_CRITERIA_B.CREATED_BY CREATED_BY,

EGO_SUBJECT_CRITERIA_B.CREATION_DATE CREATION_DATE,

EGO_SUBJECT_CRITERIA_B.LAST_UPDATED_BY LAST_UPDATED_BY,

EGO_SUBJECT_CRITERIA_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

EGO_SUBJECT_CRITERIA_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

EGO_SUBJECT_CRITERIA_B.APPLICATION_ID APPLICATION_ID

FROM

EGO_SUBJECT_CRITERIA_B,

EGO_SUBJECT_CRITERIA_TL

WHERE

EGO_SUBJECT_CRITERIA_B.SUBJECT_INTERNAL_NAME = EGO_SUBJECT_CRITERIA_TL.SUBJECT_INTERNAL_NAME AND EGO_SUBJECT_CRITERIA_B.ATTRIBUTE_CODE = EGO_SUBJECT_CRITERIA_TL.ATTRIBUTE_CODE AND EGO_SUBJECT_CRITERIA_TL.LANGUAGE = USERENV('LANG')