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_50 dependencies on HZ_PARTIES

Line 369: FROM HZ_PARTIES

365: IF p_entity = 'PARTY' THEN
366: IF p_attribute = 'DUNS_NUMBER_C' THEN
367:
368: SELECT party_type INTO l_party_type
369: FROM HZ_PARTIES
370: WHERE party_id = p_record_id;
371: IF l_party_type = 'ORGANIZATION' THEN
372: SELECT DUNS_NUMBER_C INTO l_matched_value
373: FROM HZ_ORGANIZATION_PROFILES

Line 388: FROM HZ_PARTIES

384: END IF;
385: IF p_attribute = 'PARTY_NAME' THEN
386:
387: SELECT party_type INTO l_party_type
388: FROM HZ_PARTIES
389: WHERE party_id = p_record_id;
390: IF l_party_type = 'ORGANIZATION' THEN
391: SELECT PARTY_NAME INTO l_matched_value
392: FROM HZ_PARTIES

Line 392: FROM HZ_PARTIES

388: FROM HZ_PARTIES
389: WHERE party_id = p_record_id;
390: IF l_party_type = 'ORGANIZATION' THEN
391: SELECT PARTY_NAME INTO l_matched_value
392: FROM HZ_PARTIES
393: WHERE party_id = p_record_id
394: and rownum = 1;
395: ELSIF l_party_type = 'PERSON' THEN
396: SELECT PARTY_NAME INTO l_matched_value

Line 397: FROM HZ_PARTIES

393: WHERE party_id = p_record_id
394: and rownum = 1;
395: ELSIF l_party_type = 'PERSON' THEN
396: SELECT PARTY_NAME INTO l_matched_value
397: FROM HZ_PARTIES
398: WHERE party_id = p_record_id
399: and rownum = 1;
400: END IF;
401: RETURN l_matched_value;

Line 406: FROM HZ_PARTIES

402: END IF;
403: IF p_attribute = 'JGZZ_FISCAL_CODE' THEN
404:
405: SELECT party_type INTO l_party_type
406: FROM HZ_PARTIES
407: WHERE party_id = p_record_id;
408: IF l_party_type = 'ORGANIZATION' THEN
409: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
410: FROM HZ_ORGANIZATION_PROFILES

Line 482: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

478: SELECT HZ_ORG_CONTACTS.JOB_TITLE
479: INTO l_matched_value
480: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
481: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
482: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
483: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
484: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
485: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
486: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

Line 483: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

479: INTO l_matched_value
480: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
481: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
482: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
483: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
484: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
485: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
486: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
487: AND HZ_PERSON_PROFILES.effective_end_date IS NULL and rownum=1;

Line 2330: SELECT party_type INTO l_party_type from hz_parties where party_id = p_party_id;

2326: RETURN NUMBER IS
2327: l_party_type VARCHAR2(255);
2328: l_person_id NUMBER(15);
2329: BEGIN
2330: SELECT party_type INTO l_party_type from hz_parties where party_id = p_party_id;
2331: IF l_party_type = 'PERSON' THEN
2332: RETURN p_party_id;
2333: ELSIF p_contact_id IS NULL THEN
2334: RETURN NULL;

Line 2337: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p

2333: ELSIF p_contact_id IS NULL THEN
2334: RETURN NULL;
2335: ELSE
2336: BEGIN
2337: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p
2338: WHERE oc.org_contact_id = p_contact_id
2339: AND r.relationship_id = oc.party_relationship_id
2340: AND r.object_id = p_party_id
2341: AND p.party_id = r.subject_id

Line 3136: and c.owner_table_name = 'HZ_PARTIES'

3132: l_match_idx NUMBER;
3133: cursor get_cpt_for_contact_id is select contact_point_id
3134: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3135: where a.party_relationship_id = b.relationship_id
3136: and c.owner_table_name = 'HZ_PARTIES'
3137: and c.primary_flag='Y'
3138: and c.owner_table_id = b.party_id
3139: and b.directional_flag = 'F'
3140: and a.org_contact_id = p_org_contact_id;

Line 4522: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4518: AND party_id in (
4519: SELECT party_id
4520: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4521: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4522: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4523: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4524: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4525: and l_use_contact_info = 'Y'
4526: )

Line 4523: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4519: SELECT party_id
4520: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4521: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4522: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4523: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4524: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4525: and l_use_contact_info = 'Y'
4526: )
4527: ) order by identifying_address_flag desc

Line 4536: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4532: FOR CONTACTS IN (
4533: SELECT org_contact_id
4534: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4535: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4536: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4537: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4538: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4539: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4540: ) LOOP

Line 4537: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4533: SELECT org_contact_id
4534: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4535: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4536: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4537: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4538: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4539: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4540: ) LOOP
4541: l_contact_ids(ct) := CONTACTS.org_contact_id;

Line 4548: AND owner_table_name = 'HZ_PARTIES'

