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

Line 464: FROM HZ_PARTY_SITES, HZ_LOCATIONS

460: IF p_attribute = 'CITY' THEN
461: BEGIN
462: SELECT HZ_LOCATIONS.CITY
463: INTO l_matched_value
464: FROM HZ_PARTY_SITES, HZ_LOCATIONS
465: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
466: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
467: EXCEPTION
468: WHEN NO_DATA_FOUND THEN

Line 465: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

461: BEGIN
462: SELECT HZ_LOCATIONS.CITY
463: INTO l_matched_value
464: FROM HZ_PARTY_SITES, HZ_LOCATIONS
465: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
466: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
467: EXCEPTION
468: WHEN NO_DATA_FOUND THEN
469: l_matched_value := 'Err';

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

462: SELECT HZ_LOCATIONS.CITY
463: INTO l_matched_value
464: FROM HZ_PARTY_SITES, HZ_LOCATIONS
465: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
466: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
467: EXCEPTION
468: WHEN NO_DATA_FOUND THEN
469: l_matched_value := 'Err';
470: END;

Line 477: FROM HZ_PARTY_SITES, HZ_LOCATIONS

473: IF p_attribute = 'POSTAL_CODE' THEN
474: BEGIN
475: SELECT HZ_LOCATIONS.POSTAL_CODE
476: INTO l_matched_value
477: FROM HZ_PARTY_SITES, HZ_LOCATIONS
478: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
479: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
480: EXCEPTION
481: WHEN NO_DATA_FOUND THEN

Line 478: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

474: BEGIN
475: SELECT HZ_LOCATIONS.POSTAL_CODE
476: INTO l_matched_value
477: FROM HZ_PARTY_SITES, HZ_LOCATIONS
478: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
479: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
480: EXCEPTION
481: WHEN NO_DATA_FOUND THEN
482: l_matched_value := 'Err';

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

475: SELECT HZ_LOCATIONS.POSTAL_CODE
476: INTO l_matched_value
477: FROM HZ_PARTY_SITES, HZ_LOCATIONS
478: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
479: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
480: EXCEPTION
481: WHEN NO_DATA_FOUND THEN
482: l_matched_value := 'Err';
483: END;

Line 490: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 491: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 501: SELECT HZ_PARTY_SITES.PARTY_SITE_NUMBER

497: RETURN l_matched_value;
498: END IF;
499: IF p_attribute = 'PARTY_SITE_NUMBER' THEN
500: BEGIN
501: SELECT HZ_PARTY_SITES.PARTY_SITE_NUMBER
502: INTO l_matched_value
503: FROM HZ_PARTY_SITES, HZ_LOCATIONS
504: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
505: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 503: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 504: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 516: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 517: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 4711: where owner_table_name = 'HZ_PARTY_SITES'

4707: p_contact_ids HZ_PARTY_SEARCH.IDList;
4708: l_match_idx NUMBER;
4709: cursor get_cpts_for_party_sites is select contact_point_id
4710: from hz_contact_points
4711: where owner_table_name = 'HZ_PARTY_SITES'
4712: and primary_flag='Y'
4713: and owner_table_id = p_party_site_id;
4714: BEGIN
4715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6178: FROM HZ_PARTY_SITES

6174: l_party_id := p_party_id;
6175: FOR PARTY_SITES IN (
6176: SELECT party_site_id FROM (
6177: SELECT party_site_id,identifying_address_flag
6178: FROM HZ_PARTY_SITES
6179: WHERE party_id = p_party_id
6180: AND (status is null OR status = 'A')
6181: AND identifying_address_flag='Y'
6182: UNION

Line 6185: FROM HZ_PARTY_SITES

6181: AND identifying_address_flag='Y'
6182: UNION
6183:
6184: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6185: FROM HZ_PARTY_SITES
6186: WHERE party_id = p_party_id
6187: AND (status is null OR status = 'A')
6188: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
6189: AND ROWNUM<6

Line 6193: FROM HZ_PARTY_SITES

6189: AND ROWNUM<6
6190: UNION
6191:
6192: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6193: FROM HZ_PARTY_SITES
6194: WHERE (status is null OR status = 'A')
6195: AND party_id in (
6196: SELECT party_id
6197: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 6246: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6242: AND ROWNUM<6
6243: UNION
6244:
6245: SELECT CONTACT_POINT_ID
6246: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6247: WHERE PRIMARY_FLAG = 'Y'
6248: AND owner_table_name = 'HZ_PARTY_SITES'
6249: AND owner_table_id = party_site_id
6250: AND PARTY_ID = p_party_id

Line 6248: AND owner_table_name = 'HZ_PARTY_SITES'

6244:
6245: SELECT CONTACT_POINT_ID
6246: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6247: WHERE PRIMARY_FLAG = 'Y'
6248: AND owner_table_name = 'HZ_PARTY_SITES'
6249: AND owner_table_id = party_site_id
6250: AND PARTY_ID = p_party_id
6251: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
6252: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 6398: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')

6394: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6395: SELECT party_site_id
6396: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6397: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6398: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6399: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6400: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6402: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

Line 6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6397: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6398: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6399: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6400: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6402: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6403: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6404:
6405: I NUMBER;

Line 6402: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

6398: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6399: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6400: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6402: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6403: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6404:
6405: I NUMBER;
6406: J NUMBER:=1;

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

6399: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6400: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6402: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6403: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6404:
6405: I NUMBER;
6406: J NUMBER:=1;
6407: l_party_site_id NUMBER;