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

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

669: SUM(decode(trx_summ.currency, gl.CURRENCY_CODE, trx_summ.pending_adj_value,
670: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
671: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
672: MAX(trx_summ.last_payment_date) last_payment_date, --Added last payment columns for bug#5938261 by schekuri on 19-Mar-2007
673: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,
674: max(gl.CURRENCY_CODE) last_payment_amount_curr,
675: MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,
676: trx_summ.site_use_id,
677: trx_summ.org_id

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

671: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
672: MAX(trx_summ.last_payment_date) last_payment_date, --Added last payment columns for bug#5938261 by schekuri on 19-Mar-2007
673: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, 0, trx_summ.site_use_id)) last_payment_amount,
674: max(gl.CURRENCY_CODE) last_payment_amount_curr,
675: MAX(iex_uwq_view_pkg.get_last_payment_number(0, 0, trx_summ.site_use_id)) last_payment_number,
676: trx_summ.site_use_id,
677: trx_summ.org_id
678: FROM AR_TRX_BAL_SUMMARY trx_summ,
679: GL_SETS_OF_BOOKS gl,

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

739: SUM(decode(trx_summ.currency, gl.CURRENCY_CODE, trx_summ.pending_adj_value,
740: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
741: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
742: MAX(trx_summ.last_payment_date) last_payment_date, --Added last payment columns for bug#5938261 by schekuri on 19-Mar-2007
743: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, trx_summ.cust_account_id, 0)) last_payment_amount,
744: max(gl.CURRENCY_CODE) last_payment_amount_curr,
745: MAX(iex_uwq_view_pkg.get_last_payment_number(0, trx_summ.cust_account_id, 0)) last_payment_number,
746: TRX_SUMM.cust_account_id,
747: TRX_SUMM.org_id

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

741: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
742: MAX(trx_summ.last_payment_date) last_payment_date, --Added last payment columns for bug#5938261 by schekuri on 19-Mar-2007
743: MAX(iex_uwq_view_pkg.get_last_payment_amount(0, trx_summ.cust_account_id, 0)) last_payment_amount,
744: max(gl.CURRENCY_CODE) last_payment_amount_curr,
745: MAX(iex_uwq_view_pkg.get_last_payment_number(0, trx_summ.cust_account_id, 0)) last_payment_number,
746: TRX_SUMM.cust_account_id,
747: TRX_SUMM.org_id
748: FROM AR_TRX_BAL_SUMMARY TRX_SUMM,
749: GL_SETS_OF_BOOKS gl,

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

809: SUM(decode(trx_summ.currency, gl.CURRENCY_CODE, trx_summ.pending_adj_value,
810: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
811: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
812: MAX(trx_summ.last_payment_date) last_payment_date, --Added last payment columns for bug#5938261 by schekuri on 19-Mar-2007
813: MAX(iex_uwq_view_pkg.get_last_payment_amount(party.party_id, 0, 0)) last_payment_amount,
814: max(gl.CURRENCY_CODE) last_payment_amount_curr,
815: MAX(iex_uwq_view_pkg.get_last_payment_number(party.party_id, 0, 0)) last_payment_number,
816: party.party_id party_id,
817: trx_summ.org_id org_id

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

811: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
812: MAX(trx_summ.last_payment_date) last_payment_date, --Added last payment columns for bug#5938261 by schekuri on 19-Mar-2007
813: MAX(iex_uwq_view_pkg.get_last_payment_amount(party.party_id, 0, 0)) last_payment_amount,
814: max(gl.CURRENCY_CODE) last_payment_amount_curr,
815: MAX(iex_uwq_view_pkg.get_last_payment_number(party.party_id, 0, 0)) last_payment_number,
816: party.party_id party_id,
817: trx_summ.org_id org_id
818: FROM AR_TRX_BAL_SUMMARY trx_summ, hz_cust_accounts acc,hz_parties party,
819: GL_SETS_OF_BOOKS gl,