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_MATCH_RULE_37 dependencies on HZ_PARTY_SITES

Line 356: FROM HZ_PARTY_SITES, HZ_LOCATIONS

352: IF p_attribute = 'CITY' THEN
353: BEGIN
354: SELECT HZ_LOCATIONS.CITY
355: INTO l_matched_value
356: FROM HZ_PARTY_SITES, HZ_LOCATIONS
357: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
358: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN

Line 357: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

353: BEGIN
354: SELECT HZ_LOCATIONS.CITY
355: INTO l_matched_value
356: FROM HZ_PARTY_SITES, HZ_LOCATIONS
357: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
358: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN
361: l_matched_value := 'Err';

Line 358: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

354: SELECT HZ_LOCATIONS.CITY
355: INTO l_matched_value
356: FROM HZ_PARTY_SITES, HZ_LOCATIONS
357: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
358: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN
361: l_matched_value := 'Err';
362: END;

Line 369: FROM HZ_PARTY_SITES, HZ_LOCATIONS

365: IF p_attribute = 'POSTAL_CODE' THEN
366: BEGIN
367: SELECT HZ_LOCATIONS.POSTAL_CODE
368: INTO l_matched_value
369: FROM HZ_PARTY_SITES, HZ_LOCATIONS
370: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
371: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN

Line 370: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

366: BEGIN
367: SELECT HZ_LOCATIONS.POSTAL_CODE
368: INTO l_matched_value
369: FROM HZ_PARTY_SITES, HZ_LOCATIONS
370: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
371: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN
374: l_matched_value := 'Err';

Line 371: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

367: SELECT HZ_LOCATIONS.POSTAL_CODE
368: INTO l_matched_value
369: FROM HZ_PARTY_SITES, HZ_LOCATIONS
370: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
371: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN
374: l_matched_value := 'Err';
375: END;

Line 382: FROM HZ_PARTY_SITES, HZ_LOCATIONS

378: IF p_attribute = 'PROVINCE' THEN
379: BEGIN
380: SELECT HZ_LOCATIONS.PROVINCE
381: INTO l_matched_value
382: FROM HZ_PARTY_SITES, HZ_LOCATIONS
383: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
384: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
385: EXCEPTION
386: WHEN NO_DATA_FOUND THEN

Line 383: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

379: BEGIN
380: SELECT HZ_LOCATIONS.PROVINCE
381: INTO l_matched_value
382: FROM HZ_PARTY_SITES, HZ_LOCATIONS
383: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
384: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
385: EXCEPTION
386: WHEN NO_DATA_FOUND THEN
387: l_matched_value := 'Err';

Line 384: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

380: SELECT HZ_LOCATIONS.PROVINCE
381: INTO l_matched_value
382: FROM HZ_PARTY_SITES, HZ_LOCATIONS
383: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
384: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
385: EXCEPTION
386: WHEN NO_DATA_FOUND THEN
387: l_matched_value := 'Err';
388: END;

Line 395: FROM HZ_PARTY_SITES, HZ_LOCATIONS

391: IF p_attribute = 'STATE' THEN
392: BEGIN
393: SELECT HZ_LOCATIONS.STATE
394: INTO l_matched_value
395: FROM HZ_PARTY_SITES, HZ_LOCATIONS
396: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
397: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
398: EXCEPTION
399: WHEN NO_DATA_FOUND THEN

Line 396: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

392: BEGIN
393: SELECT HZ_LOCATIONS.STATE
394: INTO l_matched_value
395: FROM HZ_PARTY_SITES, HZ_LOCATIONS
396: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
397: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
398: EXCEPTION
399: WHEN NO_DATA_FOUND THEN
400: l_matched_value := 'Err';

Line 397: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

393: SELECT HZ_LOCATIONS.STATE
394: INTO l_matched_value
395: FROM HZ_PARTY_SITES, HZ_LOCATIONS
396: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
397: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
398: EXCEPTION
399: WHEN NO_DATA_FOUND THEN
400: l_matched_value := 'Err';
401: END;

