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 AR_AGING_BUCKETS

Line 4025: ar_aging_buckets ar,

4021: x.fm_method,
4022: upper(x.callback_flag),
4023: x.callback_days
4024: FROM IEX_AG_DN_XREF x,
4025: ar_aging_buckets ar,
4026: iex_dunning_plans_vl d
4027: WHERE x.aging_bucket_line_ID = l_line_ID
4028: and x.dunning_plan_id = p_dunning_plan_id
4029: AND l_score between x.score_range_low and x.score_range_high

Line 5291: ar_aging_buckets ar,

5287: x.fm_method,
5288: upper(x.callback_flag),
5289: x.callback_days
5290: FROM IEX_AG_DN_XREF x,
5291: ar_aging_buckets ar,
5292: iex_dunning_plans_vl d
5293: WHERE x.aging_bucket_line_ID = l_line_ID
5294: and x.dunning_plan_id = p_dunning_plan_id
5295: AND l_score between x.score_range_low and x.score_range_high

Line 6946: ar_aging_buckets ar,

6942: upper(x.callback_flag),
6943: x.callback_days,
6944: ar.bucket_name
6945: FROM IEX_AG_DN_XREF x,
6946: ar_aging_buckets ar,
6947: iex_dunning_plans_vl d
6948: WHERE x.aging_bucket_line_ID = l_line_ID
6949: and x.dunning_plan_id = p_dunning_plan_id
6950: AND l_score between x.score_range_low and x.score_range_high

Line 7992: ar_aging_buckets ar,

7988: upper(x.callback_flag),
7989: x.callback_days,
7990: ar.bucket_name
7991: FROM IEX_AG_DN_XREF x,
7992: ar_aging_buckets ar,
7993: iex_dunning_plans_vl d
7994: WHERE x.aging_bucket_line_ID = l_line_ID
7995: and x.dunning_plan_id = p_dunning_plan_id
7996: AND l_score between x.score_range_low and x.score_range_high

Line 9167: ar_aging_buckets ar,

9163: x.fm_method,
9164: upper(x.callback_flag),
9165: x.callback_days
9166: FROM IEX_AG_DN_XREF x,
9167: ar_aging_buckets ar,
9168: iex_dunning_plans_vl d
9169: WHERE x.aging_bucket_line_ID = l_line_ID
9170: and x.dunning_plan_id = p_dunning_plan_id
9171: AND l_score between x.score_range_low and x.score_range_high

Line 10247: ar_aging_buckets ar,

10243: x.fm_method,
10244: upper(x.callback_flag),
10245: x.callback_days
10246: FROM IEX_AG_DN_XREF x,
10247: ar_aging_buckets ar,
10248: iex_dunning_plans_vl d
10249: WHERE x.aging_bucket_line_ID = l_line_ID
10250: and x.dunning_plan_id = p_dunning_plan_id
10251: AND l_score between x.score_range_low and x.score_range_high

Line 11199: ar_aging_buckets ar,

11195: upper(x.callback_flag),
11196: x.callback_days,
11197: ar.bucket_name
11198: FROM IEX_AG_DN_XREF x,
11199: ar_aging_buckets ar,
11200: iex_dunning_plans_vl d
11201: WHERE x.aging_bucket_line_ID = l_line_ID
11202: and x.dunning_plan_id = p_dunning_plan_id
11203: AND l_score between x.score_range_low and x.score_range_high

Line 11991: ar_aging_buckets ar,

11987: upper(x.callback_flag),
11988: x.callback_days,
11989: ar.bucket_name
11990: FROM IEX_AG_DN_XREF x,
11991: ar_aging_buckets ar,
11992: iex_dunning_plans_vl d
11993: WHERE x.aging_bucket_line_ID = l_line_ID
11994: and x.dunning_plan_id = p_dunning_plan_id
11995: AND l_score between x.score_range_low and x.score_range_high

Line 12823: ar_aging_buckets b,

12819:
12820: CURSOR C_GET_BUCKET_LINE (IN_DAYS NUMBER, p_dunning_plan_id number) IS
12821: SELECT l.aging_bucket_line_id
12822: FROM ar_aging_bucket_lines l,
12823: ar_aging_buckets b,
12824: iex_dunning_plans_vl d
12825: WHERE d.dunning_plan_id = p_dunning_plan_id
12826: and d.aging_bucket_id = b.aging_bucket_id
12827: and b.aging_bucket_id = l.aging_bucket_id