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.AR_CMGT_DATA_POINTS_PKG dependencies on AR_AGING_BUCKET_LINES

Line 2207: ar_aging_bucket_lines age

2203:
2204: CURSOR aging_cur IS
2205: SELECT age.aging_bucket_id,age.aging_bucket_line_id
2206: FROM AR_CMGT_SETUP_OPTIONS sys,
2207: ar_aging_bucket_lines age
2208: WHERE sys.aging_bucket_id = age.aging_bucket_id;
2209:
2210: l_outstanding_balance NUMBER;
2211: l_dispute_amount NUMBER;

Line 2223: l_bucket_titletop_0 ar_aging_bucket_lines.report_heading1%TYPE;

2219: l_credit_option varchar2(16);
2220: l_invoice_type_low ra_cust_trx_types.name%TYPE;
2221: l_invoice_type_high ra_cust_trx_types.name%TYPE;
2222: l_bucket_name ar_aging_buckets.bucket_name%TYPE;
2223: l_bucket_titletop_0 ar_aging_bucket_lines.report_heading1%TYPE;
2224: l_bucket_titlebottom_0 ar_aging_bucket_lines.report_heading2%TYPE;
2225: l_bucket_amount_0 number;
2226: l_bucket_titletop_1 ar_aging_bucket_lines.report_heading1%TYPE;
2227: l_bucket_titlebottom_1 ar_aging_bucket_lines.report_heading2%TYPE;

Line 2224: l_bucket_titlebottom_0 ar_aging_bucket_lines.report_heading2%TYPE;

2220: l_invoice_type_low ra_cust_trx_types.name%TYPE;
2221: l_invoice_type_high ra_cust_trx_types.name%TYPE;
2222: l_bucket_name ar_aging_buckets.bucket_name%TYPE;
2223: l_bucket_titletop_0 ar_aging_bucket_lines.report_heading1%TYPE;
2224: l_bucket_titlebottom_0 ar_aging_bucket_lines.report_heading2%TYPE;
2225: l_bucket_amount_0 number;
2226: l_bucket_titletop_1 ar_aging_bucket_lines.report_heading1%TYPE;
2227: l_bucket_titlebottom_1 ar_aging_bucket_lines.report_heading2%TYPE;
2228: l_bucket_amount_1 number;

Line 2226: l_bucket_titletop_1 ar_aging_bucket_lines.report_heading1%TYPE;

2222: l_bucket_name ar_aging_buckets.bucket_name%TYPE;
2223: l_bucket_titletop_0 ar_aging_bucket_lines.report_heading1%TYPE;
2224: l_bucket_titlebottom_0 ar_aging_bucket_lines.report_heading2%TYPE;
2225: l_bucket_amount_0 number;
2226: l_bucket_titletop_1 ar_aging_bucket_lines.report_heading1%TYPE;
2227: l_bucket_titlebottom_1 ar_aging_bucket_lines.report_heading2%TYPE;
2228: l_bucket_amount_1 number;
2229: l_bucket_titletop_2 ar_aging_bucket_lines.report_heading1%TYPE;
2230: l_bucket_titlebottom_2 ar_aging_bucket_lines.report_heading2%TYPE;

Line 2227: l_bucket_titlebottom_1 ar_aging_bucket_lines.report_heading2%TYPE;

2223: l_bucket_titletop_0 ar_aging_bucket_lines.report_heading1%TYPE;
2224: l_bucket_titlebottom_0 ar_aging_bucket_lines.report_heading2%TYPE;
2225: l_bucket_amount_0 number;
2226: l_bucket_titletop_1 ar_aging_bucket_lines.report_heading1%TYPE;
2227: l_bucket_titlebottom_1 ar_aging_bucket_lines.report_heading2%TYPE;
2228: l_bucket_amount_1 number;
2229: l_bucket_titletop_2 ar_aging_bucket_lines.report_heading1%TYPE;
2230: l_bucket_titlebottom_2 ar_aging_bucket_lines.report_heading2%TYPE;
2231: l_bucket_amount_2 number;

Line 2229: l_bucket_titletop_2 ar_aging_bucket_lines.report_heading1%TYPE;

