DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ONT_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 592: hz_cust_acct_sites_all acct_site

588:
589: SELECT site.site_use_id
590: INTO l_header_rec.invoice_to_org_id
591: FROM hz_cust_site_uses_all site,
592: hz_cust_acct_sites_all acct_site
593: WHERE site.cust_acct_site_id = acct_site.cust_acct_site_id
594: AND site.site_use_code = 'BILL_TO'
595: AND site.org_id = acct_site.org_id
596: AND acct_site.cust_account_id = l_header_rec.sold_to_org_id