MOT_TERR_DIMENSIONS_VL

Details

• Schema: FUSION

• Object owner: MOT

• Object type: VIEW

Columns

Name
TERR_DIMENSION_ID DIMENSION_CODE ACTIVE_FLAG DISPLAY_FLAG DEFAULT_FLAG PARTITION_ID ACTIVATION_REQUEST SYNCHED_FLAG REQUEST_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CONFLICT_ID OBJECT_VERSION_NUMBER NAME DESCRIPTION REFRESH_REQUEST LAST_REFRESH_DATE

Query

SQL_Statement

SELECT MOT_TERR_DIMENSIONS_B.TERR_DIMENSION_ID TERR_DIMENSION_ID, MOT_TERR_DIMENSIONS_B.DIMENSION_CODE DIMENSION_CODE, MOT_TERR_DIMENSIONS_B.ACTIVE_FLAG ACTIVE_FLAG, MOT_TERR_DIMENSIONS_B.DISPLAY_FLAG DISPLAY_FLAG, MOT_TERR_DIMENSIONS_B.DEFAULT_FLAG DEFAULT_FLAG, MOT_TERR_DIMENSIONS_B.PARTITION_ID PARTITION_ID, MOT_TERR_DIMENSIONS_B.ACTIVATION_REQUEST ACTIVATION_REQUEST, MOT_TERR_DIMENSIONS_B.SYNCHED_FLAG SYNCHED_FLAG, MOT_TERR_DIMENSIONS_B.REQUEST_ID REQUEST_ID, MOT_TERR_DIMENSIONS_B.CREATION_DATE CREATION_DATE, MOT_TERR_DIMENSIONS_B.CREATED_BY CREATED_BY, MOT_TERR_DIMENSIONS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MOT_TERR_DIMENSIONS_B.LAST_UPDATED_BY LAST_UPDATED_BY, MOT_TERR_DIMENSIONS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MOT_TERR_DIMENSIONS_B.CONFLICT_ID CONFLICT_ID, MOT_TERR_DIMENSIONS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MOT_TERR_DIMENSIONS_TL.NAME NAME, MOT_TERR_DIMENSIONS_TL.DESCRIPTION DESCRIPTION, MOT_TERR_DIMENSIONS_B.REFRESH_REQUEST REFRESH_REQUEST, MOT_TERR_DIMENSIONS_B.LAST_REFRESH_DATE LAST_REFRESH_DATE FROM MOT_TERR_DIMENSIONS_B, MOT_TERR_DIMENSIONS_TL WHERE MOT_TERR_DIMENSIONS_B.TERR_DIMENSION_ID = MOT_TERR_DIMENSIONS_TL.TERR_DIMENSION_ID AND MOT_TERR_DIMENSIONS_TL.LANGUAGE = USERENV('LANG')