EXM_MAP_TYPES_VL
Details
-
Schema: FUSION
-
Object owner: EXM
-
Object type: VIEW
Columns
Name |
---|
MAP_TYPE_ID MAP_TYPE_CODE FROM_APPLICATION_ID FROM_LOOKUP_TYPE TO_APPLICATION_ID TO_LOOKUP_TYPE DEFAULT_LOOKUP_CODE DESCRIPTION CREATION_DATE CREATED_BY OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN |
Query
SQL_Statement |
---|
SELECT B.MAP_TYPE_ID, B.MAP_TYPE_CODE, B.FROM_APPLICATION_ID, B.FROM_LOOKUP_TYPE, B.TO_APPLICATION_ID, B.TO_LOOKUP_TYPE, B.DEFAULT_LOOKUP_CODE, T.DESCRIPTION, T.CREATION_DATE, T.CREATED_BY, T.OBJECT_VERSION_NUMBER, T.LAST_UPDATE_DATE, T.LAST_UPDATED_BY, T.LAST_UPDATE_LOGIN FROM EXM_MAP_TYPES_B B, EXM_MAP_TYPES_TL T WHERE B.MAP_TYPE_ID = T.MAP_TYPE_ID AND T.LANGUAGE = USERENV('LANG') |