APPS.OE_LINE_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 15672: FROM HZ_CUST_SITE_USES_ALL u,

15668: SELECT /*MOAC_SQL_CHANGES*/ u.cust_acct_site_id,
15669: s.cust_account_id
15670: INTO l_address_id,
15671: l_cust_id
15672: FROM HZ_CUST_SITE_USES_ALL u,
15673: HZ_CUST_ACCT_SITES s
15674: WHERE u.cust_acct_site_id = s.cust_acct_site_id
15675: AND u.site_use_id = p_x_line_rec.ship_to_org_id
15676: AND u.site_use_code = 'SHIP_TO';

Line 21096: FROM HZ_CUST_SITE_USES_ALL site,

21092: x_city,
21093: x_state,
21094: x_zip,
21095: x_country
21096: FROM HZ_CUST_SITE_USES_ALL site,
21097: HZ_CUST_ACCT_SITES cas,
21098: hz_cust_accounts cust,
21099: hz_parties party,
21100: hz_party_sites ps,