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_PARTIES

Line 132: point.owner_table_name = 'HZ_PARTIES' and

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
132: point.owner_table_name = 'HZ_PARTIES' and
133: upper(point.contact_point_type) = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'PHONE', 'FAX', 'PHONE') and
134: nvl(point.phone_line_type, 'EMAIL') = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'GEN', 'FAX', 'FAX') and
135: NVL(point.do_not_use_flag, 'N') = 'N' and
136: (point.status = 'A' OR point.status <> 'I')

Line 368: hz_parties party,

364: HZ_CUST_SITE_USES_ALL site_use,
365: HZ_CUST_ACCOUNT_ROLES acct_role,
366: HZ_ROLE_RESPONSIBILITY role_resp,
367: HZ_RELATIONSHIPS rel,
368: hz_parties party,
369: hz_parties sub_party
370: where
371: site_use.site_use_id = P_SITE_USE_ID and
372: acct_role.cust_acct_site_id = site_use.cust_acct_site_id and

Line 369: hz_parties sub_party

365: HZ_CUST_ACCOUNT_ROLES acct_role,
366: HZ_ROLE_RESPONSIBILITY role_resp,
367: HZ_RELATIONSHIPS rel,
368: hz_parties party,
369: hz_parties sub_party
370: where
371: site_use.site_use_id = P_SITE_USE_ID and
372: acct_role.cust_acct_site_id = site_use.cust_acct_site_id and
373: acct_role.status = 'A' and

Line 398: cont_point.owner_table_name = 'HZ_PARTIES' and

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
400: nvl(cont_point.phone_line_type, 'EMAIL') = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'GEN', 'FAX', 'FAX') and
401: NVL(cont_point.do_not_use_flag, 'N') = 'N' and
402: (cont_point.status = 'A' OR cont_point.status <> 'I')

Line 689: hz_parties party,

685: from
686: HZ_CUST_ACCOUNT_ROLES acct_role,
687: HZ_ROLE_RESPONSIBILITY role_resp,
688: HZ_RELATIONSHIPS rel,
689: hz_parties party,
690: hz_parties sub_party
691: where
692: acct_role.cust_account_id = P_CUST_ACCOUNT_ID and
693: acct_role.cust_acct_site_id is null and

Line 690: hz_parties sub_party

686: HZ_CUST_ACCOUNT_ROLES acct_role,
687: HZ_ROLE_RESPONSIBILITY role_resp,
688: HZ_RELATIONSHIPS rel,
689: hz_parties party,
690: hz_parties sub_party
691: where
692: acct_role.cust_account_id = P_CUST_ACCOUNT_ID and
693: acct_role.cust_acct_site_id is null and
694: acct_role.status = 'A' and

Line 719: cont_point.owner_table_name = 'HZ_PARTIES' and

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
721: nvl(cont_point.phone_line_type, 'EMAIL') = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'GEN', 'FAX', 'FAX') and
722: NVL(cont_point.do_not_use_flag, 'N') = 'N' and
723: (cont_point.status = 'A' OR cont_point.status <> 'I')

Line 5975: FROM HZ_PARTIES

5971: ORDER BY creation_date;
5972: --
5973: CURSOR C_GET_ORG_EMAIL (IN_PARTY_ID NUMBER) IS
5974: SELECT email_address
5975: FROM HZ_PARTIES
5976: WHERE party_ID = in_party_ID;
5977: --
5978: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
5979: SELECT email_address

Line 6409: || p_party_id = pk to hz_parties

6405: ||
6406: || Parameter: p_FULFILLMENT_BIND_TBL = name/value pairs for bind variables
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

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 6463: FROM HZ_PARTIES

6459: ORDER BY creation_date;
6460: --
6461: CURSOR C_GET_ORG_EMAIL (IN_PARTY_ID NUMBER) IS
6462: SELECT email_address
6463: FROM HZ_PARTIES
6464: WHERE party_ID = in_party_ID;
6465: --
6466: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
6467: SELECT email_address

Line 6985: FROM HZ_PARTIES

