DBA Data[Home] [Help]

APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on HZ_CUST_ACCOUNTS

Line 1780: hz_cust_accounts cust_acct

1776: SELECT cust_acct.party_id,
1777: acct_site.cust_acct_site_id
1778: FROM hz_cust_acct_sites_all acct_site ,
1779: hz_cust_site_uses_all site,
1780: hz_cust_accounts cust_acct
1781: WHERE site.site_use_code = 'BILL_TO'
1782: AND acct_site.status='A'
1783: AND site.status='A'
1784: AND cust_acct.status='A'

Line 1797: hz_cust_accounts cust_acct

1793: hz_party_sites party_site ,
1794: hz_locations loc ,
1795: hz_cust_site_uses_all site ,
1796: hz_parties party ,
1797: hz_cust_accounts cust_acct
1798: WHERE site.site_use_code = 'BILL_TO'
1799: AND site.cust_acct_site_id = acct_site.cust_acct_site_id
1800: AND acct_site.party_site_id= party_site.party_site_id
1801: AND party_site.location_id = loc.location_id