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_DUNNINGS

Line 3749: and nvl(((select trunc(correspondence_date) from iex_dunnings

3745: del.status in ('DELINQUENT','PREDELINQUENT')
3746: and del.customer_site_use_id = p_site_use_id
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

Line 3752: iex_dunnings dunn

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')
3756: OR (dunn.dunning_mode = 'FINAL'))

Line 3785: (select trunc(correspondence_date) from iex_dunnings

3781: and (arp.class = 'INV' or arp.class = 'BR') -- Bills Receivables change
3782: and arp.amount_in_dispute >= decode(p_include_dis_items, 'Y', arp.amount_due_remaining, (arp.amount_due_original + 1))
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

Line 3788: iex_dunnings dunn

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')
3792: OR (dunn.dunning_mode = 'FINAL'))

Line 3856: (select trunc(correspondence_date) from iex_dunnings

3852: and del.staged_dunning_level = p_stage_no
3853: and nvl(arp.amount_in_dispute,0) = decode(p_include_dis_items, 'Y', nvl(arp.amount_in_dispute,0), 0)
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

Line 3859: iex_dunnings dunn

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')
3863: OR (dunn.dunning_mode = 'FINAL'))

Line 3892: (select trunc(correspondence_date) from iex_dunnings

3888: and (arp.class = 'INV' or arp.class = 'BR') -- Bills Receivables change
3889: and arp.amount_in_dispute >= decode(p_include_dis_items, 'Y', arp.amount_due_remaining, (arp.amount_due_original + 1))
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

Line 3895: iex_dunnings dunn

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')
3899: OR (dunn.dunning_mode = 'FINAL'))

Line 3963: (select trunc(correspondence_date) from iex_dunnings

3959: and del.staged_dunning_level = p_stage_no
3960: and nvl(arp.amount_in_dispute,0) = decode(p_include_dis_items, 'Y', nvl(arp.amount_in_dispute,0), 0)
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

Line 3966: iex_dunnings dunn

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')
3970: OR (dunn.dunning_mode = 'FINAL'))

Line 3999: (select trunc(correspondence_date) from iex_dunnings

3995: and (arp.class = 'INV' or arp.class = 'BR') -- Bills Receivables change
3996: and arp.amount_in_dispute >= decode(p_include_dis_items, 'Y', arp.amount_due_remaining, (arp.amount_due_original + 1))
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

Line 4002: iex_dunnings dunn

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')
4006: OR (dunn.dunning_mode = 'FINAL'))

Line 4602: iex_dunnings dunn,

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
4606: and dunn.dunning_id = iet.dunning_id