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_AGING_BUCKETS_PKG dependencies on AR_AGING_BUCKET_LINES

Line 95: v_bucket_category ar_aging_bucket_lines.type%TYPE;

91: v_bucket_3 NUMBER;
92: v_bucket_4 NUMBER;
93: v_bucket_5 NUMBER;
94: v_bucket_6 NUMBER;
95: v_bucket_category ar_aging_bucket_lines.type%TYPE;
96: --
97: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;
98: v_bucket_days_from_0 NUMBER;
99: v_bucket_days_to_0 NUMBER;

Line 97: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;

93: v_bucket_5 NUMBER;
94: v_bucket_6 NUMBER;
95: v_bucket_category ar_aging_bucket_lines.type%TYPE;
96: --
97: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;
98: v_bucket_days_from_0 NUMBER;
99: v_bucket_days_to_0 NUMBER;
100: v_bucket_line_id_0 NUMBER;
101: v_bucket_seq_num_0 NUMBER ;

Line 103: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;

99: v_bucket_days_to_0 NUMBER;
100: v_bucket_line_id_0 NUMBER;
101: v_bucket_seq_num_0 NUMBER ;
102:
103: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;
104: v_bucket_days_from_1 NUMBER;
105: v_bucket_days_to_1 NUMBER;
106: v_bucket_line_id_1 NUMBER;
107: v_bucket_seq_num_1 NUMBER ;

Line 109: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;

105: v_bucket_days_to_1 NUMBER;
106: v_bucket_line_id_1 NUMBER;
107: v_bucket_seq_num_1 NUMBER ;
108:
109: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;
110: v_bucket_days_from_2 NUMBER;
111: v_bucket_days_to_2 NUMBER;
112: v_bucket_line_id_2 NUMBER;
113: v_bucket_seq_num_2 NUMBER ;

Line 115: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;

111: v_bucket_days_to_2 NUMBER;
112: v_bucket_line_id_2 NUMBER;
113: v_bucket_seq_num_2 NUMBER ;
114:
115: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;
116: v_bucket_days_from_3 NUMBER;
117: v_bucket_days_to_3 NUMBER;
118: v_bucket_line_id_3 NUMBER;
119: v_bucket_seq_num_3 NUMBER ;

Line 121: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;

117: v_bucket_days_to_3 NUMBER;
118: v_bucket_line_id_3 NUMBER;
119: v_bucket_seq_num_3 NUMBER ;
120:
121: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;
122: v_bucket_days_from_4 NUMBER;
123: v_bucket_days_to_4 NUMBER;
124: v_bucket_line_id_4 NUMBER;
125: v_bucket_seq_num_4 NUMBER ;

Line 127: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;

123: v_bucket_days_to_4 NUMBER;
124: v_bucket_line_id_4 NUMBER;
125: v_bucket_seq_num_4 NUMBER ;
126:
127: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;
128: v_bucket_days_from_5 NUMBER;
129: v_bucket_days_to_5 NUMBER;
130: v_bucket_line_id_5 NUMBER;
131: v_bucket_seq_num_5 NUMBER ;

Line 133: v_bucket_line_type_6 ar_aging_bucket_lines.type%TYPE;

129: v_bucket_days_to_5 NUMBER;
130: v_bucket_line_id_5 NUMBER;
131: v_bucket_seq_num_5 NUMBER ;
132:
133: v_bucket_line_type_6 ar_aging_bucket_lines.type%TYPE;
134: v_bucket_days_from_6 NUMBER;
135: v_bucket_days_to_6 NUMBER;
136: v_bucket_line_id_6 NUMBER;
137: v_bucket_seq_num_6 NUMBER ;

Line 148: from ar_aging_bucket_lines lines,

144: lines.report_heading2,
145: lines.type,
146: lines.aging_bucket_line_id,
147: lines.bucket_sequence_num
148: from ar_aging_bucket_lines lines,
149: ar_aging_buckets buckets
150: where lines.aging_bucket_id = buckets.aging_bucket_id
151: and buckets.aging_bucket_id = p_bucket_id
152: and buckets.status = 'A'

Line 2902: from ar_aging_bucket_lines aabl,

2898: select aabl.aging_bucket_line_id, sum(acctd_amount_due_remaining)
2899: BULK COLLECT INTO
2900: l_collectible_bkt_id_tbl,
2901: l_collectible_bkt_amt_tbl
2902: from ar_aging_bucket_lines aabl,
2903: ar_payment_schedules aps,
2904: iex_delinquencies id
2905: where id.payment_schedule_id = aps.payment_schedule_id
2906: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due

Line 2929: FROM ar_aging_bucket_lines aabl,

