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

MOT_QM_TERR_RESOURCES_VL

Details

  • Schema: FUSION

  • Object owner: MOT

  • Object type: VIEW

Columns

Name

TERR_RESOURCE_ID

RESOURCE_ID

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CONFLICT_ID

OBJECT_VERSION_NUMBER

TERRITORY_VERSION_ID

RESOURCE_ORG_ID

ADMIN_FLAG

FUNCTION_CODE

MANAGE_FORECAST_FLAG

TERRITORY_QUOTA_ID

QUOTA_PLAN_ID

Query

SQL_Statement

SELECT TerritoryResource.TERR_RESOURCE_ID,

TerritoryResource.RESOURCE_ID,

TerritoryResource.CREATION_DATE,

TerritoryResource.CREATED_BY,

TerritoryResource.LAST_UPDATE_DATE,

TerritoryResource.LAST_UPDATED_BY,

TerritoryResource.LAST_UPDATE_LOGIN,

TerritoryResource.CONFLICT_ID,

TerritoryResource.OBJECT_VERSION_NUMBER,

TerritoryResource.TERRITORY_VERSION_ID,

TerritoryResource.RESOURCE_ORG_ID,

TerritoryResource.ADMIN_FLAG,

TerritoryResource.FUNCTION_CODE,

TerritoryResource.MANAGE_FORECAST_FLAG,

TerritoryQuota.territory_quota_id,

TerritoryQuota.quota_plan_id

FROM MOT_TERR_RESOURCES TerritoryResource,

MOT_QM_TERRITORY_QUOTAS TerritoryQuota

WHERE TerritoryResource.territory_version_id = TerritoryQuota.territory_version_id