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_UWQ_POP_SUM_TBL_PVT dependencies on IEX_UWQ_VIEW_PKG

Line 157: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,

153: AND a.status IN('DELINQUENT', 'PREDELINQUENT')
154: AND b.org_id = trx_summ.org_id) past_due_inv_value,
155: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
156: MAX(trx_summ.last_payment_date) last_payment_date,
157: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,
158: max(gl.CURRENCY_CODE) last_payment_amount_curr,
159: MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,
160: MAX(trx_summ.last_update_date) last_update_date,
161: MAX(trx_summ.last_updated_by) last_updated_by,

Line 159: MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,

155: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
156: MAX(trx_summ.last_payment_date) last_payment_date,
157: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,
158: max(gl.CURRENCY_CODE) last_payment_amount_curr,
159: MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,
160: MAX(trx_summ.last_update_date) last_update_date,
161: MAX(trx_summ.last_updated_by) last_updated_by,
162: MAX(trx_summ.creation_date) creation_date,
163: MAX(trx_summ.created_by) created_by,

Line 420: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,

416: AND a.status IN('DELINQUENT', 'PREDELINQUENT')
417: AND b.org_id = trx_summ.org_id) past_due_inv_value,
418: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
419: MAX(trx_summ.last_payment_date) last_payment_date,
420: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,
421: max(gl.CURRENCY_CODE) last_payment_amount_curr,
422: MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,
423: MAX(trx_summ.last_update_date) last_update_date,
424: MAX(trx_summ.last_updated_by) last_updated_by,

Line 422: MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,

418: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
419: MAX(trx_summ.last_payment_date) last_payment_date,
420: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,
421: max(gl.CURRENCY_CODE) last_payment_amount_curr,
422: MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,
423: MAX(trx_summ.last_update_date) last_update_date,
424: MAX(trx_summ.last_updated_by) last_updated_by,
425: MAX(trx_summ.creation_date) creation_date,
426: MAX(trx_summ.created_by) created_by,

Line 687: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, trx_summ.cust_account_id, 0)) last_payment_amount,

683: AND a.status IN('DELINQUENT', 'PREDELINQUENT')
684: AND b.org_id = trx_summ.org_id) past_due_inv_value,
685: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
686: MAX(trx_summ.last_payment_date) last_payment_date,
687: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, trx_summ.cust_account_id, 0)) last_payment_amount,
688: max(gl.CURRENCY_CODE) last_payment_amount_curr,
689: MAX(iex_uwq_view_pkg.get_last_payment_number(0, trx_summ.cust_account_id, 0)) last_payment_number,
690: MAX(trx_summ.last_update_date) last_update_date,
691: MAX(trx_summ.last_updated_by) last_updated_by,

Line 689: MAX(iex_uwq_view_pkg.get_last_payment_number(0, trx_summ.cust_account_id, 0)) last_payment_number,

685: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
686: MAX(trx_summ.last_payment_date) last_payment_date,
687: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, trx_summ.cust_account_id, 0)) last_payment_amount,
688: max(gl.CURRENCY_CODE) last_payment_amount_curr,
689: MAX(iex_uwq_view_pkg.get_last_payment_number(0, trx_summ.cust_account_id, 0)) last_payment_number,
690: MAX(trx_summ.last_update_date) last_update_date,
691: MAX(trx_summ.last_updated_by) last_updated_by,
692: MAX(trx_summ.creation_date) creation_date,
693: MAX(trx_summ.created_by) created_by,

Line 945: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, trx_summ.cust_account_id, 0)) last_payment_amount,

941: AND a.status IN('DELINQUENT', 'PREDELINQUENT')
942: AND b.org_id = trx_summ.org_id) past_due_inv_value,
943: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
944: MAX(trx_summ.last_payment_date) last_payment_date,
945: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, trx_summ.cust_account_id, 0)) last_payment_amount,
946: max(gl.CURRENCY_CODE) last_payment_amount_curr,
947: MAX(iex_uwq_view_pkg.get_last_payment_number(0, trx_summ.cust_account_id, 0)) last_payment_number,
948: MAX(trx_summ.last_update_date) last_update_date,
949: MAX(trx_summ.last_updated_by) last_updated_by,

Line 947: MAX(iex_uwq_view_pkg.get_last_payment_number(0, trx_summ.cust_account_id, 0)) last_payment_number,

943: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
944: MAX(trx_summ.last_payment_date) last_payment_date,
945: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, trx_summ.cust_account_id, 0)) last_payment_amount,
946: max(gl.CURRENCY_CODE) last_payment_amount_curr,
947: MAX(iex_uwq_view_pkg.get_last_payment_number(0, trx_summ.cust_account_id, 0)) last_payment_number,
948: MAX(trx_summ.last_update_date) last_update_date,
949: MAX(trx_summ.last_updated_by) last_updated_by,
950: MAX(trx_summ.creation_date) creation_date,
951: MAX(trx_summ.created_by) created_by,

Line 1210: MAX(iex_uwq_view_pkg.get_last_payment_amount(party.party_id, 0, 0)) last_payment_amount,

