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

Line 470: FROM HZ_PARTY_SITES, HZ_LOCATIONS

466: IF p_attribute = 'CITY' THEN
467: BEGIN
468: SELECT HZ_LOCATIONS.CITY
469: INTO l_matched_value
470: FROM HZ_PARTY_SITES, HZ_LOCATIONS
471: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
472: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
473: EXCEPTION
474: WHEN NO_DATA_FOUND THEN

Line 471: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

467: BEGIN
468: SELECT HZ_LOCATIONS.CITY
469: INTO l_matched_value
470: FROM HZ_PARTY_SITES, HZ_LOCATIONS
471: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
472: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
473: EXCEPTION
474: WHEN NO_DATA_FOUND THEN
475: l_matched_value := 'Err';

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

468: SELECT HZ_LOCATIONS.CITY
469: INTO l_matched_value
470: FROM HZ_PARTY_SITES, HZ_LOCATIONS
471: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
472: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
473: EXCEPTION
474: WHEN NO_DATA_FOUND THEN
475: l_matched_value := 'Err';
476: END;

Line 483: FROM HZ_PARTY_SITES, HZ_LOCATIONS

479: IF p_attribute = 'POSTAL_CODE' THEN
480: BEGIN
481: SELECT HZ_LOCATIONS.POSTAL_CODE
482: INTO l_matched_value
483: FROM HZ_PARTY_SITES, HZ_LOCATIONS
484: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
485: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
486: EXCEPTION
487: WHEN NO_DATA_FOUND THEN

Line 484: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

480: BEGIN
481: SELECT HZ_LOCATIONS.POSTAL_CODE
482: INTO l_matched_value
483: FROM HZ_PARTY_SITES, HZ_LOCATIONS
484: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
485: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
486: EXCEPTION
487: WHEN NO_DATA_FOUND THEN
488: l_matched_value := 'Err';

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

481: SELECT HZ_LOCATIONS.POSTAL_CODE
482: INTO l_matched_value
483: FROM HZ_PARTY_SITES, HZ_LOCATIONS
484: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
485: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
486: EXCEPTION
487: WHEN NO_DATA_FOUND THEN
488: l_matched_value := 'Err';
489: END;

Line 496: FROM HZ_PARTY_SITES, HZ_LOCATIONS

492: IF p_attribute = 'PROVINCE' THEN
493: BEGIN
494: SELECT HZ_LOCATIONS.PROVINCE
495: INTO l_matched_value
496: FROM HZ_PARTY_SITES, HZ_LOCATIONS
497: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
498: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
499: EXCEPTION
500: WHEN NO_DATA_FOUND THEN

Line 497: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

493: BEGIN
494: SELECT HZ_LOCATIONS.PROVINCE
495: INTO l_matched_value
496: FROM HZ_PARTY_SITES, HZ_LOCATIONS
497: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
498: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
499: EXCEPTION
500: WHEN NO_DATA_FOUND THEN
501: l_matched_value := 'Err';

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

494: SELECT HZ_LOCATIONS.PROVINCE
495: INTO l_matched_value
496: FROM HZ_PARTY_SITES, HZ_LOCATIONS
497: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
498: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
499: EXCEPTION
500: WHEN NO_DATA_FOUND THEN
501: l_matched_value := 'Err';
502: END;

Line 509: FROM HZ_PARTY_SITES, HZ_LOCATIONS

505: IF p_attribute = 'STATE' THEN
506: BEGIN
507: SELECT HZ_LOCATIONS.STATE
508: INTO l_matched_value
509: FROM HZ_PARTY_SITES, HZ_LOCATIONS
510: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
511: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
512: EXCEPTION
513: WHEN NO_DATA_FOUND THEN

Line 510: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

506: BEGIN
507: SELECT HZ_LOCATIONS.STATE
508: INTO l_matched_value
509: FROM HZ_PARTY_SITES, HZ_LOCATIONS
510: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
511: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
512: EXCEPTION
513: WHEN NO_DATA_FOUND THEN
514: l_matched_value := 'Err';

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

507: SELECT HZ_LOCATIONS.STATE
508: INTO l_matched_value
509: FROM HZ_PARTY_SITES, HZ_LOCATIONS
510: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
511: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
512: EXCEPTION
513: WHEN NO_DATA_FOUND THEN
514: l_matched_value := 'Err';
515: END;

Line 522: FROM HZ_PARTY_SITES, HZ_LOCATIONS

518: IF p_attribute = 'COUNTRY' THEN
519: BEGIN
520: SELECT HZ_LOCATIONS.COUNTRY
521: INTO l_matched_value
522: FROM HZ_PARTY_SITES, HZ_LOCATIONS
523: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
524: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN

Line 523: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

519: BEGIN
520: SELECT HZ_LOCATIONS.COUNTRY
521: INTO l_matched_value
522: FROM HZ_PARTY_SITES, HZ_LOCATIONS
523: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
524: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN
527: l_matched_value := 'Err';

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

520: SELECT HZ_LOCATIONS.COUNTRY
521: INTO l_matched_value
522: FROM HZ_PARTY_SITES, HZ_LOCATIONS
523: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
524: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN
527: l_matched_value := 'Err';
528: END;

Line 4742: where owner_table_name = 'HZ_PARTY_SITES'

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

Line 6211: FROM HZ_PARTY_SITES

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

Line 6218: FROM HZ_PARTY_SITES

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

Line 6226: FROM HZ_PARTY_SITES

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

Line 6279: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6275: AND ROWNUM<6
6276: UNION
6277:
6278: SELECT CONTACT_POINT_ID
6279: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6280: WHERE PRIMARY_FLAG = 'Y'
6281: AND owner_table_name = 'HZ_PARTY_SITES'
6282: AND owner_table_id = party_site_id
6283: AND PARTY_ID = p_party_id

Line 6281: AND owner_table_name = 'HZ_PARTY_SITES'

6277:
6278: SELECT CONTACT_POINT_ID
6279: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6280: WHERE PRIMARY_FLAG = 'Y'
6281: AND owner_table_name = 'HZ_PARTY_SITES'
6282: AND owner_table_id = party_site_id
6283: AND PARTY_ID = p_party_id
6284: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
6285: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6432: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6433: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6434: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6435: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6437: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6439:
6440: I NUMBER;

Line 6437: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

6433: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6434: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6435: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6437: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6439:
6440: I NUMBER;
6441: J NUMBER:=1;

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

6434: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6435: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6437: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6439:
6440: I NUMBER;
6441: J NUMBER:=1;
6442: l_party_site_id NUMBER;