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_34 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 491: FROM HZ_PARTIES

487: END IF;
488: IF p_attribute = 'PARTY_NUMBER' THEN
489:
490: SELECT party_type INTO l_party_type
491: FROM HZ_PARTIES
492: WHERE party_id = p_record_id;
493: IF l_party_type = 'ORGANIZATION' THEN
494: SELECT PARTY_NUMBER INTO l_matched_value
495: FROM HZ_PARTIES

Line 495: FROM HZ_PARTIES

491: FROM HZ_PARTIES
492: WHERE party_id = p_record_id;
493: IF l_party_type = 'ORGANIZATION' THEN
494: SELECT PARTY_NUMBER INTO l_matched_value
495: FROM HZ_PARTIES
496: WHERE party_id = p_record_id
497: and rownum = 1;
498: ELSIF l_party_type = 'PERSON' THEN
499: SELECT PARTY_NUMBER INTO l_matched_value

Line 500: FROM HZ_PARTIES

496: WHERE party_id = p_record_id
497: and rownum = 1;
498: ELSIF l_party_type = 'PERSON' THEN
499: SELECT PARTY_NUMBER INTO l_matched_value
500: FROM HZ_PARTIES
501: WHERE party_id = p_record_id
502: and rownum = 1;
503: END IF;
504: RETURN l_matched_value;

Line 519: FROM HZ_PARTIES

515: END IF;
516: IF p_attribute = 'TAX_NAME' THEN
517:
518: SELECT party_type INTO l_party_type
519: FROM HZ_PARTIES
520: WHERE party_id = p_record_id;
521: IF l_party_type = 'ORGANIZATION' THEN
522: SELECT TAX_NAME INTO l_matched_value
523: FROM HZ_ORGANIZATION_PROFILES

Line 539: FROM HZ_PARTIES

535: END IF;
536: IF p_attribute = 'TAX_REFERENCE' THEN
537:
538: SELECT party_type INTO l_party_type
539: FROM HZ_PARTIES
540: WHERE party_id = p_record_id;
541: IF l_party_type = 'ORGANIZATION' THEN
542: SELECT TAX_REFERENCE INTO l_matched_value
543: FROM HZ_ORGANIZATION_PROFILES

Line 559: FROM HZ_PARTIES

555: END IF;
556: IF p_attribute = 'SIC_CODE' THEN
557:
558: SELECT party_type INTO l_party_type
559: FROM HZ_PARTIES
560: WHERE party_id = p_record_id;
561: IF l_party_type = 'ORGANIZATION' THEN
562: SELECT SIC_CODE INTO l_matched_value
563: FROM HZ_ORGANIZATION_PROFILES

Line 578: FROM HZ_PARTIES

574: END IF;
575: IF p_attribute = 'SIC_CODE_TYPE' THEN
576:
577: SELECT party_type INTO l_party_type
578: FROM HZ_PARTIES
579: WHERE party_id = p_record_id;
580: IF l_party_type = 'ORGANIZATION' THEN
581: SELECT SIC_CODE_TYPE INTO l_matched_value
582: FROM HZ_ORGANIZATION_PROFILES

Line 597: FROM HZ_PARTIES

593: END IF;
594: IF p_attribute = 'CATEGORY_CODE' THEN
595:
596: SELECT party_type INTO l_party_type
597: FROM HZ_PARTIES
598: WHERE party_id = p_record_id;
599: IF l_party_type = 'ORGANIZATION' THEN
600: SELECT CATEGORY_CODE INTO l_matched_value
601: FROM HZ_PARTIES

Line 601: FROM HZ_PARTIES

597: FROM HZ_PARTIES
598: WHERE party_id = p_record_id;
599: IF l_party_type = 'ORGANIZATION' THEN
600: SELECT CATEGORY_CODE INTO l_matched_value
601: FROM HZ_PARTIES
602: WHERE party_id = p_record_id
603: and rownum = 1;
604: ELSIF l_party_type = 'PERSON' THEN
605: SELECT CATEGORY_CODE INTO l_matched_value

Line 606: FROM HZ_PARTIES

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

Line 615: FROM HZ_PARTIES

