APPS.POS_ASN_XML dependencies on HZ_LOCATIONS

Line 337: FROM hz_locations

333: where pll.line_location_id = p_po_line_location_id;
334:
335: SELECT count(*)
336: INTO l_loc_count
337: FROM hz_locations
338: WHERE
339: address1 = p_address1 and
340: nvl(address2, 99) = nvl(p_address2, 99) and
341: city = p_city and

Line 351: FROM hz_locations

347:
348: /*
349: SELECT min(location_id)
350: INTO p_ship_to_location_id
351: FROM hz_locations
352: WHERE
353: address1 = p_address1 and
354: nvl(address2, 99) = nvl(p_address2, 99) and
355: city = p_city and

Line 456: hz_locations loc,

452:
453: SELECT count(*)
454: INTO l_loc_count
455: FROM
456: hz_locations loc,
457: hz_party_sites party,
458: hz_cust_acct_sites_all cust
459: WHERE
460: cust.ece_tp_location_code = p_ship_to_partner_id

Line 473: hz_locations loc,

469:
470: SELECT min(loc.location_id)
471: INTO p_ship_to_location_id
472: FROM
473: hz_locations loc,
474: hz_party_sites party,
475: hz_cust_acct_sites_all cust
476: WHERE
477: cust.ece_tp_location_code = p_ship_to_partner_id