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_DUNNING_PVT dependencies on HZ_CONTACT_POINTS

Line 127: hz_contact_points point

123: rel.subject_id,
124: point.contact_point_id,
125: rel.relationship_type
126: from HZ_RELATIONSHIPS rel,
127: hz_contact_points point
128: where rel.object_id = P_PARTY_ID and
129: rel.relationship_type in ('DUNNING', 'COLLECTIONS') and
130: rel.status = 'A' and
131: rel.party_id = point.owner_table_ID and

Line 401: from hz_contact_points cont_point

397: 'BUSINESS', decode(cont_point.primary_flag, 'Y', 7, decode(cont_point.primary_by_purpose, 'Y', 8, 9)),
398: null, decode(cont_point.primary_flag, 'Y', 10, decode(cont_point.primary_by_purpose, 'Y', 11, 12))
399: ) Display_Order
400: ,cont_point.CONTACT_POINT_ID
401: from hz_contact_points cont_point
402: where
403: cont_point.owner_table_id = P_PARTY_ID and
404: cont_point.owner_table_name = 'HZ_PARTIES' and
405: cont_point.contact_point_type = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'PHONE', 'FAX', 'PHONE') and

Line 424: hz_contact_points cont_point

420: ,cont_point.CONTACT_POINT_ID
421: from
422: HZ_CUST_SITE_USES_ALL site_use,
423: HZ_CUST_ACCT_SITES_ALL acct_site,
424: hz_contact_points cont_point
425: where
426: site_use.site_use_id = P_SITE_USE_ID and
427: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and
428: cont_point.owner_table_id = acct_site.party_site_id and

Line 720: from hz_contact_points cont_point

716: 'BUSINESS', decode(cont_point.primary_flag, 'Y', 7, decode(cont_point.primary_by_purpose, 'Y', 8, 9)),
717: null, decode(cont_point.primary_flag, 'Y', 10, decode(cont_point.primary_by_purpose, 'Y', 11, 12))
718: ) Display_Order
719: ,cont_point.CONTACT_POINT_ID
720: from hz_contact_points cont_point
721: where
722: cont_point.owner_table_id = P_PARTY_ID and
723: cont_point.owner_table_name = 'HZ_PARTIES' and
724: cont_point.contact_point_type = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'PHONE', 'FAX', 'PHONE') and

Line 13033: FROM HZ_CONTACT_POINTS

13029: WHERE party_ID = in_party_ID;
13030: --
13031: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
13032: SELECT email_address
13033: FROM HZ_CONTACT_POINTS
13034: WHERE owner_table_ID = in_party_ID
13035: AND Contact_point_type = 'EMAIL'
13036: AND primary_flag = 'Y';
13037: --

Line 13468: || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,

13464: || p_template_id = fulfillment template
13465: || p_method = Fulfillment Type, currently only 'EMAIL' is supported
13466: || p_party_id = pk to hz_parties
13467: ||
13468: || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,
13469: || jtf_FM_query_mes
13470: || jtf_FM_query
13471: ||
13472: || Target Tables:

Line 13525: FROM HZ_CONTACT_POINTS

13521: WHERE party_ID = in_party_ID;
13522: --
13523: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
13524: SELECT email_address
13525: FROM HZ_CONTACT_POINTS
13526: WHERE owner_table_ID = in_party_ID
13527: AND Contact_point_type = 'EMAIL'
13528: AND primary_flag = 'Y';
13529: --

Line 14048: FROM HZ_CONTACT_POINTS

14044: WHERE party_ID = in_party_ID;
14045: --
14046: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
14047: SELECT email_address
14048: FROM HZ_CONTACT_POINTS
14049: WHERE owner_table_ID = in_party_ID
14050: AND Contact_point_type = 'EMAIL'
14051: AND primary_flag = 'Y';
14052:

Line 14057: from hz_contact_points c

14053: cursor c_get_contact_point(p_contact_point_id number, p_contact_type varchar2) is
14054: select decode(p_contact_type , 'EMAIL', c.email_address,
14055: 'PHONE', c.phone_country_code || c.phone_area_code || c.phone_number,
14056: 'FAX', c.phone_country_code || c.phone_area_code || c.phone_number, null)
14057: from hz_contact_points c
14058: where contact_point_id = p_contact_point_id;
14059:
14060: --Start for bug 9970642 gnramasa 4th Aug 10
14061: cursor c_get_resend_data(p_request_id number) is

Line 15494: FROM HZ_CONTACT_POINTS

15490: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER, IN_TYPE VARCHAR2) IS
15491: SELECT email_address,
15492: decode(primary_by_purpose, 'Y',1,2) purpose,
15493: decode(primary_flag, 'Y',1,2) primary
15494: FROM HZ_CONTACT_POINTS
15495: WHERE owner_table_ID = in_party_ID
15496: AND owner_table_name = 'HZ_PARTIES'
15497: --AND Contact_point_type = 'EMAIL'
15498: AND upper(Contact_point_type) = IN_TYPE

Line 15507: FROM HZ_CONTACT_POINTS

15503: --
15504: CURSOR C_GET_CONTACT_EMAIL2 (IN_PARTY_ID NUMBER, IN_TYPE VARCHAR2) IS
15505: SELECT email_address,
15506: decode(primary_flag, 'Y',1,2) primary
15507: FROM HZ_CONTACT_POINTS
15508: WHERE owner_table_ID = in_party_ID
15509: AND owner_table_name = 'HZ_PARTIES'
15510: --AND Contact_point_type = 'EMAIL'
15511: AND upper(Contact_point_type) = IN_TYPE

Line 15520: FROM HZ_CONTACT_POINTS

15516: CURSOR C_GET_CONTACT_FAX (IN_PARTY_ID NUMBER) IS
15517: SELECT phone_country_code || phone_area_code||phone_number faxnum,
15518: decode(primary_by_purpose, 'Y',1,2) purpose,
15519: decode(primary_flag, 'Y', 1, 2) primary
15520: FROM HZ_CONTACT_POINTS
15521: WHERE owner_table_ID = in_party_ID
15522: AND owner_table_name = 'HZ_PARTIES'
15523: AND upper(Contact_point_type) = 'PHONE'
15524: AND upper(phone_line_type) = 'FAX'

Line 15533: FROM HZ_CONTACT_POINTS

15529: --
15530: CURSOR C_GET_CONTACT_FAX2 (IN_PARTY_ID NUMBER) IS
15531: SELECT phone_country_code || phone_area_code||phone_number faxnum,
15532: decode(primary_flag, 'Y', 1, 2) primary
15533: FROM HZ_CONTACT_POINTS
15534: WHERE owner_table_ID = in_party_ID
15535: AND owner_table_name = 'HZ_PARTIES'
15536: AND upper(Contact_point_type) = 'PHONE'
15537: AND upper(phone_line_type) = 'FAX'