2925: INTO l_collect_dispute_amt
2926: FROM ra_cm_requests
2927: WHERE customer_trx_id IN
2928: (SELECT DISTINCT id.transaction_id
2929: FROM ar_aging_bucket_lines aabl,
2930: ar_payment_schedules aps,
2931: iex_delinquencies id
2932: WHERE id.payment_schedule_id = aps.payment_schedule_id
2933: AND id.status IN('DELINQUENT', 'PREDELINQUENT')

Line 2953: from ar_aging_bucket_lines aabl,

2949: select aabl.aging_bucket_line_id, sum(acctd_amount_due_remaining)
2950: BULK COLLECT INTO
2951: l_collectible_bkt_id_tbl,
2952: l_collectible_bkt_amt_tbl
2953: from ar_aging_bucket_lines aabl,
2954: ar_payment_schedules aps,
2955: iex_delinquencies id,
2956: hz_cust_accounts hzca
2957: where id.payment_schedule_id = aps.payment_schedule_id

Line 2989: FROM ar_aging_bucket_lines aabl,

2985: INTO l_collect_dispute_amt
2986: FROM ra_cm_requests
2987: WHERE customer_trx_id IN
2988: (SELECT DISTINCT id.transaction_id
2989: FROM ar_aging_bucket_lines aabl,
2990: ar_payment_schedules aps,
2991: iex_delinquencies id,
2992: hz_cust_accounts hzca
2993: WHERE id.payment_schedule_id = aps.payment_schedule_id

Line 3022: from ar_aging_bucket_lines aabl,

3018: select aabl.aging_bucket_line_id, sum(acctd_amount_due_remaining)
3019: BULK COLLECT INTO
3020: l_collectible_bkt_id_tbl,
3021: l_collectible_bkt_amt_tbl
3022: from ar_aging_bucket_lines aabl,
3023: ar_payment_schedules aps,
3024: iex_delinquencies id,
3025: hz_cust_accounts hzca
3026: where id.payment_schedule_id = aps.payment_schedule_id

Line 3050: FROM ar_aging_bucket_lines aabl,

3046: INTO l_collect_dispute_amt
3047: FROM ra_cm_requests
3048: WHERE customer_trx_id IN
3049: (SELECT DISTINCT id.transaction_id
3050: FROM ar_aging_bucket_lines aabl,
3051: ar_payment_schedules aps,
3052: iex_delinquencies id,
3053: hz_cust_accounts hzca
3054: WHERE id.payment_schedule_id = aps.payment_schedule_id

Line 3076: from ar_aging_bucket_lines aabl, -- added by ehuh for bill-to

3072: select aabl.aging_bucket_line_id, sum(acctd_amount_due_remaining) -- added by ehuh for bill-to
3073: BULK COLLECT INTO -- added by ehuh for bill-to
3074: l_collectible_bkt_id_tbl, -- added by ehuh for bill-to
3075: l_collectible_bkt_amt_tbl -- added by ehuh for bill-to
3076: from ar_aging_bucket_lines aabl, -- added by ehuh for bill-to
3077: ar_payment_schedules aps, -- added by ehuh for bill-to
3078: iex_delinquencies id
3079: where id.payment_schedule_id = aps.payment_schedule_id -- added by ehuh for bill-to
3080: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due

Line 3102: FROM ar_aging_bucket_lines aabl,

3098: INTO l_collect_dispute_amt
3099: FROM ra_cm_requests
3100: WHERE customer_trx_id IN
3101: (SELECT DISTINCT id.transaction_id
3102: FROM ar_aging_bucket_lines aabl,
3103: ar_payment_schedules aps,
3104: iex_delinquencies id
3105: WHERE id.payment_schedule_id = aps.payment_schedule_id
3106: AND id.status IN('DELINQUENT', 'PREDELINQUENT')

Line 3349: p_bucket_line_id IN AR_AGING_BUCKET_LINES_B.Aging_Bucket_Line_Id%TYPE,

3345: x_return_status OUT NOCOPY VARCHAR2,
3346: x_msg_count OUT NOCOPY NUMBER,
3347: x_msg_data OUT NOCOPY VARCHAR2,
3348: p_filter_mode IN Varchar2,
3349: p_bucket_line_id IN AR_AGING_BUCKET_LINES_B.Aging_Bucket_Line_Id%TYPE,
3350: p_filter_id IN Number,
3351: p_customer_site_use_id IN Number, -- added by ehuh for bill-to
3352: p_class IN varchar2,
3353: p_using_paying_rel IN VARCHAR2,

Line 3383: from ar_aging_bucket_lines

3379:
3380: --- Begin - Andre Araujo - 11/09/2004 - Performance fix we will select the aging separately
3381: select days_start, days_to
3382: into v_days_start, v_days_to
3383: from ar_aging_bucket_lines
3384: where aging_bucket_line_id = p_bucket_line_id;
3385:
3386: v_tran_sql :=
3387: -- 'SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0)

Line 3389: -- ar_aging_bucket_lines aabl

3385:
3386: v_tran_sql :=
3387: -- 'SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0)
3388: -- FROM ar_payment_schedules arp,
3389: -- ar_aging_bucket_lines aabl
3390: -- WHERE sysdate-arp.due_date >= aabl.days_start
3391: -- and sysdate-arp.due_date <= aabl.days_to
3392: -- and arp.class = :class
3393: -- and arp.status = ''OP''

Line 3413: ar_aging_bucket_lines aabl,

3409: IF NVL(p_using_paying_rel, 'N') = 'Y' THEN
3410: v_paying_party_tran_sql :=
3411: 'SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0)
3412: FROM ar_payment_schedules arp,
3413: ar_aging_bucket_lines aabl,
3414: hz_cust_accounts hzca
3415: WHERE trunc(sysdate)-trunc(arp.due_date) >= aabl.days_start
3416: and trunc(sysdate)-trunc(arp.due_date) <= aabl.days_to
3417: and arp.class = :class

Line 3435: -- ar_aging_bucket_lines aabl,

3431: ELSE
3432: v_party_tran_sql :=
3433: -- 'SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0)
3434: -- FROM ar_payment_schedules arp,
3435: -- ar_aging_bucket_lines aabl,
3436: -- hz_cust_accounts hzca
3437: -- WHERE sysdate-arp.due_date >= aabl.days_start
3438: -- and sysdate-arp.due_date <= aabl.days_to
3439: -- and arp.class = :class

Line 3463: -- ar_aging_bucket_lines aabl,

3459: /* Start added by ehuh for bill_to */
3460: v_party_billto_tran_sql :=
3461: -- 'SELECT NVL(count(1), 0), NVL(SUM(ACCTD_AMOUNT_DUE_REMAINING), 0)
3462: -- FROM ar_payment_schedules arp,
3463: -- ar_aging_bucket_lines aabl,
3464: -- hz_cust_accounts hzca
3465: -- WHERE sysdate-arp.due_date >= aabl.days_start
3466: -- and sysdate-arp.due_date <= aabl.days_to
3467: -- and arp.class = :class

Line 3547: p_bucket_line_id IN AR_AGING_BUCKET_LINES_B.Aging_Bucket_Line_Id%TYPE,

3543: x_return_status OUT NOCOPY VARCHAR2,
3544: x_msg_count OUT NOCOPY NUMBER,
3545: x_msg_data OUT NOCOPY VARCHAR2,
3546: p_filter_mode IN Varchar2,
3547: p_bucket_line_id IN AR_AGING_BUCKET_LINES_B.Aging_Bucket_Line_Id%TYPE,
3548: p_filter_id IN Number,
3549: p_customer_site_use_id IN Number,
3550: p_using_paying_rel IN VARCHAR2,
3551: x_count OUT NOCOPY Number,

Line 3588: ar_aging_bucket_lines aabl,

3584:
3585: v_cust_cnsld_sql :=
3586: 'SELECT count(distinct ocahb.id)
3587: FROM ar_payment_schedules arp,
3588: ar_aging_bucket_lines aabl,
3589: ra_customer_trx rct,
3590: okl_cnsld_ar_strms_b ocasb,
3591: OKL_CNSLD_AR_LINES_B ocalb,
3592: OKL_CNSLD_AR_HDRS_B ocahb

Line 3611: ar_aging_bucket_lines aabl,

3607: IF NVL(p_using_paying_rel, 'N') = 'Y' THEN
3608: v_party_cnsld_sql :=
3609: 'SELECT count(distinct ocahb.id)
3610: FROM ar_payment_schedules arp,
3611: ar_aging_bucket_lines aabl,
3612: ra_customer_trx rct,
3613: okl_cnsld_ar_strms_b ocasb,
3614: OKL_CNSLD_AR_LINES_B ocalb,
3615: OKL_CNSLD_AR_HDRS_B ocahb,

Line 3643: ar_aging_bucket_lines aabl,

3639: ELSE
3640: v_party_cnsld_sql :=
3641: 'SELECT count(distinct ocahb.id)
3642: FROM ar_payment_schedules arp,
3643: ar_aging_bucket_lines aabl,
3644: ra_customer_trx rct,
3645: okl_cnsld_ar_strms_b ocasb,
3646: OKL_CNSLD_AR_LINES_B ocalb,
3647: OKL_CNSLD_AR_HDRS_B ocahb,

Line 3675: ar_aging_bucket_lines aabl,

3671:
3672: v_party_billto_cnsld_sql :=
3673: 'SELECT count(distinct ocahb.id)
3674: FROM ar_payment_schedules arp,
3675: ar_aging_bucket_lines aabl,
3676: ra_customer_trx rct,
3677: okl_cnsld_ar_strms_b ocasb,
3678: OKL_CNSLD_AR_LINES_B ocalb,
3679: OKL_CNSLD_AR_HDRS_B ocahb,