ZMM_OBJECTS_VL

Details

• Schema: FUSION

• Object owner: ZMM

• Object type: VIEW

Columns

Name
OBJECT_CODE MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER OBJECT_NAME OBJECT_DESC DELETED_FLAG

Query

SQL_Statement

SELECT ZMM_OBJECTS_B.OBJECT_CODE, ZMM_OBJECTS_B.MODULE_ID, ZMM_OBJECTS_B.CREATED_BY, ZMM_OBJECTS_B.CREATION_DATE, ZMM_OBJECTS_B.LAST_UPDATED_BY, ZMM_OBJECTS_B.LAST_UPDATE_DATE, ZMM_OBJECTS_B.LAST_UPDATE_LOGIN, ZMM_OBJECTS_B.OBJECT_VERSION_NUMBER, ZMM_OBJECTS_TL.OBJECT_NAME, ZMM_OBJECTS_TL.OBJECT_DESC, ZMM_OBJECTS_B.DELETED_FLAG FROM ZMM_OBJECTS_B, ZMM_OBJECTS_TL WHERE ZMM_OBJECTS_B.OBJECT_CODE = ZMM_OBJECTS_TL.OBJECT_CODE AND ZMM_OBJECTS_TL.LANGUAGE = USERENV('LANG')