APPS.OTA_OM_UPD_API dependencies on HZ_CUST_SITE_USES

Line 1238: From hz_cust_site_uses)rsu

1234: from HZ_LOCATIONS loc,HZ_CUST_ACCT_SITES acct_site,HZ_PARTY_SITES party_site
1235: where PARTY_SITE.location_id = LOC.location_id
1236: and ACCT_SITE.party_site_id = PARTY_SITE.party_site_id)rad,
1237: (Select cust_acct_site_id address_id,site_use_id,status
1238: From hz_cust_site_uses)rsu
1239: where rad.address_id = rsu.address_id and
1240: rsu.site_use_id = p_ship_to_org_id;
1241:
1242: --