ZSP_BR_ATTRIBUTES_VL

Details

• Schema: FUSION

• Object owner: ZSP

• Object type: VIEW

Columns

Name
ATTRIBUTE_ID ATTRIBUTE_NAME ACTIVE_FLAG LIST_FLAG ATTRIBUTE_TYPE_NAME PART_OF_PRIMARY_KEY_FLAG REQUIRED_FLAG ORDERABLE_FLAG ENTITY_ID ATTRIBUTE_POSITION LOV_SOURCE_ID RESOURCE_KEY RESOURCE_BUNDLE_ID CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE LOCALIZED_NAME DESCRIPTION

Query

SQL_Statement

SELECT ZSP_BR_ATTRIBUTES_B.ATTRIBUTE_ID, ZSP_BR_ATTRIBUTES_B.ATTRIBUTE_NAME, ZSP_BR_ATTRIBUTES_B.ACTIVE_FLAG, ZSP_BR_ATTRIBUTES_B.LIST_FLAG, ZSP_BR_ATTRIBUTES_B.ATTRIBUTE_TYPE_NAME, ZSP_BR_ATTRIBUTES_B.PART_OF_PRIMARY_KEY_FLAG, ZSP_BR_ATTRIBUTES_B.REQUIRED_FLAG, ZSP_BR_ATTRIBUTES_B.ORDERABLE_FLAG, ZSP_BR_ATTRIBUTES_B.ENTITY_ID, ZSP_BR_ATTRIBUTES_B.ATTRIBUTE_POSITION, ZSP_BR_ATTRIBUTES_B.LOV_SOURCE_ID, ZSP_BR_ATTRIBUTES_B.RESOURCE_KEY, ZSP_BR_ATTRIBUTES_B.RESOURCE_BUNDLE_ID, ZSP_BR_ATTRIBUTES_B.CREATED_BY, ZSP_BR_ATTRIBUTES_B.CREATION_DATE, ZSP_BR_ATTRIBUTES_B.LAST_UPDATE_DATE, ZSP_BR_ATTRIBUTES_B.LAST_UPDATE_LOGIN, ZSP_BR_ATTRIBUTES_B.LAST_UPDATED_BY, ZSP_BR_ATTRIBUTES_B.OBJECT_VERSION_NUMBER, ZSP_BR_ATTRIBUTES_B.USER_LAST_UPDATE_DATE, ZSP_BR_ATTRIBUTES_TL.LOCALIZED_NAME, ZSP_BR_ATTRIBUTES_TL.DESCRIPTION FROM ZSP_BR_ATTRIBUTES_B, ZSP_BR_ATTRIBUTES_TL WHERE ZSP_BR_ATTRIBUTES_B.ATTRIBUTE_ID = ZSP_BR_ATTRIBUTES_TL.ATTRIBUTE_ID AND ZSP_BR_ATTRIBUTES_TL.LANGUAGE = USERENV('LANG')