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_UTILITIES dependencies on IEX_DUNNING_TRANSACTIONS

Line 3751: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,

3747: and del.staged_dunning_level = p_stage_no
3748: and nvl(arp.amount_in_dispute,0) = decode(p_include_dis_items, 'Y', nvl(arp.amount_in_dispute,0), 0)
3749: and nvl(((select trunc(correspondence_date) from iex_dunnings
3750: where dunning_id =
3751: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,
3752: iex_dunnings dunn
3753: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
3754: and dunn.dunning_id = iet.dunning_id
3755: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')

Line 3787: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,

3783: and nvl(
3784: (
3785: (select trunc(correspondence_date) from iex_dunnings
3786: where dunning_id =
3787: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,
3788: iex_dunnings dunn
3789: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
3790: and dunn.dunning_id = iet.dunning_id
3791: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')

Line 3858: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,

3854: and nvl(
3855: (
3856: (select trunc(correspondence_date) from iex_dunnings
3857: where dunning_id =
3858: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,
3859: iex_dunnings dunn
3860: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
3861: and dunn.dunning_id = iet.dunning_id
3862: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')

Line 3894: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,

3890: and nvl(
3891: (
3892: (select trunc(correspondence_date) from iex_dunnings
3893: where dunning_id =
3894: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,
3895: iex_dunnings dunn
3896: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
3897: and dunn.dunning_id = iet.dunning_id
3898: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')

Line 3965: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,

3961: and nvl(
3962: (
3963: (select trunc(correspondence_date) from iex_dunnings
3964: where dunning_id =
3965: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,
3966: iex_dunnings dunn
3967: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
3968: and dunn.dunning_id = iet.dunning_id
3969: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')

Line 4001: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,

3997: and nvl(
3998: (
3999: (select trunc(correspondence_date) from iex_dunnings
4000: where dunning_id =
4001: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,
4002: iex_dunnings dunn
4003: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
4004: and dunn.dunning_id = iet.dunning_id
4005: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')

Line 4601: from iex_dunning_transactions iet,

4597: l_stage_number number;
4598: begin
4599: select max(iet.stage_number)
4600: into l_stage_number
4601: from iex_dunning_transactions iet,
4602: iex_dunnings dunn,
4603: iex_delinquencies_all del
4604: where iet.payment_schedule_id = del.payment_schedule_id
4605: and del.delinquency_id = p_delinquency_id