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_PARTIES

Line 134: || ' and exists ( SELECT 1 FROM HZ_PARTIES stage1 where stage1.party_id = r.subject_id'

130: p_person_restrict_sql := 'exists ( SELECT 1 from HZ_ORG_CONTACTS oc, hz_relationships r'
131: || ' where oc.org_contact_id = stage.org_contact_id and'
132: || ' r.relationship_id = oc.party_relationship_id'
133: || ' and r.subject_type = ''PERSON'' AND r.object_type = ''ORGANIZATION'' '
134: || ' and exists ( SELECT 1 FROM HZ_PARTIES stage1 where stage1.party_id = r.subject_id'
135: || ' and ' || p_restrict1_sql || ' ) )' ;
136: p_final_restrict_sql := '((stage.org_contact_id is null and ' || p_restrict_sql || ') or (stage.org_contact_id is not null and '
137: || p_person_restrict_sql || ' ))';
138: END IF;

Line 459: FROM HZ_PARTIES

455: IF p_entity = 'PARTY' THEN
456: IF p_attribute = 'TAX_NAME' THEN
457:
458: SELECT party_type INTO l_party_type
459: FROM HZ_PARTIES
460: WHERE party_id = p_record_id;
461: IF l_party_type = 'ORGANIZATION' THEN
462: SELECT TAX_NAME INTO l_matched_value
463: FROM HZ_ORGANIZATION_PROFILES

Line 479: FROM HZ_PARTIES

475: END IF;
476: IF p_attribute = 'TAX_REFERENCE' THEN
477:
478: SELECT party_type INTO l_party_type
479: FROM HZ_PARTIES
480: WHERE party_id = p_record_id;
481: IF l_party_type = 'ORGANIZATION' THEN
482: SELECT TAX_REFERENCE INTO l_matched_value
483: FROM HZ_ORGANIZATION_PROFILES

Line 499: FROM HZ_PARTIES

495: END IF;
496: IF p_attribute = 'PARTY_NAME' THEN
497:
498: SELECT party_type INTO l_party_type
499: FROM HZ_PARTIES
500: WHERE party_id = p_record_id;
501: IF l_party_type = 'ORGANIZATION' THEN
502: SELECT PARTY_NAME INTO l_matched_value
503: FROM HZ_PARTIES

Line 503: FROM HZ_PARTIES

499: FROM HZ_PARTIES
500: WHERE party_id = p_record_id;
501: IF l_party_type = 'ORGANIZATION' THEN
502: SELECT PARTY_NAME INTO l_matched_value
503: FROM HZ_PARTIES
504: WHERE party_id = p_record_id
505: and rownum = 1;
506: ELSIF l_party_type = 'PERSON' THEN
507: SELECT PARTY_NAME INTO l_matched_value

Line 508: FROM HZ_PARTIES

504: WHERE party_id = p_record_id
505: and rownum = 1;
506: ELSIF l_party_type = 'PERSON' THEN
507: SELECT PARTY_NAME INTO l_matched_value
508: FROM HZ_PARTIES
509: WHERE party_id = p_record_id
510: and rownum = 1;
511: END IF;
512: RETURN l_matched_value;

Line 527: FROM HZ_PARTIES

523: END IF;
524: IF p_attribute = 'JGZZ_FISCAL_CODE' THEN
525:
526: SELECT party_type INTO l_party_type
527: FROM HZ_PARTIES
528: WHERE party_id = p_record_id;
529: IF l_party_type = 'ORGANIZATION' THEN
530: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
531: FROM HZ_ORGANIZATION_PROFILES

Line 547: FROM HZ_PARTIES

543: END IF;
544: IF p_attribute = 'SIC_CODE' THEN
545:
546: SELECT party_type INTO l_party_type
547: FROM HZ_PARTIES
548: WHERE party_id = p_record_id;
549: IF l_party_type = 'ORGANIZATION' THEN
550: SELECT SIC_CODE INTO l_matched_value
551: FROM HZ_ORGANIZATION_PROFILES

Line 566: FROM HZ_PARTIES

562: END IF;
563: IF p_attribute = 'SIC_CODE_TYPE' THEN
564:
565: SELECT party_type INTO l_party_type
566: FROM HZ_PARTIES
567: WHERE party_id = p_record_id;
568: IF l_party_type = 'ORGANIZATION' THEN
569: SELECT SIC_CODE_TYPE INTO l_matched_value
570: FROM HZ_ORGANIZATION_PROFILES

Line 585: FROM HZ_PARTIES

581: END IF;
582: IF p_attribute = 'CATEGORY_CODE' THEN
583:
584: SELECT party_type INTO l_party_type
585: FROM HZ_PARTIES
586: WHERE party_id = p_record_id;
587: IF l_party_type = 'ORGANIZATION' THEN
588: SELECT CATEGORY_CODE INTO l_matched_value
589: FROM HZ_PARTIES

