DBA Data[Home] [Help]

APPS.OE_BULK_HOLDS_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 43: hz_cust_site_uses_all siteuse

39: INTO p_out_IDfound ,
40: l_Custid
41: FROM HZ_CUST_ACCOUNTS_ALL cust ,
42: HZ_CUST_ACCT_SITES_ALL site,
43: hz_cust_site_uses_all siteuse
44: WHERE siteuse.site_use_id = p_in_site_id
45: AND site.cust_acct_site_id = siteuse.cust_acct_site_id
46: AND siteuse.site_use_code ='BILL_TO'
47: AND siteuse.status = 'A'