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.IEX_CUST_OVERVIEW_PVT dependencies on HZ_PARTIES

Line 38: FROM hz_parties

34: l_bkr_count number; -- Added for bug#7830847 by PNAVEENK on 27-1-2009
35: -- Get Tax Code
36: CURSOR c_party_info IS
37: SELECT jgzz_fiscal_code
38: FROM hz_parties
39: WHERE party_id = p_party_id;
40:
41: -- Collections score
42: CURSOR c_collections_score IS

Line 1751: WHERE owner_table_name = 'HZ_PARTIES'

1747: contact_point_id, phone_country_code, phone_area_code, phone_number, phone_extension,
1748: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('PHONE_LINE_TYPE', phone_line_type) phone_line_type_meaning,
1749: email_address, contact_point_type
1750: FROM hz_contact_points
1751: WHERE owner_table_name = 'HZ_PARTIES'
1752: AND owner_table_id = x_party_id
1753: AND ((contact_point_type = 'EMAIL') OR
1754: (contact_point_type = 'PHONE' AND phone_line_type NOT IN ('PAGER', 'FAX')))
1755: AND NVL(do_not_use_flag, 'N') = 'N'

Line 1899: FROM hz_parties

1895: l_bkr_count number; -- Added for bug#7590635 by PNAVEENK on 6-2-2009
1896: -- Get Tax Code
1897: CURSOR c_party_info IS
1898: SELECT jgzz_fiscal_code
1899: FROM hz_parties
1900: WHERE party_id = p_party_id;
1901:
1902: -- Collections score
1903: CURSOR c_collections_score IS

Line 2753: FROM hz_parties

2749: WHERE party_relationship_id = p_party_relationship_id;
2750:
2751: CURSOR c_party(p_party_id NUMBER) IS
2752: SELECT object_version_number
2753: FROM hz_parties
2754: WHERE party_id = p_party_id;
2755:
2756: CURSOR c_contact_point(p_contact_point_id NUMBER) is
2757: SELECT *

Line 2893: l_party_rel_create_rec.subject_table_name := 'HZ_PARTIES';

2889: l_party_rel_create_rec.status := 'A';
2890: l_party_rel_create_rec.start_date := SYSDATE;
2891: l_party_rel_create_rec.relationship_type := p_type;
2892: l_party_rel_create_rec.relationship_code := p_type;
2893: l_party_rel_create_rec.subject_table_name := 'HZ_PARTIES';
2894: l_party_rel_create_rec.object_table_name := 'HZ_PARTIES';
2895: l_party_rel_create_rec.subject_type := 'ORGANIZATION';
2896: l_party_rel_create_rec.object_type := 'PERSON';
2897: --Begin-fix bug#4604755-JYPARK-09/12/2005-When create 'Collections'/'Dunning' default contact in Collections,

Line 2894: l_party_rel_create_rec.object_table_name := 'HZ_PARTIES';

2890: l_party_rel_create_rec.start_date := SYSDATE;
2891: l_party_rel_create_rec.relationship_type := p_type;
2892: l_party_rel_create_rec.relationship_code := p_type;
2893: l_party_rel_create_rec.subject_table_name := 'HZ_PARTIES';
2894: l_party_rel_create_rec.object_table_name := 'HZ_PARTIES';
2895: l_party_rel_create_rec.subject_type := 'ORGANIZATION';
2896: l_party_rel_create_rec.object_type := 'PERSON';
2897: --Begin-fix bug#4604755-JYPARK-09/12/2005-When create 'Collections'/'Dunning' default contact in Collections,
2898: --set CREATED_BY_MODULE column value depending on lookup HZ_CREATED_BY_MODULES

Line 2913: SELECT hz_parties_s.nextval

2909:
2910: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'));
2911:
2912: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
2913: SELECT hz_parties_s.nextval
2914: INTO l_party_rel_create_rec.party_rec.party_number
2915: FROM dual;
2916: ELSE
2917: l_party_rel_create_rec.party_rec.party_number := '';