ZSP_ODM_CUST_REVN_V

Details

• Schema: FUSION

• Object owner: ZSP

• Object type: VIEW

Columns

Name
SALES_ACCOUNT_ID CUSTOMER_WID PROD_WID REVENUE SALE_PRICE TIME_TO_CLOSE CNT

Query

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