2225: l_bucket_amount_0 number;
2226: l_bucket_titletop_1 ar_aging_bucket_lines.report_heading1%TYPE;
2227: l_bucket_titlebottom_1 ar_aging_bucket_lines.report_heading2%TYPE;
2228: l_bucket_amount_1 number;
2229: l_bucket_titletop_2 ar_aging_bucket_lines.report_heading1%TYPE;
2230: l_bucket_titlebottom_2 ar_aging_bucket_lines.report_heading2%TYPE;
2231: l_bucket_amount_2 number;
2232: l_bucket_titletop_3 ar_aging_bucket_lines.report_heading1%TYPE;
2233: l_bucket_titlebottom_3 ar_aging_bucket_lines.report_heading2%TYPE;

Line 2230: l_bucket_titlebottom_2 ar_aging_bucket_lines.report_heading2%TYPE;

2226: l_bucket_titletop_1 ar_aging_bucket_lines.report_heading1%TYPE;
2227: l_bucket_titlebottom_1 ar_aging_bucket_lines.report_heading2%TYPE;
2228: l_bucket_amount_1 number;
2229: l_bucket_titletop_2 ar_aging_bucket_lines.report_heading1%TYPE;
2230: l_bucket_titlebottom_2 ar_aging_bucket_lines.report_heading2%TYPE;
2231: l_bucket_amount_2 number;
2232: l_bucket_titletop_3 ar_aging_bucket_lines.report_heading1%TYPE;
2233: l_bucket_titlebottom_3 ar_aging_bucket_lines.report_heading2%TYPE;
2234: l_bucket_amount_3 number;

Line 2232: l_bucket_titletop_3 ar_aging_bucket_lines.report_heading1%TYPE;

2228: l_bucket_amount_1 number;
2229: l_bucket_titletop_2 ar_aging_bucket_lines.report_heading1%TYPE;
2230: l_bucket_titlebottom_2 ar_aging_bucket_lines.report_heading2%TYPE;
2231: l_bucket_amount_2 number;
2232: l_bucket_titletop_3 ar_aging_bucket_lines.report_heading1%TYPE;
2233: l_bucket_titlebottom_3 ar_aging_bucket_lines.report_heading2%TYPE;
2234: l_bucket_amount_3 number;
2235: l_bucket_titletop_4 ar_aging_bucket_lines.report_heading1%TYPE;
2236: l_bucket_titlebottom_4 ar_aging_bucket_lines.report_heading2%TYPE;

Line 2233: l_bucket_titlebottom_3 ar_aging_bucket_lines.report_heading2%TYPE;

2229: l_bucket_titletop_2 ar_aging_bucket_lines.report_heading1%TYPE;
2230: l_bucket_titlebottom_2 ar_aging_bucket_lines.report_heading2%TYPE;
2231: l_bucket_amount_2 number;
2232: l_bucket_titletop_3 ar_aging_bucket_lines.report_heading1%TYPE;
2233: l_bucket_titlebottom_3 ar_aging_bucket_lines.report_heading2%TYPE;
2234: l_bucket_amount_3 number;
2235: l_bucket_titletop_4 ar_aging_bucket_lines.report_heading1%TYPE;
2236: l_bucket_titlebottom_4 ar_aging_bucket_lines.report_heading2%TYPE;
2237: l_bucket_amount_4 number;

Line 2235: l_bucket_titletop_4 ar_aging_bucket_lines.report_heading1%TYPE;

2231: l_bucket_amount_2 number;
2232: l_bucket_titletop_3 ar_aging_bucket_lines.report_heading1%TYPE;
2233: l_bucket_titlebottom_3 ar_aging_bucket_lines.report_heading2%TYPE;
2234: l_bucket_amount_3 number;
2235: l_bucket_titletop_4 ar_aging_bucket_lines.report_heading1%TYPE;
2236: l_bucket_titlebottom_4 ar_aging_bucket_lines.report_heading2%TYPE;
2237: l_bucket_amount_4 number;
2238: l_bucket_titletop_5 ar_aging_bucket_lines.report_heading1%TYPE;
2239: l_bucket_titlebottom_5 ar_aging_bucket_lines.report_heading2%TYPE;