Line 589: FROM HZ_PARTIES

585: FROM HZ_PARTIES
586: WHERE party_id = p_record_id;
587: IF l_party_type = 'ORGANIZATION' THEN
588: SELECT CATEGORY_CODE INTO l_matched_value
589: FROM HZ_PARTIES
590: WHERE party_id = p_record_id
591: and rownum = 1;
592: ELSIF l_party_type = 'PERSON' THEN
593: SELECT CATEGORY_CODE INTO l_matched_value

Line 594: FROM HZ_PARTIES

590: WHERE party_id = p_record_id
591: and rownum = 1;
592: ELSIF l_party_type = 'PERSON' THEN
593: SELECT CATEGORY_CODE INTO l_matched_value
594: FROM HZ_PARTIES
595: WHERE party_id = p_record_id
596: and rownum = 1;
597: END IF;
598: RETURN l_matched_value;

Line 603: FROM HZ_PARTIES

599: END IF;
600: IF p_attribute = 'REFERENCE_USE_FLAG' THEN
601:
602: SELECT party_type INTO l_party_type
603: FROM HZ_PARTIES
604: WHERE party_id = p_record_id;
605: IF l_party_type = 'ORGANIZATION' THEN
606: SELECT REFERENCE_USE_FLAG INTO l_matched_value
607: FROM HZ_PARTIES

Line 607: FROM HZ_PARTIES

603: FROM HZ_PARTIES
604: WHERE party_id = p_record_id;
605: IF l_party_type = 'ORGANIZATION' THEN
606: SELECT REFERENCE_USE_FLAG INTO l_matched_value
607: FROM HZ_PARTIES
608: WHERE party_id = p_record_id
609: and rownum = 1;
610: ELSIF l_party_type = 'PERSON' THEN
611: SELECT REFERENCE_USE_FLAG INTO l_matched_value

Line 612: FROM HZ_PARTIES

608: WHERE party_id = p_record_id
609: and rownum = 1;
610: ELSIF l_party_type = 'PERSON' THEN
611: SELECT REFERENCE_USE_FLAG INTO l_matched_value
612: FROM HZ_PARTIES
613: WHERE party_id = p_record_id
614: and rownum = 1;
615: END IF;
616: RETURN l_matched_value;

Line 621: FROM HZ_PARTIES

617: END IF;
618: IF p_attribute = 'CORPORATION_CLASS' THEN
619:
620: SELECT party_type INTO l_party_type
621: FROM HZ_PARTIES
622: WHERE party_id = p_record_id;
623: IF l_party_type = 'ORGANIZATION' THEN
624: SELECT CORPORATION_CLASS INTO l_matched_value
625: FROM HZ_ORGANIZATION_PROFILES

Line 2554: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2550: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2551: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2552: AND r.object_id = p_party_id
2553: AND r.subject_id = stage.party_id
2554: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2555: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2556: AND r.relationship_id = oc.party_relationship_id
2557: AND oc.org_contact_id = stage.org_contact_id;
2558: END IF;

Line 2555: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2551: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2552: AND r.object_id = p_party_id
2553: AND r.subject_id = stage.party_id
2554: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2555: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2556: AND r.relationship_id = oc.party_relationship_id
2557: AND oc.org_contact_id = stage.org_contact_id;
2558: END IF;
2559: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN

Line 2973: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2969: AND( (l_search_merged ='Y' )
2970: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2971: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2972: AND r.subject_id = stage.party_id
2973: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2974: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2975: AND r.relationship_id = oc.party_relationship_id
2976: AND oc.org_contact_id = stage.org_contact_id;
2977: END IF;

Line 2974: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2970: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2971: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2972: AND r.subject_id = stage.party_id
2973: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2974: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2975: AND r.relationship_id = oc.party_relationship_id
2976: AND oc.org_contact_id = stage.org_contact_id;
2977: END IF;
2978: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN

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

4326: RETURN NUMBER IS
4327: l_party_type VARCHAR2(255);
4328: l_person_id NUMBER(15);
4329: BEGIN
4330: SELECT party_type INTO l_party_type from hz_parties where party_id = p_party_id;
4331: IF l_party_type = 'PERSON' THEN
4332: RETURN p_party_id;
4333: ELSIF p_contact_id IS NULL THEN
4334: RETURN NULL;

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

4333: ELSIF p_contact_id IS NULL THEN
4334: RETURN NULL;
4335: ELSE
4336: BEGIN
4337: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p
4338: WHERE oc.org_contact_id = p_contact_id
4339: AND r.relationship_id = oc.party_relationship_id
4340: AND r.object_id = p_party_id
4341: AND p.party_id = r.subject_id

Line 5368: and c.owner_table_name = 'HZ_PARTIES'

5364: l_match_idx NUMBER;
5365: cursor get_cpt_for_contact_id is select contact_point_id
5366: from hz_org_contacts a, hz_relationships b, hz_contact_points c
5367: where a.party_relationship_id = b.relationship_id
5368: and c.owner_table_name = 'HZ_PARTIES'
5369: and c.primary_flag='Y'
5370: and c.owner_table_id = b.party_id
5371: and b.directional_flag = 'F'
5372: and a.org_contact_id = p_org_contact_id;

Line 6836: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6832: AND party_id in (
6833: SELECT party_id
6834: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6835: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6836: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6837: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6838: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6839: and l_use_contact_info = 'Y'
6840: )

Line 6837: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6833: SELECT party_id
6834: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6835: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6836: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6837: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6838: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6839: and l_use_contact_info = 'Y'
6840: )
6841: AND ROWNUM<6

