EGP_TRANS_ATTRS_VL

Details

• Schema: FUSION

• Object owner: EGP

• Object type: VIEW

Columns

Name
TRANS_ATTR_ID INTERNAL_NAME BASE_VALUE_SET_ID DATA_TYPE_CODE REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER UOM_CODE DISPLAY_NAME DESCRIPTION ITEM_CLASS_ID

Query

SQL_Statement

SELECT B.TRANS_ATTR_ID ,B.INTERNAL_NAME ,B.BASE_VALUE_SET_ID ,B.DATA_TYPE_CODE ,B.REQUEST_ID ,B.JOB_DEFINITION_NAME ,B.JOB_DEFINITION_PACKAGE ,B.CREATED_BY ,B.CREATION_DATE ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_DATE ,B.LAST_UPDATE_LOGIN ,B.OBJECT_VERSION_NUMBER ,B.UOM_CODE ,T.DISPLAY_NAME ,T.DESCRIPTION ,B.ITEM_CLASS_ID FROM EGP_TRANS_ATTRS_TL T , EGP_TRANS_ATTRS_B B WHERE B. TRANS_ATTR_ID = T. TRANS_ATTR_ID AND T.LANGUAGE = userenv('LANG')