Line 2236: l_bucket_titlebottom_4 ar_aging_bucket_lines.report_heading2%TYPE;

2232: l_bucket_titletop_3 ar_aging_bucket_lines.report_heading1%TYPE;
2233: l_bucket_titlebottom_3 ar_aging_bucket_lines.report_heading2%TYPE;
2234: l_bucket_amount_3 number;
2235: l_bucket_titletop_4 ar_aging_bucket_lines.report_heading1%TYPE;
2236: l_bucket_titlebottom_4 ar_aging_bucket_lines.report_heading2%TYPE;
2237: l_bucket_amount_4 number;
2238: l_bucket_titletop_5 ar_aging_bucket_lines.report_heading1%TYPE;
2239: l_bucket_titlebottom_5 ar_aging_bucket_lines.report_heading2%TYPE;
2240: l_bucket_amount_5 number;

Line 2238: l_bucket_titletop_5 ar_aging_bucket_lines.report_heading1%TYPE;

2234: l_bucket_amount_3 number;
2235: l_bucket_titletop_4 ar_aging_bucket_lines.report_heading1%TYPE;
2236: l_bucket_titlebottom_4 ar_aging_bucket_lines.report_heading2%TYPE;
2237: l_bucket_amount_4 number;
2238: l_bucket_titletop_5 ar_aging_bucket_lines.report_heading1%TYPE;
2239: l_bucket_titlebottom_5 ar_aging_bucket_lines.report_heading2%TYPE;
2240: l_bucket_amount_5 number;
2241: l_bucket_titletop_6 ar_aging_bucket_lines.report_heading1%TYPE;
2242: l_bucket_titlebottom_6 ar_aging_bucket_lines.report_heading2%TYPE;

Line 2239: l_bucket_titlebottom_5 ar_aging_bucket_lines.report_heading2%TYPE;

2235: l_bucket_titletop_4 ar_aging_bucket_lines.report_heading1%TYPE;
2236: l_bucket_titlebottom_4 ar_aging_bucket_lines.report_heading2%TYPE;
2237: l_bucket_amount_4 number;
2238: l_bucket_titletop_5 ar_aging_bucket_lines.report_heading1%TYPE;
2239: l_bucket_titlebottom_5 ar_aging_bucket_lines.report_heading2%TYPE;
2240: l_bucket_amount_5 number;
2241: l_bucket_titletop_6 ar_aging_bucket_lines.report_heading1%TYPE;
2242: l_bucket_titlebottom_6 ar_aging_bucket_lines.report_heading2%TYPE;
2243: l_bucket_amount_6 number;

Line 2241: l_bucket_titletop_6 ar_aging_bucket_lines.report_heading1%TYPE;

2237: l_bucket_amount_4 number;
2238: l_bucket_titletop_5 ar_aging_bucket_lines.report_heading1%TYPE;
2239: l_bucket_titlebottom_5 ar_aging_bucket_lines.report_heading2%TYPE;
2240: l_bucket_amount_5 number;
2241: l_bucket_titletop_6 ar_aging_bucket_lines.report_heading1%TYPE;
2242: l_bucket_titlebottom_6 ar_aging_bucket_lines.report_heading2%TYPE;
2243: l_bucket_amount_6 number;
2244: l_outstanding_amount number;
2245:

Line 2242: l_bucket_titlebottom_6 ar_aging_bucket_lines.report_heading2%TYPE;

2238: l_bucket_titletop_5 ar_aging_bucket_lines.report_heading1%TYPE;
2239: l_bucket_titlebottom_5 ar_aging_bucket_lines.report_heading2%TYPE;
2240: l_bucket_amount_5 number;
2241: l_bucket_titletop_6 ar_aging_bucket_lines.report_heading1%TYPE;
2242: l_bucket_titlebottom_6 ar_aging_bucket_lines.report_heading2%TYPE;
2243: l_bucket_amount_6 number;
2244: l_outstanding_amount number;
2245:
2246: l_check_flag VARCHAR2(1);