1. Tables and Views for Sales and Fusion Service
  2. MOT_TERR_DIM_MEMBERS_VL

MOT_TERR_DIM_MEMBERS_VL

Details

  • Schema: FUSION

  • Object owner: MOT

  • Object type: VIEW

Columns

Name

TERR_DIM_MEMBER_ID

TERR_DIMENSION_ID

TERR_DIMENSION_CODE

PARENT_TERR_DIM_MEMBER_ID

LEVEL_NUMBER

SORT_ORDER

ATTRIBUTE_PK1

ATTRIBUTE_PK2

SEQUENCE_LOW

SEQUENCE_HIGH

PARTITION_ID

INTEGRATION_ID

ACTIVE_FLAG

DISPLAY_FLAG

TYPE_CODE

LEAF_FLAG

EXPLICIT_FLAG

DIM_SUBTYPE_CODE

NUM_INTEGRATION_ID

REQUEST_ID

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CONFLICT_ID

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

DIM_MEMBER_NAME

Query

SQL_Statement

SELECT

MOT_TERR_DIM_MEMBERS_B.TERR_DIM_MEMBER_ID TERR_DIM_MEMBER_ID,

MOT_TERR_DIM_MEMBERS_B.TERR_DIMENSION_ID TERR_DIMENSION_ID,

MOT_TERR_DIM_MEMBERS_B.TERR_DIMENSION_CODE TERR_DIMENSION_CODE,

MOT_TERR_DIM_MEMBERS_B.PARENT_TERR_DIM_MEMBER_ID PARENT_TERR_DIM_MEMBER_ID,

MOT_TERR_DIM_MEMBERS_B.LEVEL_NUMBER LEVEL_NUMBER,

MOT_TERR_DIM_MEMBERS_B.SORT_ORDER SORT_ORDER,

MOT_TERR_DIM_MEMBERS_B.ATTRIBUTE_PK1 ATTRIBUTE_PK1,

MOT_TERR_DIM_MEMBERS_B.ATTRIBUTE_PK2 ATTRIBUTE_PK2,

MOT_TERR_DIM_MEMBERS_B.SEQUENCE_LOW SEQUENCE_LOW,

MOT_TERR_DIM_MEMBERS_B.SEQUENCE_HIGH SEQUENCE_HIGH,

MOT_TERR_DIM_MEMBERS_B.PARTITION_ID PARTITION_ID,

MOT_TERR_DIM_MEMBERS_B.INTEGRATION_ID INTEGRATION_ID,

MOT_TERR_DIM_MEMBERS_B.ACTIVE_FLAG ACTIVE_FLAG,

MOT_TERR_DIM_MEMBERS_B.DISPLAY_FLAG DISPLAY_FLAG,

MOT_TERR_DIM_MEMBERS_B.TYPE_CODE TYPE_CODE,

MOT_TERR_DIM_MEMBERS_B.LEAF_FLAG LEAF_FLAG,

MOT_TERR_DIM_MEMBERS_B.EXPLICIT_FLAG EXPLICIT_FLAG,

MOT_TERR_DIM_MEMBERS_B.DIM_SUBTYPE_CODE DIM_SUBTYPE_CODE,

MOT_TERR_DIM_MEMBERS_B.NUM_INTEGRATION_ID NUM_INTEGRATION_ID,

MOT_TERR_DIM_MEMBERS_B.REQUEST_ID REQUEST_ID,

MOT_TERR_DIM_MEMBERS_B.CREATION_DATE CREATION_DATE,

MOT_TERR_DIM_MEMBERS_B.CREATED_BY CREATED_BY,

MOT_TERR_DIM_MEMBERS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

MOT_TERR_DIM_MEMBERS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

MOT_TERR_DIM_MEMBERS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

MOT_TERR_DIM_MEMBERS_B.CONFLICT_ID CONFLICT_ID,

MOT_TERR_DIM_MEMBERS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

MOT_TERR_DIM_MEMBERS_B.DIM_MEMBER_NAME NAME,

MOT_TERR_DIM_MEMBERS_B.DIM_MEMBER_NAME DESCRIPTION,

MOT_TERR_DIM_MEMBERS_B.DIM_MEMBER_NAME DIM_MEMBER_NAME

FROM

MOT_TERR_DIM_MEMBERS_B