6981: WHERE j.user_id = in_user_id;
6982: --
6983: CURSOR C_GET_ORG_EMAIL (IN_PARTY_ID NUMBER) IS
6984: SELECT email_address
6985: FROM HZ_PARTIES
6986: WHERE party_ID = in_party_ID;
6987: --
6988: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
6989: SELECT email_address

Line 7670: FROM HZ_PARTIES

7666: IS
7667: --
7668: CURSOR C_GET_ORG_EMAIL (IN_PARTY_ID NUMBER) IS
7669: SELECT email_address
7670: FROM HZ_PARTIES
7671: WHERE party_ID = in_party_ID;
7672: --
7673: CURSOR C_GET_DUNNING_ORG (IN_PARTY_ID NUMBER) IS
7674: SELECT party_id

Line 7682: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r

7678: AND status = 'A';
7679: --
7680: CURSOR C_GET_ORG_PARTY (IN_REL_PARTY_ID NUMBER) IS
7681: SELECT r.object_id --org party id
7682: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r
7683: WHERE r.party_id = in_rel_party_ID
7684: AND p.party_id = r.object_id
7685: AND p.party_type = 'ORGANIZATION';
7686: --

Line 7689: FROM HZ_PARTIES p

7685: AND p.party_type = 'ORGANIZATION';
7686: --
7687: CURSOR C_GET_PARTY_TYPE (IN_PARTY_ID NUMBER) IS
7688: SELECT p.party_type
7689: FROM HZ_PARTIES p
7690: WHERE p.party_id = in_party_ID;
7691: --
7692: l_api_name CONSTANT VARCHAR2(30) := 'GetContactInfo';
7693: l_api_version NUMBER := 1.0;

Line 7989: AND owner_table_name = 'HZ_PARTIES'

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
7992: AND Contact_point_purpose = 'DUNNING'
7993: AND NVL(do_not_use_flag, 'N') = 'N'

Line 8002: AND owner_table_name = 'HZ_PARTIES'

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
8005: AND NVL(do_not_use_flag, 'N') = 'N'
8006: AND (status = 'A' OR status <> 'I')

Line 8015: AND owner_table_name = 'HZ_PARTIES'

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'
8018: AND Contact_point_purpose = 'DUNNING'
8019: AND NVL(do_not_use_flag, 'N') = 'N'

Line 8028: AND owner_table_name = 'HZ_PARTIES'

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'
8031: AND NVL(do_not_use_flag, 'N') = 'N'
8032: AND (status = 'A' OR status <> 'I')

Line 9011: HZ_PARTIES h,

9007: ar.trx_number,
9008: ar.payment_schedule_id,
9009: h.party_name
9010: FROM IEX_DELINQUENCIES d,
9011: HZ_PARTIES h,
9012: HZ_CUST_ACCOUNTS a,
9013: AR_PAYMENT_SCHEDULES ar
9014: WHERE d.delinquency_ID = in_del_ID
9015: AND h.party_id = d.party_cust_id

Line 9027: HZ_PARTIES h,

9023: a.account_number,
9024: d.customer_site_use_id,
9025: h.party_name
9026: FROM IEX_DELINQUENCIES d,
9027: HZ_PARTIES h,
9028: HZ_CUST_ACCOUNTS a
9029: WHERE d.customer_site_use_id = in_SITE_ID
9030: AND h.party_id = d.party_cust_id
9031: AND d.cust_account_id = a.cust_account_id;

Line 9039: HZ_PARTIES h,

9035: d.cust_account_id,
9036: a.account_number,
9037: h.party_name
9038: FROM IEX_DELINQUENCIES d,
9039: HZ_PARTIES h,
9040: HZ_CUST_ACCOUNTS a
9041: WHERE d.cust_account_ID = in_ACCT_ID
9042: AND h.party_id = d.party_cust_id
9043: AND d.cust_account_id = a.cust_account_id;

Line 9049: HZ_PARTIES h

9045: CURSOR C_GET_CUSTOMER (IN_PARTY_ID NUMBER) IS
9046: SELECT d.party_cust_id,
9047: h.party_name
9048: FROM IEX_DELINQUENCIES d,
9049: HZ_PARTIES h
9050: WHERE d.party_cust_id = in_party_id
9051: AND h.party_id = d.party_cust_id;
9052: --
9053: l_delinquency_id NUMBER;