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

Line 491: FROM HZ_PARTY_SITES, HZ_LOCATIONS

487: IF p_attribute = 'CITY' THEN
488: BEGIN
489: SELECT HZ_LOCATIONS.CITY
490: INTO l_matched_value
491: FROM HZ_PARTY_SITES, HZ_LOCATIONS
492: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
493: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
494: EXCEPTION
495: WHEN NO_DATA_FOUND THEN

Line 492: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

488: BEGIN
489: SELECT HZ_LOCATIONS.CITY
490: INTO l_matched_value
491: FROM HZ_PARTY_SITES, HZ_LOCATIONS
492: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
493: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
494: EXCEPTION
495: WHEN NO_DATA_FOUND THEN
496: l_matched_value := 'Err';

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

489: SELECT HZ_LOCATIONS.CITY
490: INTO l_matched_value
491: FROM HZ_PARTY_SITES, HZ_LOCATIONS
492: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
493: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
494: EXCEPTION
495: WHEN NO_DATA_FOUND THEN
496: l_matched_value := 'Err';
497: END;

Line 504: FROM HZ_PARTY_SITES, HZ_LOCATIONS

500: IF p_attribute = 'POSTAL_CODE' THEN
501: BEGIN
502: SELECT HZ_LOCATIONS.POSTAL_CODE
503: INTO l_matched_value
504: FROM HZ_PARTY_SITES, HZ_LOCATIONS
505: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
506: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN

Line 505: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

501: BEGIN
502: SELECT HZ_LOCATIONS.POSTAL_CODE
503: INTO l_matched_value
504: FROM HZ_PARTY_SITES, HZ_LOCATIONS
505: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
506: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN
509: l_matched_value := 'Err';

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

502: SELECT HZ_LOCATIONS.POSTAL_CODE
503: INTO l_matched_value
504: FROM HZ_PARTY_SITES, HZ_LOCATIONS
505: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
506: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN
509: l_matched_value := 'Err';
510: END;

Line 517: FROM HZ_PARTY_SITES, HZ_LOCATIONS

513: IF p_attribute = 'PROVINCE' THEN
514: BEGIN
515: SELECT HZ_LOCATIONS.PROVINCE
516: INTO l_matched_value
517: FROM HZ_PARTY_SITES, HZ_LOCATIONS
518: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
519: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN

Line 518: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

514: BEGIN
515: SELECT HZ_LOCATIONS.PROVINCE
516: INTO l_matched_value
517: FROM HZ_PARTY_SITES, HZ_LOCATIONS
518: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
519: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN
522: l_matched_value := 'Err';

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

515: SELECT HZ_LOCATIONS.PROVINCE
516: INTO l_matched_value
517: FROM HZ_PARTY_SITES, HZ_LOCATIONS
518: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
519: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN
522: l_matched_value := 'Err';
523: END;

Line 530: FROM HZ_PARTY_SITES, HZ_LOCATIONS

526: IF p_attribute = 'STATE' THEN
527: BEGIN
528: SELECT HZ_LOCATIONS.STATE
529: INTO l_matched_value
530: FROM HZ_PARTY_SITES, HZ_LOCATIONS
531: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
532: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN

Line 531: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

527: BEGIN
528: SELECT HZ_LOCATIONS.STATE
529: INTO l_matched_value
530: FROM HZ_PARTY_SITES, HZ_LOCATIONS
531: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
532: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: l_matched_value := 'Err';

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

528: SELECT HZ_LOCATIONS.STATE
529: INTO l_matched_value
530: FROM HZ_PARTY_SITES, HZ_LOCATIONS
531: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
532: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: l_matched_value := 'Err';
536: END;

Line 543: FROM HZ_PARTY_SITES, HZ_LOCATIONS

539: IF p_attribute = 'COUNTRY' THEN
540: BEGIN
541: SELECT HZ_LOCATIONS.COUNTRY
542: INTO l_matched_value
543: FROM HZ_PARTY_SITES, HZ_LOCATIONS
544: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
545: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN

Line 544: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

540: BEGIN
541: SELECT HZ_LOCATIONS.COUNTRY
542: INTO l_matched_value
543: FROM HZ_PARTY_SITES, HZ_LOCATIONS
544: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
545: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN
548: l_matched_value := 'Err';

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

541: SELECT HZ_LOCATIONS.COUNTRY
542: INTO l_matched_value
543: FROM HZ_PARTY_SITES, HZ_LOCATIONS
544: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
545: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN
548: l_matched_value := 'Err';
549: END;

Line 4747: where owner_table_name = 'HZ_PARTY_SITES'

4743: p_contact_ids HZ_PARTY_SEARCH.IDList;
4744: l_match_idx NUMBER;
4745: cursor get_cpts_for_party_sites is select contact_point_id
4746: from hz_contact_points
4747: where owner_table_name = 'HZ_PARTY_SITES'
4748: and primary_flag='Y'
4749: and owner_table_id = p_party_site_id;
4750: BEGIN
4751: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6219: FROM HZ_PARTY_SITES

6215: l_party_id := p_party_id;
6216: FOR PARTY_SITES IN (
6217: SELECT party_site_id FROM (
6218: SELECT party_site_id,identifying_address_flag
6219: FROM HZ_PARTY_SITES
6220: WHERE party_id = p_party_id
6221: AND (status is null OR status = 'A')
6222: AND identifying_address_flag='Y'
6223: UNION

Line 6226: FROM HZ_PARTY_SITES

6222: AND identifying_address_flag='Y'
6223: UNION
6224:
6225: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6226: FROM HZ_PARTY_SITES
6227: WHERE party_id = p_party_id
6228: AND (status is null OR status = 'A')
6229: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
6230: AND ROWNUM<6

Line 6234: FROM HZ_PARTY_SITES

6230: AND ROWNUM<6
6231: UNION
6232:
6233: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6234: FROM HZ_PARTY_SITES
6235: WHERE (status is null OR status = 'A')
6236: AND party_id in (
6237: SELECT party_id
6238: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 6274: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6270: AND ROWNUM<6
6271: UNION
6272:
6273: SELECT CONTACT_POINT_ID
6274: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6275: WHERE PRIMARY_FLAG = 'Y'
6276: AND owner_table_name = 'HZ_PARTY_SITES'
6277: AND owner_table_id = party_site_id
6278: AND PARTY_ID = p_party_id

Line 6276: AND owner_table_name = 'HZ_PARTY_SITES'

6272:
6273: SELECT CONTACT_POINT_ID
6274: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6275: WHERE PRIMARY_FLAG = 'Y'
6276: AND owner_table_name = 'HZ_PARTY_SITES'
6277: AND owner_table_id = party_site_id
6278: AND PARTY_ID = p_party_id
6279: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
6280: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6423: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6424: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6425: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6426: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6428: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6429: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6430:
6431: I NUMBER;

Line 6428: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

6424: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6425: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6426: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6428: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6429: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6430:
6431: I NUMBER;
6432: J NUMBER:=1;

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

6425: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6426: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6428: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6429: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6430:
6431: I NUMBER;
6432: J NUMBER:=1;
6433: l_party_site_id NUMBER;