ZSP_ODM_CUST_REVN_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ZSP
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
SALES_ACCOUNT_ID CUSTOMER_WID PROD_WID REVENUE SALE_PRICE TIME_TO_CLOSE CNT |
問合せ
| SQL_Statement |
|---|
|
select sales_account_id,customer_wid, prod_wid, max(revenue) revenue, max(sale_price) sale_price, max(time_to_close) time_to_close, count(*) cnt from zsp_odm_opty_v group by sales_account_id,customer_wid, prod_wid |