DBA Data[Home] [Help]

APPS.WSH_ITM_PARTY_SYNC dependencies on HZ_CUST_ACCOUNTS

Line 86: 'hz_cust_accounts acct,'||

82: 'site_uses.primary_flag address_type ' ||
83: ' FROM '||
84: 'hz_cust_site_uses_all site_uses,'||
85: 'hz_cust_acct_sites_all acct_site,'||
86: 'hz_cust_accounts acct,'||
87: 'hz_party_sites party_site,'||
88: 'hz_parties party,'||
89: 'hz_locations loc ,'||
90: 'hz_Person_profiles person_profile '||

Line 317: HZ_CUST_ACCOUNTS HC

313: SELECT
314: HP.party_name
315: FROM
316: hz_parties HP,
317: HZ_CUST_ACCOUNTS HC
318: WHERE
319: HP.PARTY_ID = HC.PARTY_ID AND
320: hc.cust_account_id = TO_NUMBER(c_account_id);
321: