HRC_EVT_OBJ_CONDITIONS_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name
OBJ_CONDITION_ID OBJ_CONDITION_CODE SOURCE_OBJECT_ID PRODUCT_CODE PRODUCT_LABEL CONDITION_DEF ACTIVE_FLAG NAME DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MODULE_ID SEED_DATA_SOURCE SGUID CONDITION_DEF_TYPE

Query

SQL_Statement

SELECT b.OBJ_CONDITION_ID OBJ_CONDITION_ID, OBJ_CONDITION_CODE OBJ_CONDITION_CODE, SOURCE_OBJECT_ID SOURCE_OBJECT_ID, PRODUCT_CODE PRODUCT_CODE, PRODUCT_LABEL PRODUCT_LABEL, CONDITION_DEF CONDITION_DEF, ACTIVE_FLAG ACTIVE_FLAG, NAME NAME, DESCRIPTION DESCRIPTION, b.CREATED_BY CREATED_BY, b.CREATION_DATE CREATION_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MODULE_ID MODULE_ID, b.SEED_DATA_SOURCE SEED_DATA_SOURCE, b.SGUID SGUID, b.CONDITION_DEF_TYPE CONDITION_DEF_TYPE FROM HRC_EVT_OBJ_CONDITIONS_B b, HRC_EVT_OBJ_CONDITIONS_TL tl WHERE b.OBJ_CONDITION_ID = tl.OBJ_CONDITION_ID AND tl.LANGUAGE = USERENV('LANG')