1206: AND a.status IN('DELINQUENT', 'PREDELINQUENT')
1207: AND b.org_id = trx_summ.org_id) past_due_inv_value,
1208: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
1209: MAX(trx_summ.last_payment_date) last_payment_date,
1210: MAX(iex_uwq_view_pkg.get_last_payment_amount(party.party_id, 0, 0)) last_payment_amount,
1211: max(gl.CURRENCY_CODE) last_payment_amount_curr,
1212: MAX(iex_uwq_view_pkg.get_last_payment_number(party.party_id, 0, 0)) last_payment_number,
1213: MAX(trx_summ.last_update_date) last_update_date,
1214: MAX(trx_summ.last_updated_by) last_updated_by,

Line 1212: MAX(iex_uwq_view_pkg.get_last_payment_number(party.party_id, 0, 0)) last_payment_number,

1208: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
1209: MAX(trx_summ.last_payment_date) last_payment_date,
1210: MAX(iex_uwq_view_pkg.get_last_payment_amount(party.party_id, 0, 0)) last_payment_amount,
1211: max(gl.CURRENCY_CODE) last_payment_amount_curr,
1212: MAX(iex_uwq_view_pkg.get_last_payment_number(party.party_id, 0, 0)) last_payment_number,
1213: MAX(trx_summ.last_update_date) last_update_date,
1214: MAX(trx_summ.last_updated_by) last_updated_by,
1215: MAX(trx_summ.creation_date) creation_date,
1216: MAX(trx_summ.created_by) created_by,

Line 1284: iex_uwq_view_pkg.get_pro_count(party.party_id, NULL, NULL, NULL, trx_summ.org_id) number_of_promises,

1280: phone.phone_number phone_number,
1281: phone.phone_extension phone_extension,
1282: (SELECT COUNT(1) FROM iex_bankruptcies bkr WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
1283:
1284: iex_uwq_view_pkg.get_pro_count(party.party_id, NULL, NULL, NULL, trx_summ.org_id) number_of_promises,
1285: iex_uwq_view_pkg.get_broken_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) broken_promise_amount,
1286: iex_uwq_view_pkg.get_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) promise_amount,
1287: (SELECT 1
1288: FROM dual

Line 1285: iex_uwq_view_pkg.get_broken_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) broken_promise_amount,

1281: phone.phone_extension phone_extension,
1282: (SELECT COUNT(1) FROM iex_bankruptcies bkr WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
1283:
1284: iex_uwq_view_pkg.get_pro_count(party.party_id, NULL, NULL, NULL, trx_summ.org_id) number_of_promises,
1285: iex_uwq_view_pkg.get_broken_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) broken_promise_amount,
1286: iex_uwq_view_pkg.get_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) promise_amount,
1287: (SELECT 1
1288: FROM dual
1289: WHERE EXISTS

Line 1286: iex_uwq_view_pkg.get_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) promise_amount,

1282: (SELECT COUNT(1) FROM iex_bankruptcies bkr WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
1283:
1284: iex_uwq_view_pkg.get_pro_count(party.party_id, NULL, NULL, NULL, trx_summ.org_id) number_of_promises,
1285: iex_uwq_view_pkg.get_broken_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) broken_promise_amount,
1286: iex_uwq_view_pkg.get_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) promise_amount,
1287: (SELECT 1
1288: FROM dual
1289: WHERE EXISTS
1290: (SELECT 1

Line 1450: MAX(iex_uwq_view_pkg.get_last_payment_amount(party.party_id, 0, 0)) last_payment_amount,

1446: AND a.status IN('DELINQUENT', 'PREDELINQUENT')
1447: AND b.org_id = trx_summ.org_id) past_due_inv_value,
1448: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
1449: MAX(trx_summ.last_payment_date) last_payment_date,
1450: MAX(iex_uwq_view_pkg.get_last_payment_amount(party.party_id, 0, 0)) last_payment_amount,
1451: max(gl.CURRENCY_CODE) last_payment_amount_curr,
1452: MAX(iex_uwq_view_pkg.get_last_payment_number(party.party_id, 0, 0)) last_payment_number,
1453: MAX(trx_summ.last_update_date) last_update_date,
1454: MAX(trx_summ.last_updated_by) last_updated_by,

Line 1452: MAX(iex_uwq_view_pkg.get_last_payment_number(party.party_id, 0, 0)) last_payment_number,

1448: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
1449: MAX(trx_summ.last_payment_date) last_payment_date,
1450: MAX(iex_uwq_view_pkg.get_last_payment_amount(party.party_id, 0, 0)) last_payment_amount,
1451: max(gl.CURRENCY_CODE) last_payment_amount_curr,
1452: MAX(iex_uwq_view_pkg.get_last_payment_number(party.party_id, 0, 0)) last_payment_number,
1453: MAX(trx_summ.last_update_date) last_update_date,
1454: MAX(trx_summ.last_updated_by) last_updated_by,
1455: MAX(trx_summ.creation_date) creation_date,
1456: MAX(trx_summ.created_by) created_by,

Line 1524: iex_uwq_view_pkg.get_pro_count(party.party_id, NULL, NULL, NULL, trx_summ.org_id) number_of_promises,

1520: phone.phone_number phone_number,
1521: phone.phone_extension phone_extension,
1522: (SELECT COUNT(1) FROM iex_bankruptcies bkr WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
1523:
1524: iex_uwq_view_pkg.get_pro_count(party.party_id, NULL, NULL, NULL, trx_summ.org_id) number_of_promises,
1525: iex_uwq_view_pkg.get_broken_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) broken_promise_amount,
1526: iex_uwq_view_pkg.get_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) promise_amount,
1527: (SELECT 1
1528: FROM dual

Line 1525: iex_uwq_view_pkg.get_broken_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) broken_promise_amount,