Line 6851: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6847: FOR CONTACTS IN (
6848: SELECT org_contact_id
6849: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6850: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6851: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6852: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6853: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6854: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6855: AND ROWNUM<6

Line 6852: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6848: SELECT org_contact_id
6849: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6850: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6851: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6852: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6853: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6854: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6855: AND ROWNUM<6
6856: ) LOOP

Line 6864: AND owner_table_name = 'HZ_PARTIES'

6860: FOR CONTACT_POINTS IN (
6861: SELECT CONTACT_POINT_ID
6862: FROM HZ_CONTACT_POINTS
6863: WHERE PRIMARY_FLAG = 'Y'
6864: AND owner_table_name = 'HZ_PARTIES'
6865: AND owner_table_id = p_party_id
6866:
6867: UNION
6868:

Line 6872: AND owner_table_name = 'HZ_PARTIES'

6868:
6869: SELECT CONTACT_POINT_ID
6870: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6871: WHERE PRIMARY_FLAG = 'Y'
6872: AND owner_table_name = 'HZ_PARTIES'
6873: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6874: AND HZ_RELATIONSHIPS.object_id = p_party_id
6875: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6876: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 6875: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6871: WHERE PRIMARY_FLAG = 'Y'
6872: AND owner_table_name = 'HZ_PARTIES'
6873: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6874: AND HZ_RELATIONSHIPS.object_id = p_party_id
6875: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6876: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6877: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6878: and l_use_contact_info = 'Y'
6879: AND ROWNUM<6

Line 6876: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6872: AND owner_table_name = 'HZ_PARTIES'
6873: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6874: AND HZ_RELATIONSHIPS.object_id = p_party_id
6875: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6876: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6877: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6878: and l_use_contact_info = 'Y'
6879: AND ROWNUM<6
6880: UNION

Line 6976: FROM HZ_PARTIES

6972: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6973: 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);
6974: END IF;
6975: SELECT PARTY_TYPE INTO l_party_type
6976: FROM HZ_PARTIES
6977: WHERE PARTY_ID = p_party_id;
6978:
6979: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6980: 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 6984: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')

6980: 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);
6981: END IF;
6982: IF l_party_type = 'ORGANIZATION' THEN
6983: SELECT
6984: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6985: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6987: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6988: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')

Line 6987: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')

6983: SELECT
6984: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6985: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6987: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6988: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6989: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6990: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6991: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')

Line 6988: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')

6984: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6985: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6987: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6988: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6989: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6990: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6991: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6992: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')

Line 6989: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')

6985: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6987: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6988: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6989: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6990: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6991: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6992: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
6993: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')

Line 7005: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

7001: ,x_party_search_rec.SIC_CODE
7002: ,x_party_search_rec.SIC_CODE_TYPE
7003: ,x_party_search_rec.TAX_NAME
7004: ,x_party_search_rec.TAX_REFERENCE
7005: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7006: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7007: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7008: AND HZ_PARTIES.party_id = p_party_id;
7009: ELSIF l_party_type = 'PERSON' THEN

Line 7006: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

7002: ,x_party_search_rec.SIC_CODE_TYPE
7003: ,x_party_search_rec.TAX_NAME
7004: ,x_party_search_rec.TAX_REFERENCE
7005: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7006: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7007: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7008: AND HZ_PARTIES.party_id = p_party_id;
7009: ELSIF l_party_type = 'PERSON' THEN
7010: SELECT

Line 7008: AND HZ_PARTIES.party_id = p_party_id;

7004: ,x_party_search_rec.TAX_REFERENCE
7005: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7006: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7007: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
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, '%',' ')

Line 7011: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')

7007: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
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, '%',' ')

Line 7013: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')

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, '%',' ')
7017: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')

Line 7014: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')

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, '%',' ')
7017: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7018: INTO

Line 7015: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')

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, '%',' ')
7017: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7018: INTO
7019: x_party_search_rec.CATEGORY_CODE

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 7029: AND HZ_PARTIES.party_id = p_party_id;

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
7033: 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 7129: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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'
7132: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7133: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

Line 7130: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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'
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;