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 374: hz_parties party,

370: HZ_CUST_SITE_USES_ALL site_use,
371: HZ_CUST_ACCOUNT_ROLES acct_role,
372: HZ_ROLE_RESPONSIBILITY role_resp,
373: HZ_RELATIONSHIPS rel,
374: hz_parties party,
375: hz_parties sub_party
376: where
377: site_use.site_use_id = P_SITE_USE_ID and
378: acct_role.cust_acct_site_id = site_use.cust_acct_site_id and

Line 375: hz_parties sub_party

371: HZ_CUST_ACCOUNT_ROLES acct_role,
372: HZ_ROLE_RESPONSIBILITY role_resp,
373: HZ_RELATIONSHIPS rel,
374: hz_parties party,
375: hz_parties sub_party
376: where
377: site_use.site_use_id = P_SITE_USE_ID and
378: acct_role.cust_acct_site_id = site_use.cust_acct_site_id and
379: acct_role.status = 'A' and

Line 404: cont_point.owner_table_name = 'HZ_PARTIES' and

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

Line 693: hz_parties party,

689: from
690: HZ_CUST_ACCOUNT_ROLES acct_role,
691: HZ_ROLE_RESPONSIBILITY role_resp,
692: HZ_RELATIONSHIPS rel,
693: hz_parties party,
694: hz_parties sub_party
695: where
696: acct_role.cust_account_id = P_CUST_ACCOUNT_ID and
697: acct_role.cust_acct_site_id is null and

Line 694: hz_parties sub_party

690: HZ_CUST_ACCOUNT_ROLES acct_role,
691: HZ_ROLE_RESPONSIBILITY role_resp,
692: HZ_RELATIONSHIPS rel,
693: hz_parties party,
694: hz_parties sub_party
695: where
696: acct_role.cust_account_id = P_CUST_ACCOUNT_ID and
697: acct_role.cust_acct_site_id is null and
698: acct_role.status = 'A' and

Line 723: cont_point.owner_table_name = 'HZ_PARTIES' and

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

Line 13028: FROM HZ_PARTIES

13024: ORDER BY creation_date;
13025: --
13026: CURSOR C_GET_ORG_EMAIL (IN_PARTY_ID NUMBER) IS
13027: SELECT email_address
13028: FROM HZ_PARTIES
13029: WHERE party_ID = in_party_ID;
13030: --
13031: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
13032: SELECT email_address

Line 13466: || p_party_id = pk to hz_parties

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

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

13516: ORDER BY creation_date;
13517: --
13518: CURSOR C_GET_ORG_EMAIL (IN_PARTY_ID NUMBER) IS
13519: SELECT email_address
13520: FROM HZ_PARTIES
13521: WHERE party_ID = in_party_ID;
13522: --
13523: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
13524: SELECT email_address

Line 14043: FROM HZ_PARTIES

14039: WHERE j.user_id = in_user_id;
14040: --
14041: CURSOR C_GET_ORG_EMAIL (IN_PARTY_ID NUMBER) IS
14042: SELECT email_address
14043: FROM HZ_PARTIES
14044: WHERE party_ID = in_party_ID;
14045: --
14046: CURSOR C_GET_CONTACT_EMAIL (IN_PARTY_ID NUMBER) IS
14047: SELECT email_address

Line 15181: FROM HZ_PARTIES

15177: IS
15178: --
15179: CURSOR C_GET_ORG_EMAIL (IN_PARTY_ID NUMBER) IS
15180: SELECT email_address
15181: FROM HZ_PARTIES
15182: WHERE party_ID = in_party_ID;
15183: --
15184: CURSOR C_GET_DUNNING_ORG (IN_PARTY_ID NUMBER) IS
15185: SELECT party_id

Line 15193: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r

15189: AND status = 'A';
15190: --
15191: CURSOR C_GET_ORG_PARTY (IN_REL_PARTY_ID NUMBER) IS
15192: SELECT r.object_id --org party id
15193: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r
15194: WHERE r.party_id = in_rel_party_ID
15195: AND p.party_id = r.object_id
15196: AND p.party_type = 'ORGANIZATION';
15197: --

Line 15200: FROM HZ_PARTIES p

15196: AND p.party_type = 'ORGANIZATION';
15197: --
15198: CURSOR C_GET_PARTY_TYPE (IN_PARTY_ID NUMBER) IS
15199: SELECT p.party_type
15200: FROM HZ_PARTIES p
15201: WHERE p.party_id = in_party_ID;
15202: --
15203: l_api_name CONSTANT VARCHAR2(30) := 'GetContactInfo';
15204: l_api_version NUMBER := 1.0;

