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

MOT_TERR_BNDRY_VALS_DN_V

Details

  • Schema: FUSION

  • Object owner: MOT

  • Object type: VIEW

Columns

Name

TERR_RULE_BNDRY_VALS_DN_ID

TERRITORY_ID

TERRITORY_VERSION_ID

TERR_TYPE_CODE

TERR_STATUS_CODE

COVERAGE_MODEL

PARTNER_ID

PARTNER_PROGRAM_ID

TERR_RULE_ID

RULE_TYPE_CODE

RULE_OPERATOR_CODE

INCLUSION_FLAG

TERR_RULE_BOUNDARY_ID

TERR_DIMENSION_CODE

TERR_RULE_BNDRY_VALUE_ID

TERR_DIM_INTG_ID

TERR_DIM_HIGH_INTG_ID

TERR_DIM_INTG_SEQ_LOW

TERR_DIM_INTG_SEQ_HIGH

TERR_DIM_NODE_INTG_ID

REQUEST_ID

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CONFLICT_ID

OBJECT_VERSION_NUMBER

INCLUDE_HIERARCHY_FLAG

TERR_DIM_NODE_RANGE_LOW_NAME

TERR_DIM_NODE_RANGE_HIGH_NAME

TERR_DIM_NODE_PARENT_INTG_ID

TERRITORY_FUNCTION_CODE

ADDRESS_COUNTRY

ADDRESS_STATE

ADDRESS_PROVINCE

ADDRESS_COUNTY

ADDRESS_CITY

ADDRESS_POSTAL_CODE

ADDRESS_HIGH_POSTAL_CODE

ADDR_ELEMENT_ATTRIBUTE1

ADDR_ELEMENT_ATTRIBUTE2

ADDR_ELEMENT_ATTRIBUTE3

ADDR_ELEMENT_ATTRIBUTE4

ADDR_ELEMENT_ATTRIBUTE5

ADDR_OPERATOR_CODE

Query

SQL_Statement

SELECT

MOT_TERR_BNDRY_VALS_DN.TERR_RULE_BNDRY_VALS_DN_ID,

MOT_TERR_BNDRY_VALS_DN.TERRITORY_ID,

MOT_TERR_BNDRY_VALS_DN.TERRITORY_VERSION_ID,

MOT_TERR_BNDRY_VALS_DN.TERR_TYPE_CODE,

MOT_TERR_BNDRY_VALS_DN.TERR_STATUS_CODE,

MOT_TERR_BNDRY_VALS_DN.COVERAGE_MODEL,

MOT_TERR_BNDRY_VALS_DN.PARTNER_ID,

MOT_TERR_BNDRY_VALS_DN.PARTNER_PROGRAM_ID,

MOT_TERR_BNDRY_VALS_DN.TERR_RULE_ID,

MOT_TERR_BNDRY_VALS_DN.RULE_TYPE_CODE,

MOT_TERR_BNDRY_VALS_DN.RULE_OPERATOR_CODE,

DECODE(MOT_TERR_BNDRY_VALS_DN.RULE_OPERATOR_CODE, 'INCLUSION', 'Y', 'N') INCLUSION_FLAG,

MOT_TERR_BNDRY_VALS_DN.TERR_RULE_BOUNDARY_ID,

MOT_TERR_BNDRY_VALS_DN.TERR_DIMENSION_CODE,

MOT_TERR_BNDRY_VALS_DN.TERR_RULE_BNDRY_VALUE_ID,

MOT_TERR_BNDRY_VALS_DN.TERR_DIM_INTG_ID,

MOT_TERR_BNDRY_VALS_DN.TERR_DIM_HIGH_INTG_ID,

MOT_TERR_BNDRY_VALS_DN.TERR_DIM_INTG_SEQ_LOW,

MOT_TERR_BNDRY_VALS_DN.TERR_DIM_INTG_SEQ_HIGH,

MOT_TERR_BNDRY_VALS_DN.TERR_DIM_NODE_INTG_ID,

MOT_TERR_BNDRY_VALS_DN.REQUEST_ID,

MOT_TERR_BNDRY_VALS_DN.CREATION_DATE,

MOT_TERR_BNDRY_VALS_DN.CREATED_BY,

MOT_TERR_BNDRY_VALS_DN.LAST_UPDATE_DATE,

MOT_TERR_BNDRY_VALS_DN.LAST_UPDATED_BY,

MOT_TERR_BNDRY_VALS_DN.LAST_UPDATE_LOGIN,

MOT_TERR_BNDRY_VALS_DN.CONFLICT_ID,

MOT_TERR_BNDRY_VALS_DN.OBJECT_VERSION_NUMBER,

MOT_TERR_BNDRY_VALS_DN.INCLUDE_HIERARCHY_FLAG,

MOT_TERR_BNDRY_VALS_DN.TERR_DIM_NODE_RANGE_LOW_NAME,

MOT_TERR_BNDRY_VALS_DN.TERR_DIM_NODE_RANGE_HIGH_NAME,

MOT_TERR_BNDRY_VALS_DN.TERR_DIM_NODE_PARENT_INTG_ID,

MOT_TERR_BNDRY_VALS_DN.TERRITORY_FUNCTION_CODE,

MOT_TERR_BNDRY_VALS_DN.ADDRESS_COUNTRY ADDRESS_COUNTRY,

MOT_TERR_BNDRY_VALS_DN.ADDRESS_STATE ADDRESS_STATE,

MOT_TERR_BNDRY_VALS_DN.ADDRESS_PROVINCE ADDRESS_PROVINCE,

MOT_TERR_BNDRY_VALS_DN.ADDRESS_COUNTY ADDRESS_COUNTY,

MOT_TERR_BNDRY_VALS_DN.ADDRESS_CITY ADDRESS_CITY,

MOT_TERR_BNDRY_VALS_DN.ADDRESS_POSTAL_CODE ADDRESS_POSTAL_CODE,

MOT_TERR_BNDRY_VALS_DN.ADDRESS_HIGH_POSTAL_CODE ADDRESS_HIGH_POSTAL_CODE,

MOT_TERR_BNDRY_VALS_DN.ADDR_ELEMENT_ATTRIBUTE1 ADDR_ELEMENT_ATTRIBUTE1,

MOT_TERR_BNDRY_VALS_DN.ADDR_ELEMENT_ATTRIBUTE2 ADDR_ELEMENT_ATTRIBUTE2,

MOT_TERR_BNDRY_VALS_DN.ADDR_ELEMENT_ATTRIBUTE3 ADDR_ELEMENT_ATTRIBUTE3,

MOT_TERR_BNDRY_VALS_DN.ADDR_ELEMENT_ATTRIBUTE4 ADDR_ELEMENT_ATTRIBUTE4,

MOT_TERR_BNDRY_VALS_DN.ADDR_ELEMENT_ATTRIBUTE5 ADDR_ELEMENT_ATTRIBUTE5,

MOT_TERR_BNDRY_VALS_DN.ADDR_OPERATOR_CODE ADDR_OPERATOR_CODE

FROM

MOT_TERR_BNDRY_VALS_DN

WHERE

MOT_TERR_BNDRY_VALS_DN.TERR_STATUS_CODE = 'FINALIZED' AND MOT_TERR_BNDRY_VALS_DN.PARTITION_ID IN (SELECT

TERR_DIM_PARTITION_ID

FROM

MOT_TERR_DIM_PARTITIONS

WHERE

TYPE_CODE = 'PRODUCTION')