ZSP_BR_ENTITIES_VL

Details

• Schema: FUSION

• Object owner: ZSP

• Object type: VIEW

Columns

Name
ENTITY_ID ENTITY_NAME ACTIVE_FLAG APPLICATION_MODULE_NAME VIEW_OBJECT_NAME 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_ENTITIES_B.ENTITY_ID, ZSP_BR_ENTITIES_B.ENTITY_NAME, ZSP_BR_ENTITIES_B.ACTIVE_FLAG, ZSP_BR_ENTITIES_B.APPLICATION_MODULE_NAME, ZSP_BR_ENTITIES_B.VIEW_OBJECT_NAME, ZSP_BR_ENTITIES_B.RESOURCE_KEY, ZSP_BR_ENTITIES_B.RESOURCE_BUNDLE_ID, ZSP_BR_ENTITIES_B.CREATED_BY, ZSP_BR_ENTITIES_B.CREATION_DATE, ZSP_BR_ENTITIES_B.LAST_UPDATE_DATE, ZSP_BR_ENTITIES_B.LAST_UPDATE_LOGIN, ZSP_BR_ENTITIES_B.LAST_UPDATED_BY, ZSP_BR_ENTITIES_B.OBJECT_VERSION_NUMBER, ZSP_BR_ENTITIES_B.USER_LAST_UPDATE_DATE, ZSP_BR_ENTITIES_TL.LOCALIZED_NAME, ZSP_BR_ENTITIES_TL.DESCRIPTION FROM ZSP_BR_ENTITIES_B, ZSP_BR_ENTITIES_TL WHERE ZSP_BR_ENTITIES_B.ENTITY_ID = ZSP_BR_ENTITIES_TL.ENTITY_ID AND ZSP_BR_ENTITIES_TL.LANGUAGE = USERENV('LANG')