ZSP_ODM_CUST_ASSETS_V

Details

• Schema: FUSION

• Object owner: ZSP

• Object type: VIEW

Columns

Name
SALES_ACCOUNT_ID CUSTOMER_WID PROD_WID

Query

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