EBS_AR_CUSTOMER 查询客户地点

STP1 查询客户

SELECT * FROM hz_parties hp where hp.party_name = '上海三兮国际贸易有限公司';

查询SITE

SELECT * FROM hz_party_sites hps where hps.party_id = 1589352;

查询 ADDRESS

SELECT replace(hl.address_key,' ',''), hl.* FROM HZ_LOCATIONS hl where hl.location_id in (113726,113740);

其他SQL

SELECT * FROM hz_cust_acct_sites_all;

SELECT * FROM hz_cust_acct_sites_all;

SELECT * FROM hz_party_sites h ;