Line 408: FROM HZ_PARTY_SITES, HZ_LOCATIONS

404: IF p_attribute = 'COUNTY' THEN
405: BEGIN
406: SELECT HZ_LOCATIONS.COUNTY
407: INTO l_matched_value
408: FROM HZ_PARTY_SITES, HZ_LOCATIONS
409: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
410: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
411: EXCEPTION
412: WHEN NO_DATA_FOUND THEN

Line 409: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

405: BEGIN
406: SELECT HZ_LOCATIONS.COUNTY
407: INTO l_matched_value
408: FROM HZ_PARTY_SITES, HZ_LOCATIONS
409: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
410: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
411: EXCEPTION
412: WHEN NO_DATA_FOUND THEN
413: l_matched_value := 'Err';

Line 410: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

406: SELECT HZ_LOCATIONS.COUNTY
407: INTO l_matched_value
408: FROM HZ_PARTY_SITES, HZ_LOCATIONS
409: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
410: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
411: EXCEPTION
412: WHEN NO_DATA_FOUND THEN
413: l_matched_value := 'Err';
414: END;

Line 421: FROM HZ_PARTY_SITES, HZ_LOCATIONS

417: IF p_attribute = 'COUNTRY' THEN
418: BEGIN
419: SELECT HZ_LOCATIONS.COUNTRY
420: INTO l_matched_value
421: FROM HZ_PARTY_SITES, HZ_LOCATIONS
422: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
423: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN

Line 422: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

418: BEGIN
419: SELECT HZ_LOCATIONS.COUNTRY
420: INTO l_matched_value
421: FROM HZ_PARTY_SITES, HZ_LOCATIONS
422: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
423: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
426: l_matched_value := 'Err';

Line 423: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

419: SELECT HZ_LOCATIONS.COUNTRY
420: INTO l_matched_value
421: FROM HZ_PARTY_SITES, HZ_LOCATIONS
422: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
423: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
426: l_matched_value := 'Err';
427: END;

Line 4148: where owner_table_name = 'HZ_PARTY_SITES'

4144: p_contact_ids HZ_PARTY_SEARCH.IDList;
4145: l_match_idx NUMBER;
4146: cursor get_cpts_for_party_sites is select contact_point_id
4147: from hz_contact_points
4148: where owner_table_name = 'HZ_PARTY_SITES'
4149: and primary_flag='Y'
4150: and owner_table_id = p_party_site_id;
4151: BEGIN
4152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5519: FROM HZ_PARTY_SITES

5515: l_party_id := null;
5516: FOR PARTY_SITES IN (
5517: SELECT party_site_id FROM (
5518: SELECT party_site_id,identifying_address_flag
5519: FROM HZ_PARTY_SITES
5520: WHERE party_id = p_party_id
5521: AND (status is null OR status = 'A')
5522: AND identifying_address_flag='Y'
5523: UNION

Line 5526: FROM HZ_PARTY_SITES

5522: AND identifying_address_flag='Y'
5523: UNION
5524:
5525: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5526: FROM HZ_PARTY_SITES
5527: WHERE party_id = p_party_id
5528: AND (status is null OR status = 'A')
5529: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5530: AND ROWNUM<6

Line 5534: FROM HZ_PARTY_SITES

5530: AND ROWNUM<6
5531: UNION
5532:
5533: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5534: FROM HZ_PARTY_SITES
5535: WHERE (status is null OR status = 'A')
5536: AND party_id in (
5537: SELECT party_id
5538: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5660: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5656: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
5657: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5658: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5659: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5660: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5661: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5662: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5663:
5664: I NUMBER;

Line 5661: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5657: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5658: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5659: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5660: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5661: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5662: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5663:
5664: I NUMBER;
5665: J NUMBER:=1;

Line 5662: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

5658: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5659: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5660: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5661: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5662: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5663:
5664: I NUMBER;
5665: J NUMBER:=1;
5666: l_party_site_id NUMBER;