ZBS_LOOKUP_VALUES

Details

Schema: FUSION
Object owner: ZBS
Object type: VIEW

Columns

Name
LOOKUP_VALUES_ID APPLIES_TO LOOKUP_CATEGORY LOOKUP_CODE START_DATE_ACTIVE END_DATE_ACTIVE CONFLICT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE MEANING DESCRIPTION LOOKUP_TYPE ENABLED_FLAG SET_ID DISPLAY_SEQUENCE

Name

LOOKUP_VALUES_ID

APPLIES_TO

LOOKUP_CATEGORY

LOOKUP_CODE

START_DATE_ACTIVE

END_DATE_ACTIVE

CONFLICT_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

USER_LAST_UPDATE_DATE

MEANING

DESCRIPTION

LOOKUP_TYPE

ENABLED_FLAG

SET_ID

DISPLAY_SEQUENCE

Query

SQL_Statement
SELECT B.LOOKUP_VALUES_ID, B.APPLIES_TO, B.LOOKUP_CATEGORY, B.LOOKUP_CODE, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.CONFLICT_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.USER_LAST_UPDATE_DATE, T.MEANING, T.DESCRIPTION, B.LOOKUP_TYPE, B.ENABLED_FLAG, B.SET_ID, B.DISPLAY_SEQUENCE FROM ZBS_LOOKUP_VALUES_B B, ZBS_LOOKUP_VALUES_TL T WHERE B.LOOKUP_VALUES_ID = T.LOOKUP_VALUES_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.LOOKUP_VALUES_ID,

B.APPLIES_TO,

B.LOOKUP_CATEGORY,

B.LOOKUP_CODE,

B.START_DATE_ACTIVE,

B.END_DATE_ACTIVE,

B.CONFLICT_ID,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

B.USER_LAST_UPDATE_DATE,

T.MEANING,

T.DESCRIPTION,

B.LOOKUP_TYPE,

B.ENABLED_FLAG,

B.SET_ID,

B.DISPLAY_SEQUENCE

FROM

ZBS_LOOKUP_VALUES_B B,

ZBS_LOOKUP_VALUES_TL T

WHERE

B.LOOKUP_VALUES_ID = T.LOOKUP_VALUES_ID AND T.LANGUAGE = USERENV('LANG')