ZCA_ES_ROLE_SS_DEFAULTS

Details

Schema: FUSION
Object owner: ZCA
Object type: VIEW

Columns

Name
ROLE_SS_DEFAULT_UUID ROLE_NAME SAVED_SEARCH_UUID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE LOCALIZED_NAME LOCALIZED_DESCRIPTION

Name

ROLE_SS_DEFAULT_UUID

ROLE_NAME

SAVED_SEARCH_UUID

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

USER_LAST_UPDATE_DATE

LOCALIZED_NAME

LOCALIZED_DESCRIPTION

Query

SQL_Statement
SELECT ZCA_ES_ROLE_SS_DEFAULTS_B.ROLE_SS_DEFAULT_UUID ROLE_SS_DEFAULT_UUID, ZCA_ES_ROLE_SS_DEFAULTS_B.ROLE_NAME ROLE_NAME, ZCA_ES_ROLE_SS_DEFAULTS_B.SAVED_SEARCH_UUID SAVED_SEARCH_UUID, ZCA_ES_ROLE_SS_DEFAULTS_B.CREATION_DATE CREATION_DATE, ZCA_ES_ROLE_SS_DEFAULTS_B.CREATED_BY CREATED_BY, ZCA_ES_ROLE_SS_DEFAULTS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ZCA_ES_ROLE_SS_DEFAULTS_B.LAST_UPDATED_BY LAST_UPDATED_BY, ZCA_ES_ROLE_SS_DEFAULTS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ZCA_ES_ROLE_SS_DEFAULTS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ZCA_ES_ROLE_SS_DEFAULTS_B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE, ZCA_ES_ROLE_SS_DEFAULTS_TL.LOCALIZED_NAME LOCALIZED_NAME, ZCA_ES_ROLE_SS_DEFAULTS_TL.LOCALIZED_DESCRIPTION LOCALIZED_DESCRIPTION FROM ZCA_ES_ROLE_SS_DEFAULTS_B, ZCA_ES_ROLE_SS_DEFAULTS_TL WHERE ZCA_ES_ROLE_SS_DEFAULTS_B.ROLE_SS_DEFAULT_UUID = ZCA_ES_ROLE_SS_DEFAULTS_TL.ROLE_SS_DEFAULT_UUID AND ZCA_ES_ROLE_SS_DEFAULTS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

ZCA_ES_ROLE_SS_DEFAULTS_B.ROLE_SS_DEFAULT_UUID ROLE_SS_DEFAULT_UUID,

ZCA_ES_ROLE_SS_DEFAULTS_B.ROLE_NAME ROLE_NAME,

ZCA_ES_ROLE_SS_DEFAULTS_B.SAVED_SEARCH_UUID SAVED_SEARCH_UUID,

ZCA_ES_ROLE_SS_DEFAULTS_B.CREATION_DATE CREATION_DATE,

ZCA_ES_ROLE_SS_DEFAULTS_B.CREATED_BY CREATED_BY,

ZCA_ES_ROLE_SS_DEFAULTS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ZCA_ES_ROLE_SS_DEFAULTS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ZCA_ES_ROLE_SS_DEFAULTS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ZCA_ES_ROLE_SS_DEFAULTS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ZCA_ES_ROLE_SS_DEFAULTS_B.USER_LAST_UPDATE_DATE USER_LAST_UPDATE_DATE,

ZCA_ES_ROLE_SS_DEFAULTS_TL.LOCALIZED_NAME LOCALIZED_NAME,

ZCA_ES_ROLE_SS_DEFAULTS_TL.LOCALIZED_DESCRIPTION LOCALIZED_DESCRIPTION

FROM

ZCA_ES_ROLE_SS_DEFAULTS_B,

ZCA_ES_ROLE_SS_DEFAULTS_TL

WHERE

ZCA_ES_ROLE_SS_DEFAULTS_B.ROLE_SS_DEFAULT_UUID = ZCA_ES_ROLE_SS_DEFAULTS_TL.ROLE_SS_DEFAULT_UUID AND ZCA_ES_ROLE_SS_DEFAULTS_TL.LANGUAGE = USERENV('LANG')