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

MOO_REVN_MET_TERR_ROLLUP_V

Details

  • Schema: FUSION

  • Object owner: MOO

  • Object type: VIEW

Columns

Name

PERIOD_NAME

START_DATE

END_DATE

SALES_CREDIT_TYPE_CODE

TERRITORY_ID

REVN_METRIC_TYPE

COMMIT_FLAG

REVN_METRIC_VALUE

Query

SQL_Statement

SELECT

period_name,

start_date,

end_date,

sales_credit_type_code,

tdn.territory_id,

revn_metric_type,

commit_flag,

SUM(revn_metric_value) revn_metric_value

FROM

moo_revn_metrics_v mv,

mot_terr_hierarchy_dn tdn

WHERE

mv.territory_id = tdn.descendant_territory_id

GROUP BY

period_name,

start_date,

end_date,

sales_credit_type_code,

tdn.territory_id,

revn_metric_type,

commit_flag