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 395: from hz_contact_points cont_point

391: 'BUSINESS', decode(cont_point.primary_flag, 'Y', 7, decode(cont_point.primary_by_purpose, 'Y', 8, 9)),
392: null, decode(cont_point.primary_flag, 'Y', 10, decode(cont_point.primary_by_purpose, 'Y', 11, 12))
393: ) Display_Order
394: ,cont_point.CONTACT_POINT_ID
395: from hz_contact_points cont_point
396: where
397: cont_point.owner_table_id = P_PARTY_ID and
398: cont_point.owner_table_name = 'HZ_PARTIES' and
399: cont_point.contact_point_type = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'PHONE', 'FAX', 'PHONE') and

Line 418: hz_contact_points cont_point

414: ,cont_point.CONTACT_POINT_ID
415: from
416: HZ_CUST_SITE_USES_ALL site_use,
417: HZ_CUST_ACCT_SITES_ALL acct_site,
418: hz_contact_points cont_point
419: where
420: site_use.site_use_id = P_SITE_USE_ID and
421: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and
422: cont_point.owner_table_id = acct_site.party_site_id and

Line 716: from hz_contact_points cont_point

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

Line 5980: FROM HZ_CONTACT_POINTS

5976: WHERE party_ID = in_party_ID;
5977: --
5978: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
5979: SELECT email_address
5980: FROM HZ_CONTACT_POINTS
5981: WHERE owner_table_ID = in_party_ID
5982: AND Contact_point_type = 'EMAIL'
5983: AND primary_flag = 'Y';
5984: --

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

6407: || p_template_id = fulfillment template
6408: || p_method = Fulfillment Type, currently only 'EMAIL' is supported
6409: || p_party_id = pk to hz_parties
6410: ||
6411: || Source Tables: JTF_FM_TEMPLATE_CONTENTS, HZ_PARTIES, HZ_CONTACT_POINTS,
6412: || jtf_FM_query_mes
6413: || jtf_FM_query
6414: ||
6415: || Target Tables:

Line 6468: FROM HZ_CONTACT_POINTS

6464: WHERE party_ID = in_party_ID;
6465: --
6466: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
6467: SELECT email_address
6468: FROM HZ_CONTACT_POINTS
6469: WHERE owner_table_ID = in_party_ID
6470: AND Contact_point_type = 'EMAIL'
6471: AND primary_flag = 'Y';
6472: --

Line 6990: FROM HZ_CONTACT_POINTS

6986: WHERE party_ID = in_party_ID;
6987: --
6988: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
6989: SELECT email_address
6990: FROM HZ_CONTACT_POINTS
6991: WHERE owner_table_ID = in_party_ID
6992: AND Contact_point_type = 'EMAIL'
6993: AND primary_flag = 'Y';
6994:

Line 6999: from hz_contact_points c

6995: cursor c_get_contact_point(p_contact_point_id number, p_contact_type varchar2) is
6996: select decode(p_contact_type , 'EMAIL', c.email_address,
6997: 'PHONE', c.phone_country_code || c.phone_area_code || c.phone_number,
6998: 'FAX', c.phone_country_code || c.phone_area_code || c.phone_number, null)
6999: from hz_contact_points c
7000: where contact_point_id = p_contact_point_id;
7001:
7002: cursor c_get_resend_data(p_request_id number) is
7003: select QUERY_TEMP_ID, DESTINATION

Line 7987: FROM HZ_CONTACT_POINTS

7983: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER, IN_TYPE VARCHAR2) IS
7984: SELECT email_address,
7985: decode(primary_by_purpose, 'Y',1,2) purpose,
7986: decode(primary_flag, 'Y',1,2) primary
7987: FROM HZ_CONTACT_POINTS
7988: WHERE owner_table_ID = in_party_ID
7989: AND owner_table_name = 'HZ_PARTIES'
7990: --AND Contact_point_type = 'EMAIL'
7991: AND upper(Contact_point_type) = IN_TYPE

Line 8000: FROM HZ_CONTACT_POINTS

7996: --
7997: CURSOR C_GET_CONTACT_EMAIL2 (IN_PARTY_ID NUMBER, IN_TYPE VARCHAR2) IS
7998: SELECT email_address,
7999: decode(primary_flag, 'Y',1,2) primary
8000: FROM HZ_CONTACT_POINTS
8001: WHERE owner_table_ID = in_party_ID
8002: AND owner_table_name = 'HZ_PARTIES'
8003: --AND Contact_point_type = 'EMAIL'
8004: AND upper(Contact_point_type) = IN_TYPE

Line 8013: FROM HZ_CONTACT_POINTS

8009: CURSOR C_GET_CONTACT_FAX (IN_PARTY_ID NUMBER) IS
8010: SELECT phone_country_code || phone_area_code||phone_number faxnum,
8011: decode(primary_by_purpose, 'Y',1,2) purpose,
8012: decode(primary_flag, 'Y', 1, 2) primary
8013: FROM HZ_CONTACT_POINTS
8014: WHERE owner_table_ID = in_party_ID
8015: AND owner_table_name = 'HZ_PARTIES'
8016: AND upper(Contact_point_type) = 'PHONE'
8017: AND upper(phone_line_type) = 'FAX'

Line 8026: FROM HZ_CONTACT_POINTS

8022: --
8023: CURSOR C_GET_CONTACT_FAX2 (IN_PARTY_ID NUMBER) IS
8024: SELECT phone_country_code || phone_area_code||phone_number faxnum,
8025: decode(primary_flag, 'Y', 1, 2) primary
8026: FROM HZ_CONTACT_POINTS
8027: WHERE owner_table_ID = in_party_ID
8028: AND owner_table_name = 'HZ_PARTIES'
8029: AND upper(Contact_point_type) = 'PHONE'
8030: AND upper(phone_line_type) = 'FAX'