APPS.OE_LINE_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 17116: FROM HZ_CUST_SITE_USES_ALL u,

17112: SELECT /*MOAC_SQL_CHANGES*/ u.cust_acct_site_id,
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';

Line 22978: FROM HZ_CUST_SITE_USES_ALL site,

22974: x_city,
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,