MOO_REVN_MET_TERR_ROLLUP_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MOO
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
PERIOD_NAME START_DATE END_DATE SALES_CREDIT_TYPE_CODE TERRITORY_ID REVN_METRIC_TYPE COMMIT_FLAG REVN_METRIC_VALUE |
問合せ
| 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 |