MOT_TERR_SYNCED_DIM_MEMBERS_VL

Details

• Schema: FUSION

• Object owner: MOT

• Object type: VIEW

Columns

Name
TERR_DIM_MEMBER_ID INTEGRATION_ID NAME SEQUENCE_LOW SEQUENCE_HIGH LEVEL_NUMBER ACTIVE_FLAG DISPLAY_FLAG PARTITION_ID TYPE_CODE DIMENSION_CODE TERR_DIM_PARTITION_ID PARENT_TERR_DIM_MEMBER_ID OBJECT_VERSION_NUMBER DIM_MEMBER_NAME

Query

SQL_Statement

SELECT MOT_TERR_DIM_MEMBERS_B.TERR_DIM_MEMBER_ID, MOT_TERR_DIM_MEMBERS_B.INTEGRATION_ID INTEGRATION_ID, MOT_TERR_DIM_MEMBERS_B.DIM_MEMBER_NAME NAME, MOT_TERR_DIM_MEMBERS_B.SEQUENCE_LOW, MOT_TERR_DIM_MEMBERS_B.SEQUENCE_HIGH, MOT_TERR_DIM_MEMBERS_B.LEVEL_NUMBER, MOT_TERR_DIM_MEMBERS_B.ACTIVE_FLAG, MOT_TERR_DIM_MEMBERS_B.DISPLAY_FLAG, MOT_TERR_DIM_MEMBERS_B.PARTITION_ID, MOT_TERR_DIM_PARTITIONS.TYPE_CODE, MOT_TERR_DIM_MEMBERS_B.TERR_DIMENSION_CODE DIMENSION_CODE , MOT_TERR_DIM_PARTITIONS.TERR_DIM_PARTITION_ID, MOT_TERR_DIM_MEMBERS_B.PARENT_TERR_DIM_MEMBER_ID, MOT_TERR_DIM_MEMBERS_B.OBJECT_VERSION_NUMBER, MOT_TERR_DIM_MEMBERS_B.DIM_MEMBER_NAME FROM MOT_TERR_DIM_PARTITIONS, MOT_TERR_DIM_MEMBERS_B WHERE MOT_TERR_DIM_PARTITIONS.TERR_DIM_PARTITION_ID = MOT_TERR_DIM_MEMBERS_B.PARTITION_ID AND MOT_TERR_DIM_PARTITIONS.TYPE_CODE = 'PRODUCTION' AND MOT_TERR_DIM_MEMBERS_B.TERR_DIMENSION_CODE not in ( 'Acct','Prtnr','Geo')