DBA Data[Home] [Help]

APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1778: FROM hz_cust_acct_sites_all acct_site ,

1774: --Code modified for bug10634985
1775: CURSOR c_get_cust_dtl IS
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'

Line 1792: FROM hz_cust_acct_sites_all acct_site ,

1788: AND site.site_use_id = p_supp_trade_profile_rec.site_use_id;
1789:
1790: /* SELECT acct_site.cust_account_id ,
1791: acct_site.cust_acct_site_id
1792: FROM hz_cust_acct_sites_all acct_site ,
1793: hz_party_sites party_site ,
1794: hz_locations loc ,
1795: hz_cust_site_uses_all site ,
1796: hz_parties party ,