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 IEX_PROMISE_DETAILS

Line 4097: from iex_promise_details pd where pd.delinquency_id=del.delinquency_id

4093: AND ps.payment_schedule_id = del.payment_schedule_id
4094: AND ps.status = 'OP'
4095: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
4096: and not exists(select 1
4097: from iex_promise_details pd where pd.delinquency_id=del.delinquency_id
4098: and pd.status='COLLECTABLE'
4099: and pd.state='PROMISE'
4100: group by pd.delinquency_id
4101: having sum(nvl(pd.promise_amount,0))>=ps.amount_due_remaining);

Line 4110: from iex_promise_details pd where pd.delinquency_id=del.delinquency_id

4106: AND ps.payment_schedule_id = del.payment_schedule_id
4107: AND ps.status = 'OP'
4108: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
4109: and not exists(select 1
4110: from iex_promise_details pd where pd.delinquency_id=del.delinquency_id
4111: and pd.status='COLLECTABLE'
4112: and pd.state='PROMISE'
4113: group by pd.delinquency_id
4114: having sum(nvl(pd.promise_amount,0))>=ps.amount_due_remaining);

Line 4123: from iex_promise_details pd where pd.delinquency_id=del.delinquency_id

4119: AND ps.payment_schedule_id = del.payment_schedule_id
4120: AND ps.status = 'OP'
4121: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
4122: and not exists(select 1
4123: from iex_promise_details pd where pd.delinquency_id=del.delinquency_id
4124: and pd.status='COLLECTABLE'
4125: and pd.state='PROMISE'
4126: group by pd.delinquency_id
4127: having sum(nvl(pd.promise_amount,0))>=ps.amount_due_remaining);

Line 7196: and not exists(select 1 from iex_promise_details pd where pd.delinquency_id=del.delinquency_id

7192: WHERE del.delinquency_id= l_delinquency_id
7193: AND ps.payment_schedule_id = del.payment_schedule_id
7194: AND ps.status = 'OP'
7195: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
7196: and not exists(select 1 from iex_promise_details pd where pd.delinquency_id=del.delinquency_id
7197: and pd.status='COLLECTABLE'
7198: and pd.state='PROMISE'
7199: group by pd.delinquency_id
7200: having sum(nvl(pd.promise_amount,0))>=ps.amount_due_remaining);