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 AR_PAYMENT_SCHEDULES

Line 149: ar_payment_schedules_all b

145: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
146: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
147: (SELECT SUM(b.acctd_amount_due_remaining)
148: FROM iex_delinquencies_all a,
149: ar_payment_schedules_all b
150: WHERE a.customer_site_use_id = trx_summ.site_use_id
151: AND a.payment_schedule_id = b.payment_schedule_id
152: AND b.status = 'OP'
153: AND a.status IN('DELINQUENT', 'PREDELINQUENT')

Line 412: ar_payment_schedules_all b

408: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
409: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
410: (SELECT SUM(b.acctd_amount_due_remaining)
411: FROM iex_delinquencies_all a,
412: ar_payment_schedules_all b
413: WHERE a.customer_site_use_id = trx_summ.site_use_id
414: AND a.payment_schedule_id = b.payment_schedule_id
415: AND b.status = 'OP'
416: AND a.status IN('DELINQUENT', 'PREDELINQUENT')

Line 679: ar_payment_schedules_all b

675: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
676: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
677: (SELECT SUM(b.acctd_amount_due_remaining)
678: FROM iex_delinquencies_all a,
679: ar_payment_schedules_all b
680: WHERE a.cust_account_id = trx_summ.cust_account_id
681: AND a.payment_schedule_id = b.payment_schedule_id
682: AND b.status = 'OP'
683: AND a.status IN('DELINQUENT', 'PREDELINQUENT')

Line 937: ar_payment_schedules_all b

933: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
934: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
935: (SELECT SUM(b.acctd_amount_due_remaining)
936: FROM iex_delinquencies_all a,
937: ar_payment_schedules_all b
938: WHERE a.cust_account_id = trx_summ.cust_account_id
939: AND a.payment_schedule_id = b.payment_schedule_id
940: AND b.status = 'OP'
941: AND a.status IN('DELINQUENT', 'PREDELINQUENT')

Line 1202: ar_payment_schedules_all b

1198: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
1199: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
1200: (SELECT SUM(b.acctd_amount_due_remaining)
1201: FROM iex_delinquencies_all a,
1202: ar_payment_schedules_all b
1203: WHERE a.party_cust_id = party.party_id
1204: AND a.payment_schedule_id = b.payment_schedule_id
1205: AND b.status = 'OP'
1206: AND a.status IN('DELINQUENT', 'PREDELINQUENT')

Line 1442: ar_payment_schedules_all b

1438: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
1439: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.pending_adj_value))) pending_adj_value,
1440: (SELECT SUM(b.acctd_amount_due_remaining)
1441: FROM iex_delinquencies_all a,
1442: ar_payment_schedules_all b
1443: WHERE a.party_cust_id = party.party_id
1444: AND a.payment_schedule_id = b.payment_schedule_id
1445: AND b.status = 'OP'
1446: AND a.status IN('DELINQUENT', 'PREDELINQUENT')

Line 3743: ar_payment_schedules_all b,

3739: cursor c_billto_past_due is
3740: SELECT a.customer_site_use_id,
3741: SUM(b.acctd_amount_due_remaining) past_due_inv_value
3742: FROM iex_delinquencies_all a,
3743: ar_payment_schedules_all b,
3744: iex_pop_uwq_summ_gt temp
3745: WHERE a.customer_site_use_id = temp.object_id
3746: AND a.payment_schedule_id = b.payment_schedule_id
3747: AND b.status = 'OP'

Line 3784: ar_payment_schedules ps

3780: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,
3781: max(decode(uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_delinquencies,
3782: del.org_id org_id
3783: from iex_delinquencies del,
3784: ar_payment_schedules ps
3785: WHERE del.payment_schedule_id = ps.payment_schedule_id AND
3786: del.org_id = ps.org_id and
3787: exists(select 1 from iex_delinquencies del1
3788: where del1.last_update_date>=trunc(sysdate)

Line 4971: ar_payment_schedules_all b,

4967: cursor c_account_past_due is
4968: SELECT a.cust_account_id,
4969: SUM(b.acctd_amount_due_remaining) past_due_inv_value
4970: FROM iex_delinquencies_all a,
4971: ar_payment_schedules_all b,
4972: iex_pop_uwq_summ_gt temp
4973: WHERE a.cust_account_id = temp.object_id
4974: AND a.payment_schedule_id = b.payment_schedule_id
4975: AND b.status = 'OP'

Line 5009: ar_payment_schedules ps

5005: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,
5006: max(decode(uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_delinquencies,
5007: del.org_id org_id
5008: from iex_delinquencies del,
5009: ar_payment_schedules ps
5010: WHERE del.payment_schedule_id = ps.payment_schedule_id AND
5011: del.org_id = ps.org_id and
5012: exists(select 1 from iex_delinquencies del1
5013: where del1.last_update_date>=trunc(sysdate)

Line 6190: ar_payment_schedules_all b,

6186: cursor c_customer_past_due is
6187: SELECT a.party_cust_id,
6188: SUM(b.acctd_amount_due_remaining) past_due_inv_value
6189: FROM iex_delinquencies_all a,
6190: ar_payment_schedules_all b,
6191: iex_pop_uwq_summ_gt temp
6192: WHERE a.party_cust_id = temp.object_id
6193: AND a.payment_schedule_id = b.payment_schedule_id
6194: AND b.status = 'OP'

Line 6231: ar_payment_schedules ps

6227: max(decode(uwq_status,'COMPLETE',(decode(sign(TRUNC(uwq_complete_date) + fnd_profile.VALUE('IEX_UWQ_COMPLETION_DAYS') - TRUNC(sysdate)),1,1)))) complete_delinquencies,
6228: max(decode(uwq_status,NULL,1,'ACTIVE',1,'PENDING',(decode(sign(TRUNC(uwq_active_date) - TRUNC(sysdate)),-1,1,0,1)))) active_delinquencies,
6229: del.org_id org_id
6230: from iex_delinquencies del,
6231: ar_payment_schedules ps
6232: WHERE del.payment_schedule_id = ps.payment_schedule_id AND
6233: del.org_id = ps.org_id and
6234: exists(select 1 from iex_delinquencies del1
6235: where del1.last_update_date>=trunc(sysdate)