Line 15496: AND owner_table_name = 'HZ_PARTIES'

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

Line 15509: AND owner_table_name = 'HZ_PARTIES'

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

Line 15522: AND owner_table_name = 'HZ_PARTIES'

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

Line 15535: AND owner_table_name = 'HZ_PARTIES'

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

Line 16696: HZ_PARTIES h,

16692: ar.trx_number,
16693: ar.payment_schedule_id,
16694: h.party_name
16695: FROM IEX_DELINQUENCIES d,
16696: HZ_PARTIES h,
16697: HZ_CUST_ACCOUNTS a,
16698: AR_PAYMENT_SCHEDULES ar
16699: WHERE d.delinquency_ID = in_del_ID
16700: AND h.party_id = d.party_cust_id

Line 16713: HZ_PARTIES h,

16709: d.customer_site_use_id,
16710: h.party_name,
16711: u.location -- added for bug 14738490
16712: FROM IEX_DELINQUENCIES d,
16713: HZ_PARTIES h,
16714: HZ_CUST_ACCOUNTS a,
16715: HZ_CUST_SITE_USES u -- -- added for bug 14738490
16716: WHERE d.customer_site_use_id = in_SITE_ID
16717: AND u.site_use_id = d.customer_site_use_id

Line 16727: HZ_PARTIES h,

16723: d.cust_account_id,
16724: a.account_number,
16725: h.party_name
16726: FROM IEX_DELINQUENCIES d,
16727: HZ_PARTIES h,
16728: HZ_CUST_ACCOUNTS a
16729: WHERE d.cust_account_ID = in_ACCT_ID
16730: AND h.party_id = d.party_cust_id
16731: AND d.cust_account_id = a.cust_account_id;

Line 16737: HZ_PARTIES h

16733: CURSOR C_GET_CUSTOMER (IN_PARTY_ID NUMBER) IS
16734: SELECT d.party_cust_id,
16735: h.party_name
16736: FROM IEX_DELINQUENCIES d,
16737: HZ_PARTIES h
16738: WHERE d.party_cust_id = in_party_id
16739: AND h.party_id = d.party_cust_id;
16740: --
16741: l_delinquency_id NUMBER;

Line 17874: 'hz_parties p, ' ||

17870: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17871: --'ixr.xml_request_id REQUEST_ID ' ||
17872: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17873: 'from iex_xml_request_histories ixr, ' ||
17874: 'hz_parties p, ' ||
17875: 'iex_dunnings id, ' ||
17876: 'XDO_TEMPLATES_B xtb, ' ||
17877: 'XDO_TEMPLATES_TL xtvl ' ||
17878: 'where id.dunning_object_id = p.party_id ' ||

Line 17906: 'hz_parties p, ' ||

17902: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17903: --'ixr.xml_request_id REQUEST_ID ' ||
17904: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17905: 'from iex_xml_request_histories ixr, ' ||
17906: 'hz_parties p, ' ||
17907: 'hz_cust_accounts hcu, ' ||
17908: 'iex_dunnings id, ' ||
17909: 'XDO_TEMPLATES_B xtb, ' ||
17910: 'XDO_TEMPLATES_TL xtvl ' ||

Line 17941: 'hz_parties p, ' ||

17937: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17938: --'ixr.xml_request_id REQUEST_ID ' ||
17939: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17940: 'from iex_xml_request_histories ixr, ' ||
17941: 'hz_parties p, ' ||
17942: 'hz_cust_accounts hcu,' ||
17943: 'hz_cust_acct_sites_all acct_sites, ' ||
17944: 'hz_cust_site_uses_all site_uses, ' ||
17945: 'iex_dunnings id, ' ||

Line 17980: 'hz_parties p, ' ||

17976: 'decode(id.DUNNING_MODE, ''DRAFT'', iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'', nvl(id.CONFIRMATION_MODE,''DRAFT'')),iex_utilities.get_lookup_meaning(''IEX_CONFIRMATION_MODE'',''CONFIRMED'')) CONFIRMATION_STATUS '||
17977: --'ixr.xml_request_id REQUEST_ID ' ||
17978: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17979: 'from iex_xml_request_histories ixr, ' ||
17980: 'hz_parties p, ' ||
17981: 'iex_dunnings id, ' ||
17982: 'XDO_TEMPLATES_B xtb, ' ||
17983: 'XDO_TEMPLATES_TL xtvl, ' ||
17984: 'iex_delinquencies_all del, ' ||