eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_ASN_XML dependencies on HZ_LOCATIONS

Line 320: FROM hz_locations

316: p_transaction_type := 'SHIP';
317:
318: SELECT count(*)
319: INTO l_loc_count
320: FROM hz_locations
321: WHERE
322: address1 = p_address1 and
323: nvl(address2, 99) = nvl(p_address2, 99) and
324: city = p_city and

Line 332: FROM hz_locations

328: if (l_loc_count = 1) then
329:
330: SELECT min(location_id)
331: INTO p_ship_to_location_id
332: FROM hz_locations
333: WHERE
334: address1 = p_address1 and
335: nvl(address2, 99) = nvl(p_address2, 99) and
336: city = p_city and

Line 435: hz_locations loc,

431:
432: SELECT count(*)
433: INTO l_loc_count
434: FROM
435: hz_locations loc,
436: hz_party_sites party,
437: hz_cust_acct_sites_all cust
438: WHERE
439: cust.ece_tp_location_code = p_ship_to_partner_id

Line 452: hz_locations loc,

448:
449: SELECT min(loc.location_id)
450: INTO p_ship_to_location_id
451: FROM
452: hz_locations loc,
453: hz_party_sites party,
454: hz_cust_acct_sites_all cust
455: WHERE
456: cust.ece_tp_location_code = p_ship_to_partner_id