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_42 dependencies on HZ_PERSON_PROFILES

Line 469: FROM HZ_PERSON_PROFILES

465: and effective_end_date is null
466: and rownum = 1;
467: ELSIF l_party_type = 'PERSON' THEN
468: SELECT TAX_NAME INTO l_matched_value
469: FROM HZ_PERSON_PROFILES
470: WHERE party_id = p_record_id
471: and effective_end_date is null
472: and rownum = 1;
473: END IF;

Line 489: FROM HZ_PERSON_PROFILES

485: and effective_end_date is null
486: and rownum = 1;
487: ELSIF l_party_type = 'PERSON' THEN
488: SELECT TAX_REFERENCE INTO l_matched_value
489: FROM HZ_PERSON_PROFILES
490: WHERE party_id = p_record_id
491: and effective_end_date is null
492: and rownum = 1;
493: END IF;

Line 537: FROM HZ_PERSON_PROFILES

533: and effective_end_date is null
534: and rownum = 1;
535: ELSIF l_party_type = 'PERSON' THEN
536: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
537: FROM HZ_PERSON_PROFILES
538: WHERE party_id = p_record_id
539: and effective_end_date is null
540: and rownum = 1;
541: END IF;

Line 7012: ,translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')

7008: AND HZ_PARTIES.party_id = p_party_id;
7009: ELSIF l_party_type = 'PERSON' THEN
7010: SELECT
7011: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7012: ,translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
7013: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
7014: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7015: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7016: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')

Line 7016: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')

7012: ,translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
7013: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
7014: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7015: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7016: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7017: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7018: INTO
7019: x_party_search_rec.CATEGORY_CODE
7020: ,x_party_search_rec.JGZZ_FISCAL_CODE

Line 7017: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')

7013: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
7014: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7015: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7016: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7017: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7018: INTO
7019: x_party_search_rec.CATEGORY_CODE
7020: ,x_party_search_rec.JGZZ_FISCAL_CODE
7021: ,x_party_search_rec.PARTY_NAME

Line 7026: FROM HZ_PARTIES, HZ_PERSON_PROFILES

7022: ,x_party_search_rec.PARTY_TYPE
7023: ,x_party_search_rec.REFERENCE_USE_FLAG
7024: ,x_party_search_rec.TAX_NAME
7025: ,x_party_search_rec.TAX_REFERENCE
7026: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7027: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7028: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7029: AND HZ_PARTIES.party_id = p_party_id;
7030: END IF;

Line 7027: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

7023: ,x_party_search_rec.REFERENCE_USE_FLAG
7024: ,x_party_search_rec.TAX_NAME
7025: ,x_party_search_rec.TAX_REFERENCE
7026: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7027: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7028: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7029: AND HZ_PARTIES.party_id = p_party_id;
7030: END IF;
7031: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 7028: AND HZ_PERSON_PROFILES.effective_end_date is NULL

7024: ,x_party_search_rec.TAX_NAME
7025: ,x_party_search_rec.TAX_REFERENCE
7026: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7027: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7028: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7029: AND HZ_PARTIES.party_id = p_party_id;
7030: END IF;
7031: x_party_search_rec.PARTY_TYPE := l_party_type;
7032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 7127: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

7123: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
7124: ) IS
7125: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
7126: SELECT org_contact_id
7127: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
7128: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
7129: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7130: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7131: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 7133: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

7129: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7130: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7131: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7132: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7133: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7134: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
7135:
7136: I NUMBER;
7137: l_org_contact_id NUMBER;

Line 7134: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

7130: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7131: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7132: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7133: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7134: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
7135:
7136: I NUMBER;
7137: l_org_contact_id NUMBER;
7138: J NUMBER:=1;