ZSP_ODM_PROD_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ZSP
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
SALES_ACCOUNT_ID ASSETS |
問合せ
| 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 |