4544: FOR CONTACT_POINTS IN (
4545: SELECT CONTACT_POINT_ID
4546: FROM HZ_CONTACT_POINTS
4547: WHERE PRIMARY_FLAG = 'Y'
4548: AND owner_table_name = 'HZ_PARTIES'
4549: AND owner_table_id = p_party_id
4550:
4551: UNION
4552:

Line 4556: AND owner_table_name = 'HZ_PARTIES'

4552:
4553: SELECT CONTACT_POINT_ID
4554: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4555: WHERE PRIMARY_FLAG = 'Y'
4556: AND owner_table_name = 'HZ_PARTIES'
4557: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4558: AND HZ_RELATIONSHIPS.object_id = p_party_id
4559: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4560: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 4559: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4555: WHERE PRIMARY_FLAG = 'Y'
4556: AND owner_table_name = 'HZ_PARTIES'
4557: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4558: AND HZ_RELATIONSHIPS.object_id = p_party_id
4559: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4560: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4561: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4562: and l_use_contact_info = 'Y'
4563: UNION

Line 4560: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4556: AND owner_table_name = 'HZ_PARTIES'
4557: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4558: AND HZ_RELATIONSHIPS.object_id = p_party_id
4559: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4560: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4561: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4562: and l_use_contact_info = 'Y'
4563: UNION
4564:

Line 4659: FROM HZ_PARTIES

4655: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4656: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - get_party_rec',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4657: END IF;
4658: SELECT PARTY_TYPE INTO l_party_type
4659: FROM HZ_PARTIES
4660: WHERE PARTY_ID = p_party_id;
4661:
4662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4663: hz_utility_v2pub.debug(p_message=>'l_party_type is - '||l_party_type,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4669: ,HZ_PARTIES.PARTY_NAME

4665: IF l_party_type = 'ORGANIZATION' THEN
4666: SELECT
4667: HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C
4668: ,HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE
4669: ,HZ_PARTIES.PARTY_NAME
4670: ,HZ_PARTIES.PARTY_TYPE
4671: ,HZ_ORGANIZATION_PROFILES.SIC_CODE
4672: INTO
4673: x_party_search_rec.DUNS_NUMBER_C

Line 4670: ,HZ_PARTIES.PARTY_TYPE

4666: SELECT
4667: HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C
4668: ,HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE
4669: ,HZ_PARTIES.PARTY_NAME
4670: ,HZ_PARTIES.PARTY_TYPE
4671: ,HZ_ORGANIZATION_PROFILES.SIC_CODE
4672: INTO
4673: x_party_search_rec.DUNS_NUMBER_C
4674: ,x_party_search_rec.JGZZ_FISCAL_CODE

Line 4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

4674: ,x_party_search_rec.JGZZ_FISCAL_CODE
4675: ,x_party_search_rec.PARTY_NAME
4676: ,x_party_search_rec.PARTY_TYPE
4677: ,x_party_search_rec.SIC_CODE
4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4681: AND HZ_PARTIES.party_id = p_party_id;
4682: ELSIF l_party_type = 'PERSON' THEN

Line 4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

4675: ,x_party_search_rec.PARTY_NAME
4676: ,x_party_search_rec.PARTY_TYPE
4677: ,x_party_search_rec.SIC_CODE
4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4681: AND HZ_PARTIES.party_id = p_party_id;
4682: ELSIF l_party_type = 'PERSON' THEN
4683: SELECT

Line 4681: AND HZ_PARTIES.party_id = p_party_id;

4677: ,x_party_search_rec.SIC_CODE
4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4681: AND HZ_PARTIES.party_id = p_party_id;
4682: ELSIF l_party_type = 'PERSON' THEN
4683: SELECT
4684: HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE
4685: ,HZ_PARTIES.PARTY_NAME

Line 4685: ,HZ_PARTIES.PARTY_NAME

4681: AND HZ_PARTIES.party_id = p_party_id;
4682: ELSIF l_party_type = 'PERSON' THEN
4683: SELECT
4684: HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE
4685: ,HZ_PARTIES.PARTY_NAME
4686: ,HZ_PARTIES.PARTY_TYPE
4687: INTO
4688: x_party_search_rec.JGZZ_FISCAL_CODE
4689: ,x_party_search_rec.PARTY_NAME

Line 4686: ,HZ_PARTIES.PARTY_TYPE

4682: ELSIF l_party_type = 'PERSON' THEN
4683: SELECT
4684: HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE
4685: ,HZ_PARTIES.PARTY_NAME
4686: ,HZ_PARTIES.PARTY_TYPE
4687: INTO
4688: x_party_search_rec.JGZZ_FISCAL_CODE
4689: ,x_party_search_rec.PARTY_NAME
4690: ,x_party_search_rec.PARTY_TYPE

Line 4691: FROM HZ_PARTIES, HZ_PERSON_PROFILES

4687: INTO
4688: x_party_search_rec.JGZZ_FISCAL_CODE
4689: ,x_party_search_rec.PARTY_NAME
4690: ,x_party_search_rec.PARTY_TYPE
4691: FROM HZ_PARTIES, HZ_PERSON_PROFILES
4692: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
4693: AND HZ_PERSON_PROFILES.effective_end_date is NULL
4694: AND HZ_PARTIES.party_id = p_party_id;
4695: END IF;

Line 4692: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

4688: x_party_search_rec.JGZZ_FISCAL_CODE
4689: ,x_party_search_rec.PARTY_NAME
4690: ,x_party_search_rec.PARTY_TYPE
4691: FROM HZ_PARTIES, HZ_PERSON_PROFILES
4692: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
4693: AND HZ_PERSON_PROFILES.effective_end_date is NULL
4694: AND HZ_PARTIES.party_id = p_party_id;
4695: END IF;
4696: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 4694: AND HZ_PARTIES.party_id = p_party_id;

4690: ,x_party_search_rec.PARTY_TYPE
4691: FROM HZ_PARTIES, HZ_PERSON_PROFILES
4692: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
4693: AND HZ_PERSON_PROFILES.effective_end_date is NULL
4694: AND HZ_PARTIES.party_id = p_party_id;
4695: END IF;
4696: x_party_search_rec.PARTY_TYPE := l_party_type;
4697: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4698: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - generate_custom_code',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 4787: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

4783: SELECT org_contact_id
4784: ,HZ_ORG_CONTACTS.JOB_TITLE
4785: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
4786: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4787: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4788: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4789: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4790: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4791: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

Line 4788: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

4784: ,HZ_ORG_CONTACTS.JOB_TITLE
4785: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
4786: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4787: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4788: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4789: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4790: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4791: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
4792: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;