ZSP_ODM_CUST_ASSETS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ZSP
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
SALES_ACCOUNT_ID CUSTOMER_WID PROD_WID |
問合せ
| SQL_Statement |
|---|
|
select distinct SalesAccount.SALES_ACCOUNT_ID SALES_ACCOUNT_ID, Asset.CUSTOMER_ID customer_wid, Asset.INVENTORY_ITEM_ID prod_wid from ZCA_ASSET Asset, ZCA_SALES_ACCOUNTS SalesAccount WHERE Asset.CUSTOMER_ID = SalesAccount.PARTY_ID AND Asset.INVENTORY_ITEM_ID IS NOT NULL |