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 4739: where owner_table_name = 'HZ_PARTY_SITES'

4735: p_contact_ids HZ_PARTY_SEARCH.IDList;
4736: l_match_idx NUMBER;
4737: cursor get_cpts_for_party_sites is select contact_point_id
4738: from hz_contact_points
4739: where owner_table_name = 'HZ_PARTY_SITES'
4740: and primary_flag='Y'
4741: and owner_table_id = p_party_site_id;
4742: BEGIN
4743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6208: FROM HZ_PARTY_SITES

6204: l_party_id := p_party_id;
6205: FOR PARTY_SITES IN (
6206: SELECT party_site_id FROM (
6207: SELECT party_site_id,identifying_address_flag
6208: FROM HZ_PARTY_SITES
6209: WHERE party_id = p_party_id
6210: AND (status is null OR status = 'A')
6211: AND identifying_address_flag='Y'
6212: UNION

Line 6215: FROM HZ_PARTY_SITES

6211: AND identifying_address_flag='Y'
6212: UNION
6213:
6214: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6215: FROM HZ_PARTY_SITES
6216: WHERE party_id = p_party_id
6217: AND (status is null OR status = 'A')
6218: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
6219: AND ROWNUM<6

Line 6223: FROM HZ_PARTY_SITES

6219: AND ROWNUM<6
6220: UNION
6221:
6222: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6223: FROM HZ_PARTY_SITES
6224: WHERE (status is null OR status = 'A')
6225: AND party_id in (
6226: SELECT party_id
6227: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 6263: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6259: AND ROWNUM<6
6260: UNION
6261:
6262: SELECT CONTACT_POINT_ID
6263: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6264: WHERE PRIMARY_FLAG = 'Y'
6265: AND owner_table_name = 'HZ_PARTY_SITES'
6266: AND owner_table_id = party_site_id
6267: AND PARTY_ID = p_party_id

Line 6265: AND owner_table_name = 'HZ_PARTY_SITES'

6261:
6262: SELECT CONTACT_POINT_ID
6263: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6264: WHERE PRIMARY_FLAG = 'Y'
6265: AND owner_table_name = 'HZ_PARTY_SITES'
6266: AND owner_table_id = party_site_id
6267: AND PARTY_ID = p_party_id
6268: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
6269: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 6416: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6412: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6413: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6414: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6415: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6416: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6417: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6418: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6419:
6420: I NUMBER;

Line 6417: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

6413: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6414: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6415: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6416: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6417: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6418: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6419:
6420: I NUMBER;
6421: J NUMBER:=1;

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

6414: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6415: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6416: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6417: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6418: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6419:
6420: I NUMBER;
6421: J NUMBER:=1;
6422: l_party_site_id NUMBER;