HWM_TM_ATRB_FLD_MSTR_REF_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
TM_ATRB_FLD_MSTR_REF_ID TM_ATRB_FLD_ID DET_INS_DISPLAY_NAME MASTER_INSTANCE_IDENTIFIER DET_INS_ATTRIBUTE_TYPE DET_INS_VALUE_LOCATION LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID START_DATE END_DATE TM_ATRB_FLD_ESS_PROCESS_ID LANGUAGE SOURCE_LANG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN MODULE_ID TM_ATRB_FLD_MSTR_REF_CODE SGUID

Query

SQL_Statement

SELECT BASE.TM_ATRB_FLD_MSTR_REF_ID TM_ATRB_FLD_MSTR_REF_ID, BASE.TM_ATRB_FLD_ID TM_ATRB_FLD_ID, TL.DET_INS_DISPLAY_NAME DET_INS_DISPLAY_NAME, BASE.MASTER_INSTANCE_IDENTIFIER MASTER_INSTANCE_IDENTIFIER, BASE.DET_INS_ATTRIBUTE_TYPE DET_INS_ATTRIBUTE_TYPE, BASE.DET_INS_VALUE_LOCATION DET_INS_VALUE_LOCATION, BASE.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, BASE.LEGISLATION_CODE, BASE.ENTERPRISE_ID ENTERPRISE_ID, BASE.START_DATE START_DATE, BASE.END_DATE END_DATE, BASE.TM_ATRB_FLD_ESS_PROCESS_ID TM_ATRB_FLD_ESS_PROCESS_ID, TL.LANGUAGE LANGUAGE, TL.SOURCE_LANG SOURCE_LANG, BASE.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BASE.CREATED_BY CREATED_BY, BASE.CREATION_DATE CREATION_DATE, BASE.LAST_UPDATED_BY LAST_UPDATED_BY, BASE.LAST_UPDATE_DATE LAST_UPDATE_DATE, BASE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BASE.MODULE_ID, BASE.TM_ATRB_FLD_MSTR_REF_CODE, BASE.SGUID SGUID FROM HWM_TM_ATRB_FLD_MSTR_REF_B BASE, HWM_TM_ATRB_FLD_MSTR_REF_TL TL WHERE BASE.TM_ATRB_FLD_MSTR_REF_ID = TL.TM_ATRB_FLD_MSTR_REF_ID AND TL.LANGUAGE = USERENV('LANG')