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

4715: p_contact_ids HZ_PARTY_SEARCH.IDList;
4716: l_match_idx NUMBER;
4717: cursor get_cpts_for_party_sites is select contact_point_id
4718: from hz_contact_points
4719: where owner_table_name = 'HZ_PARTY_SITES'
4720: and primary_flag='Y'
4721: and owner_table_id = p_party_site_id;
4722: BEGIN
4723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6189: FROM HZ_PARTY_SITES

6185: l_party_id := p_party_id;
6186: FOR PARTY_SITES IN (
6187: SELECT party_site_id FROM (
6188: SELECT party_site_id,identifying_address_flag
6189: FROM HZ_PARTY_SITES
6190: WHERE party_id = p_party_id
6191: AND (status is null OR status = 'A')
6192: AND identifying_address_flag='Y'
6193: UNION

Line 6196: FROM HZ_PARTY_SITES

6192: AND identifying_address_flag='Y'
6193: UNION
6194:
6195: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6196: FROM HZ_PARTY_SITES
6197: WHERE party_id = p_party_id
6198: AND (status is null OR status = 'A')
6199: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
6200: AND ROWNUM<6

Line 6204: FROM HZ_PARTY_SITES

6200: AND ROWNUM<6
6201: UNION
6202:
6203: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6204: FROM HZ_PARTY_SITES
6205: WHERE (status is null OR status = 'A')
6206: AND party_id in (
6207: SELECT party_id
6208: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 6257: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6253: AND ROWNUM<6
6254: UNION
6255:
6256: SELECT CONTACT_POINT_ID
6257: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6258: WHERE PRIMARY_FLAG = 'Y'
6259: AND owner_table_name = 'HZ_PARTY_SITES'
6260: AND owner_table_id = party_site_id
6261: AND PARTY_ID = p_party_id

Line 6259: AND owner_table_name = 'HZ_PARTY_SITES'

6255:
6256: SELECT CONTACT_POINT_ID
6257: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6258: WHERE PRIMARY_FLAG = 'Y'
6259: AND owner_table_name = 'HZ_PARTY_SITES'
6260: AND owner_table_id = party_site_id
6261: AND PARTY_ID = p_party_id
6262: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
6263: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

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

6405: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6406: SELECT party_site_id
6407: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6408: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6409: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6410: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6411: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6412: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6413: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

Line 6412: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6408: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6409: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6410: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6411: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6412: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6413: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6414: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6415:
6416: I NUMBER;

Line 6413: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

6409: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6410: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6411: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6412: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6413: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6414: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6415:
6416: I NUMBER;
6417: J NUMBER:=1;

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

6410: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6411: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6412: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6413: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6414: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6415:
6416: I NUMBER;
6417: J NUMBER:=1;
6418: l_party_site_id NUMBER;