APPS.OE_LINE_UTIL dependencies on HZ_CUST_ACCT_SITES

Line 17117: HZ_CUST_ACCT_SITES s

17113: s.cust_account_id
17114: INTO l_address_id,
17115: l_cust_id
17116: FROM HZ_CUST_SITE_USES_ALL u,
17117: HZ_CUST_ACCT_SITES s
17118: WHERE u.cust_acct_site_id = s.cust_acct_site_id
17119: AND u.site_use_id = p_x_line_rec.ship_to_org_id
17120: AND u.site_use_code = 'SHIP_TO';
17121: oe_debug_pub.add('ship to address:' || l_address_id||' - Customer:'||to_char(l_cust_id));

Line 22979: HZ_CUST_ACCT_SITES cas,

22975: x_state,
22976: x_zip,
22977: x_country
22978: FROM HZ_CUST_SITE_USES_ALL site,
22979: HZ_CUST_ACCT_SITES cas,
22980: hz_cust_accounts cust,
22981: hz_parties party,
22982: hz_party_sites ps,
22983: hz_locations addr