611: END IF;
612: IF p_attribute = 'REFERENCE_USE_FLAG' THEN
613:
614: SELECT party_type INTO l_party_type
615: FROM HZ_PARTIES
616: WHERE party_id = p_record_id;
617: IF l_party_type = 'ORGANIZATION' THEN
618: SELECT REFERENCE_USE_FLAG INTO l_matched_value
619: FROM HZ_PARTIES

Line 619: FROM HZ_PARTIES

615: FROM HZ_PARTIES
616: WHERE party_id = p_record_id;
617: IF l_party_type = 'ORGANIZATION' THEN
618: SELECT REFERENCE_USE_FLAG INTO l_matched_value
619: FROM HZ_PARTIES
620: WHERE party_id = p_record_id
621: and rownum = 1;
622: ELSIF l_party_type = 'PERSON' THEN
623: SELECT REFERENCE_USE_FLAG INTO l_matched_value

Line 624: FROM HZ_PARTIES

620: WHERE party_id = p_record_id
621: and rownum = 1;
622: ELSIF l_party_type = 'PERSON' THEN
623: SELECT REFERENCE_USE_FLAG INTO l_matched_value
624: FROM HZ_PARTIES
625: WHERE party_id = p_record_id
626: and rownum = 1;
627: END IF;
628: RETURN l_matched_value;

Line 633: FROM HZ_PARTIES

629: END IF;
630: IF p_attribute = 'CORPORATION_CLASS' THEN
631:
632: SELECT party_type INTO l_party_type
633: FROM HZ_PARTIES
634: WHERE party_id = p_record_id;
635: IF l_party_type = 'ORGANIZATION' THEN
636: SELECT CORPORATION_CLASS INTO l_matched_value
637: FROM HZ_ORGANIZATION_PROFILES

Line 2543: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2539: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2540: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2541: AND r.object_id = p_party_id
2542: AND r.subject_id = stage.party_id
2543: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2544: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2545: AND r.relationship_id = oc.party_relationship_id
2546: AND oc.org_contact_id = stage.org_contact_id;
2547: END IF;

Line 2544: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2540: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2541: AND r.object_id = p_party_id
2542: AND r.subject_id = stage.party_id
2543: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2544: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2545: AND r.relationship_id = oc.party_relationship_id
2546: AND oc.org_contact_id = stage.org_contact_id;
2547: END IF;
2548: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN

Line 2962: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2958: AND( (l_search_merged ='Y' )
2959: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2960: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2961: AND r.subject_id = stage.party_id
2962: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2963: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2964: AND r.relationship_id = oc.party_relationship_id
2965: AND oc.org_contact_id = stage.org_contact_id;
2966: END IF;

Line 2963: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2959: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2960: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2961: AND r.subject_id = stage.party_id
2962: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2963: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2964: AND r.relationship_id = oc.party_relationship_id
2965: AND oc.org_contact_id = stage.org_contact_id;
2966: END IF;
2967: 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 5371: and c.owner_table_name = 'HZ_PARTIES'

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

Line 6863: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6859: AND party_id in (
6860: SELECT party_id
6861: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6862: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6863: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6864: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6865: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6866: and l_use_contact_info = 'Y'
6867: )

Line 6864: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6860: SELECT party_id
6861: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6862: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6863: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6864: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6865: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6866: and l_use_contact_info = 'Y'
6867: )
6868: AND ROWNUM<6

Line 6878: AND owner_table_name = 'HZ_PARTIES'

6874: FOR CONTACT_POINTS IN (
6875: SELECT CONTACT_POINT_ID
6876: FROM HZ_CONTACT_POINTS
6877: WHERE PRIMARY_FLAG = 'Y'
6878: AND owner_table_name = 'HZ_PARTIES'
6879: AND owner_table_id = p_party_id
6880:
6881: UNION
6882:

Line 6886: AND owner_table_name = 'HZ_PARTIES'

6882:
6883: SELECT CONTACT_POINT_ID
6884: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6885: WHERE PRIMARY_FLAG = 'Y'
6886: AND owner_table_name = 'HZ_PARTIES'
6887: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6888: AND HZ_RELATIONSHIPS.object_id = p_party_id
6889: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6890: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 6889: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6885: WHERE PRIMARY_FLAG = 'Y'
6886: AND owner_table_name = 'HZ_PARTIES'
6887: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6888: AND HZ_RELATIONSHIPS.object_id = p_party_id
6889: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6890: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6891: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6892: and l_use_contact_info = 'Y'
6893: AND ROWNUM<6

Line 6890: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6886: AND owner_table_name = 'HZ_PARTIES'
6887: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6888: AND HZ_RELATIONSHIPS.object_id = p_party_id
6889: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6890: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6891: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6892: and l_use_contact_info = 'Y'
6893: AND ROWNUM<6
6894: UNION

Line 6984: FROM HZ_PARTIES

6980: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6981: 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);
6982: END IF;
6983: SELECT PARTY_TYPE INTO l_party_type
6984: FROM HZ_PARTIES
6985: WHERE PARTY_ID = p_party_id;
6986:
6987: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6988: 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 6992: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')

