DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ONT_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 572: hz_cust_acct_sites_all acct_site

568:
569: SELECT site.site_use_id
570: INTO l_header_rec.invoice_to_org_id
571: FROM hz_cust_site_uses_all site,
572: hz_cust_acct_sites_all acct_site
573: WHERE site.cust_acct_site_id = acct_site.cust_acct_site_id
574: AND site.site_use_code = 'BILL_TO'
575: AND site.org_id = acct_site.org_id
576: AND acct_site.cust_account_id = l_header_rec.sold_to_org_id