1521: phone.phone_extension phone_extension,
1522: (SELECT COUNT(1) FROM iex_bankruptcies bkr WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
1523:
1524: iex_uwq_view_pkg.get_pro_count(party.party_id, NULL, NULL, NULL, trx_summ.org_id) number_of_promises,
1525: iex_uwq_view_pkg.get_broken_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) broken_promise_amount,
1526: iex_uwq_view_pkg.get_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) promise_amount,
1527: (SELECT 1
1528: FROM dual
1529: WHERE EXISTS

Line 1526: iex_uwq_view_pkg.get_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) promise_amount,

1522: (SELECT COUNT(1) FROM iex_bankruptcies bkr WHERE bkr.party_id = party.party_id and NVL(BKR.DISPOSITION_CODE,'GRANTED') in ('GRANTED','NEGOTIATION')) number_of_bankruptcies, -- Changed for bug#7693986
1523:
1524: iex_uwq_view_pkg.get_pro_count(party.party_id, NULL, NULL, NULL, trx_summ.org_id) number_of_promises,
1525: iex_uwq_view_pkg.get_broken_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) broken_promise_amount,
1526: iex_uwq_view_pkg.get_prm_amt(party.party_id, NULL, NULL, trx_summ.org_id) promise_amount,
1527: (SELECT 1
1528: FROM dual
1529: WHERE EXISTS
1530: (SELECT 1

Line 3469: --MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,

3465: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
3466: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
3467: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
3468: MAX(trx_summ.last_payment_date) last_payment_date,
3469: --MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,
3470: max(gl.CURRENCY_CODE) last_payment_amount_curr,
3471: -- MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,
3472: MAX(trx_summ.last_update_date) last_update_date,
3473: MAX(trx_summ.last_updated_by) last_updated_by,

Line 3471: -- MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,

3467: SUM(trx_summ.past_due_inv_inst_count) past_due_inv_inst_count,
3468: MAX(trx_summ.last_payment_date) last_payment_date,
3469: --MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,
3470: max(gl.CURRENCY_CODE) last_payment_amount_curr,
3471: -- MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,
3472: MAX(trx_summ.last_update_date) last_update_date,
3473: MAX(trx_summ.last_updated_by) last_updated_by,
3474: MAX(trx_summ.creation_date) creation_date,
3475: MAX(trx_summ.created_by) created_by,

Line 3755: iex_uwq_view_pkg.convert_amount(o_summ.last_payment_amount,o_summ.currency) last_payment_amount

3751:
3752: cursor c_last_payment_no_amount is
3753: SELECT o_summ.site_use_id,
3754: o_summ.last_payment_number last_payment_number,
3755: iex_uwq_view_pkg.convert_amount(o_summ.last_payment_amount,o_summ.currency) last_payment_amount
3756: FROM ar_trx_bal_summary o_summ
3757: WHERE o_summ.site_use_id in (select object_id from iex_pop_uwq_summ_gt)
3758: AND o_summ.last_payment_date = (SELECT MAX(last_payment_date)
3759: FROM ar_trx_bal_summary

Line 4983: iex_uwq_view_pkg.convert_amount(o_summ.last_payment_amount,o_summ.currency) last_payment_amount

4979:
4980: cursor c_last_payment_no_amount is
4981: SELECT o_summ.cust_account_id,
4982: o_summ.last_payment_number last_payment_number,
4983: iex_uwq_view_pkg.convert_amount(o_summ.last_payment_amount,o_summ.currency) last_payment_amount
4984: FROM ar_trx_bal_summary o_summ
4985: WHERE o_summ.cust_account_id in (select object_id from iex_pop_uwq_summ_gt)
4986: AND o_summ.last_payment_date = (SELECT MAX(last_payment_date)
4987: FROM ar_trx_bal_summary

Line 6202: iex_uwq_view_pkg.convert_amount(o_summ.last_payment_amount,o_summ.currency) last_payment_amount

6198:
6199: cursor c_last_payment_no_amount is
6200: SELECT o_acc.party_id,
6201: o_summ.last_payment_number last_payment_number,
6202: iex_uwq_view_pkg.convert_amount(o_summ.last_payment_amount,o_summ.currency) last_payment_amount
6203: FROM ar_trx_bal_summary o_summ,
6204: hz_cust_accounts o_acc
6205: WHERE o_summ.cust_account_id = o_acc.cust_account_id
6206: and o_acc.party_id in (select object_id from iex_pop_uwq_summ_gt)