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

ZSP_ODM_PROD_V

Details

  • Schema: FUSION

  • Object owner: ZSP

  • Object type: VIEW

Columns

Name

SALES_ACCOUNT_ID

ASSETS

Query

SQL_Statement

select c.sales_account_id, a.assets

from zsp_odm_cust_v c

left outer join

(select sales_account_id,

cast(collect(dm_nested_numerical(prod_wid, 1))

as dm_nested_numericals) assets

from (select distinct sales_account_id, prod_wid

from (select sales_account_id, prod_wid

from zsp_odm_cust_assets_v

union all

select sales_account_id, prod_wid

from zsp_odm_cust_revn_v))

group by sales_account_id) a

on c.sales_account_id = a.sales_account_id