6988: 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);
6989: END IF;
6990: IF l_party_type = 'ORGANIZATION' THEN
6991: SELECT
6992: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6993: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6994: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6995: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6996: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')

Line 6994: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')

6990: IF l_party_type = 'ORGANIZATION' THEN
6991: SELECT
6992: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6993: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6994: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6995: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6996: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6997: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6998: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')

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

6991: SELECT
6992: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6993: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6994: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6995: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6996: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6997: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6998: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6999: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')

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

6992: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6993: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6994: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6995: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6996: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6997: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6998: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6999: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
7000: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')

Line 7011: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

7007: ,x_party_search_rec.SIC_CODE
7008: ,x_party_search_rec.SIC_CODE_TYPE
7009: ,x_party_search_rec.TAX_NAME
7010: ,x_party_search_rec.TAX_REFERENCE
7011: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7012: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7013: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7014: AND HZ_PARTIES.party_id = p_party_id;
7015: ELSIF l_party_type = 'PERSON' THEN

Line 7012: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

7008: ,x_party_search_rec.SIC_CODE_TYPE
7009: ,x_party_search_rec.TAX_NAME
7010: ,x_party_search_rec.TAX_REFERENCE
7011: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7012: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7013: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7014: AND HZ_PARTIES.party_id = p_party_id;
7015: ELSIF l_party_type = 'PERSON' THEN
7016: SELECT

Line 7014: AND HZ_PARTIES.party_id = p_party_id;

7010: ,x_party_search_rec.TAX_REFERENCE
7011: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7012: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7013: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7014: AND HZ_PARTIES.party_id = p_party_id;
7015: ELSIF l_party_type = 'PERSON' THEN
7016: SELECT
7017: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7018: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')

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

7013: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7014: AND HZ_PARTIES.party_id = p_party_id;
7015: ELSIF l_party_type = 'PERSON' THEN
7016: SELECT
7017: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7018: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7019: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7020: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7021: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')

Line 7018: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')

7014: AND HZ_PARTIES.party_id = p_party_id;
7015: ELSIF l_party_type = 'PERSON' THEN
7016: SELECT
7017: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7018: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7019: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7020: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7021: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7022: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')

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

7015: ELSIF l_party_type = 'PERSON' THEN
7016: SELECT
7017: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7018: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7019: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7020: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7021: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7022: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7023: INTO

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

7016: SELECT
7017: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7018: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7019: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7020: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7021: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7022: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7023: INTO
7024: x_party_search_rec.CATEGORY_CODE

Line 7030: FROM HZ_PARTIES, HZ_PERSON_PROFILES

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

Line 7031: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

7027: ,x_party_search_rec.REFERENCE_USE_FLAG
7028: ,x_party_search_rec.TAX_NAME
7029: ,x_party_search_rec.TAX_REFERENCE
7030: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7031: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7032: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7033: AND HZ_PARTIES.party_id = p_party_id;
7034: END IF;
7035: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 7033: AND HZ_PARTIES.party_id = p_party_id;

7029: ,x_party_search_rec.TAX_REFERENCE
7030: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7031: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7032: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7033: AND HZ_PARTIES.party_id = p_party_id;
7034: END IF;
7035: x_party_search_rec.PARTY_TYPE := l_party_type;
7036: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7037: 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 7133: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

7129: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
7130: SELECT org_contact_id
7131: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
7132: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
7133: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7134: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7135: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7136: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7137: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

Line 7134: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

7130: SELECT org_contact_id
7131: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
7132: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
7133: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7134: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7135: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7136: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7137: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7138: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;