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.HZ_ELOCATION_PKG dependencies on HZ_PARTY_SITES

Line 331: hz_party_sites hps

327: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
328: FROM hz_locations hl
329: WHERE EXISTS (SELECT 1
330: FROM hz_party_site_uses hpsu,
331: hz_party_sites hps
332: WHERE hpsu.site_use_type = p_site_use_type
333: AND hpsu.party_site_id = hps.party_site_id
334: AND hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)
335: AND hps.location_id = hl.location_id)

Line 349: hz_party_sites hps

345: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
346: FROM hz_locations hl
347: WHERE EXISTS (SELECT 1
348: FROM hz_party_site_uses hpsu,
349: hz_party_sites hps
350: WHERE hpsu.site_use_type = p_site_use_type
351: AND hpsu.party_site_id = hps.party_site_id
352: AND hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)
353: AND hps.location_id = hl.location_id)

Line 367: hz_party_sites hps

363: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
364: FROM hz_locations hl
365: WHERE EXISTS (SELECT 1
366: FROM hz_party_site_uses hpsu,
367: hz_party_sites hps
368: WHERE hpsu.site_use_type = p_site_use_type
369: AND hpsu.party_site_id = hps.party_site_id
370: AND hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)
371: AND hps.location_id = hl.location_id)

Line 385: hz_party_sites hps

381: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
382: FROM hz_locations hl
383: WHERE EXISTS (SELECT 1
384: FROM hz_party_site_uses hpsu,
385: hz_party_sites hps
386: WHERE hpsu.site_use_type = p_site_use_type
387: AND hpsu.party_site_id = hps.party_site_id
388: AND hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)
389: AND hps.location_id = hl.location_id)

Line 403: FROM hz_party_sites hps

399: SELECT hl.location_id, hl.address1, hl.address2, hl.address3, hl.address4,
400: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
401: FROM hz_locations hl
402: WHERE EXISTS (SELECT 1
403: FROM hz_party_sites hps
404: WHERE hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)
405: AND hps.location_id = hl.location_id)
406: AND NVL(hl.request_id, -1) <> NVL(p_request_id, -2);
407:

Line 417: FROM hz_party_sites hps

413: SELECT hl.location_id, hl.address1, hl.address2, hl.address3, hl.address4,
414: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
415: FROM hz_locations hl
416: WHERE EXISTS (SELECT 1
417: FROM hz_party_sites hps
418: WHERE hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)
419: AND hps.location_id = hl.location_id)
420: AND hl.country = p_country
421: AND NVL(hl.request_id, -1) <> NVL(p_request_id, -2);

Line 431: FROM hz_party_sites hps

427: SELECT hl.location_id, hl.address1, hl.address2, hl.address3, hl.address4,
428: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
429: FROM hz_locations hl
430: WHERE EXISTS (SELECT 1
431: FROM hz_party_sites hps
432: WHERE hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)
433: AND hps.location_id = hl.location_id)
434: AND NVL(hl.request_id, -1) <> NVL(p_request_id, -2)
435: AND (hl.geometry_status_code = 'DIRTY' OR hl.geometry_status_code IS NULL);

Line 446: FROM hz_party_sites hps

442: SELECT hl.location_id, hl.address1, hl.address2, hl.address3, hl.address4,
443: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
444: FROM hz_locations hl
445: WHERE EXISTS (SELECT 1
446: FROM hz_party_sites hps
447: WHERE hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)
448: AND hps.location_id = hl.location_id)
449: AND hl.country = p_country
450: AND NVL(hl.request_id, -1) <> NVL(p_request_id, -2)

Line 462: FROM HZ_PARTY_SITES hps

458: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
459: FROM hz_locations hl
460: WHERE NVL(hl.request_id, -1) <> NVL(p_request_id, -2)
461: AND NOT EXISTS (SELECT 1
462: FROM HZ_PARTY_SITES hps
463: WHERE hps.location_id = hl.location_id );
464:
465: -- run this query if we are running for Standalone Locations
466: -- and NOT in incremental mode

Line 475: FROM HZ_PARTY_SITES hps

471: FROM hz_locations hl
472: WHERE hl.country = p_country
473: AND NVL(hl.request_id, -1) <> NVL(p_request_id, -2)
474: AND NOT EXISTS (SELECT 1
475: FROM HZ_PARTY_SITES hps
476: WHERE hps.location_id = hl.location_id );
477:
478: -- run this query if we are running for Standalone Locations
479: -- and in incremental mode

Line 488: FROM HZ_PARTY_SITES hps

484: FROM hz_locations hl
485: WHERE NVL(hl.request_id, -1) <> NVL(p_request_id, -2)
486: AND (hl.geometry_status_code = 'DIRTY' OR hl.geometry_status_code IS NULL)
487: AND NOT EXISTS (SELECT 1
488: FROM HZ_PARTY_SITES hps
489: WHERE hps.location_id = hl.location_id );
490:
491: -- run this query if we are running for Standalone Locations
492: -- and in incremental mode

Line 502: FROM HZ_PARTY_SITES hps

498: WHERE hl.country = p_country
499: AND NVL(hl.request_id, -1) <> NVL(p_request_id, -2)
500: AND (hl.geometry_status_code = 'DIRTY' OR hl.geometry_status_code IS NULL)
501: AND NOT EXISTS (SELECT 1
502: FROM HZ_PARTY_SITES hps
503: WHERE hps.location_id = hl.location_id );
504:
505: l_array hz_geocode_pkg.loc_array := hz_geocode_pkg.loc_array();
506: l_rec hz_location_v2pub.location_rec_type;