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.ARP_CUSTOMER_AGING dependencies on RA_CUST_TRX_TYPES

Line 228: from ra_cust_trx_types,

224: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
225: decode(v_bucket_category,
226: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
227: 1))) b6
228: from ra_cust_trx_types,
229: ar_payment_schedules ps
230: where ps.gl_date <= p_as_of_date
231: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
232: and ps.gl_date_closed > p_as_of_date

Line 231: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id

227: 1))) b6
228: from ra_cust_trx_types,
229: ar_payment_schedules ps
230: where ps.gl_date <= p_as_of_date
231: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
232: and ps.gl_date_closed > p_as_of_date
233: and ps.customer_id = p_customer_id
234: and decode(p_customer_site_use_id,
235: NULL, ps.customer_site_use_id,

Line 247: NULL, ra_cust_trx_types.name,

243: and decode(upper(p_credit_option),
244: 'AGE', 'dummy','SUMMARY','dummy',
245: 'PMT') <> ps.class
246: and decode(p_invoice_type_low,
247: NULL, ra_cust_trx_types.name,
248: p_invoice_type_low) <= ra_cust_trx_types.name
249: and decode(p_invoice_type_high,
250: NULL, ra_cust_trx_types.name,
251: p_invoice_type_high) >= ra_cust_trx_types.name

Line 248: p_invoice_type_low) <= ra_cust_trx_types.name

244: 'AGE', 'dummy','SUMMARY','dummy',
245: 'PMT') <> ps.class
246: and decode(p_invoice_type_low,
247: NULL, ra_cust_trx_types.name,
248: p_invoice_type_low) <= ra_cust_trx_types.name
249: and decode(p_invoice_type_high,
250: NULL, ra_cust_trx_types.name,
251: p_invoice_type_high) >= ra_cust_trx_types.name
252: UNION ALL

Line 250: NULL, ra_cust_trx_types.name,

246: and decode(p_invoice_type_low,
247: NULL, ra_cust_trx_types.name,
248: p_invoice_type_low) <= ra_cust_trx_types.name
249: and decode(p_invoice_type_high,
250: NULL, ra_cust_trx_types.name,
251: p_invoice_type_high) >= ra_cust_trx_types.name
252: UNION ALL
253: select -sum(decode(p_currency_code, NULL, app.acctd_amount_applied_from,
254: app.amount_applied)),

Line 251: p_invoice_type_high) >= ra_cust_trx_types.name

247: NULL, ra_cust_trx_types.name,
248: p_invoice_type_low) <= ra_cust_trx_types.name
249: and decode(p_invoice_type_high,
250: NULL, ra_cust_trx_types.name,
251: p_invoice_type_high) >= ra_cust_trx_types.name
252: UNION ALL
253: select -sum(decode(p_currency_code, NULL, app.acctd_amount_applied_from,
254: app.amount_applied)),
255: decode(v_bucket_line_type_0,

Line 767: ra_cust_trx_types rctt

763: decode(v_bucket_category,
764: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
765: 1))) b6
766: from ar_payment_schedules ps,
767: ra_cust_trx_types rctt
768: where ps.gl_date <= p_as_of_date
769: and ps.gl_date_closed > p_as_of_date
770: and ps.cust_trx_type_id = rctt.cust_trx_type_id
771: and ps.customer_id = p_customer_id

Line 1289: from ra_cust_trx_types,

1285: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
1286: decode(v_bucket_category,
1287: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
1288: 1))) b6
1289: from ra_cust_trx_types,
1290: ar_payment_schedules ps
1291: where ps.gl_date <= p_as_of_date
1292: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
1293: and ps.gl_date_closed > p_as_of_date

Line 1292: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id

1288: 1))) b6
1289: from ra_cust_trx_types,
1290: ar_payment_schedules ps
1291: where ps.gl_date <= p_as_of_date
1292: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
1293: and ps.gl_date_closed > p_as_of_date
1294: and ps.customer_id = p_customer_id
1295: and ps.customer_site_use_id = p_customer_site_use_id
1296: and decode(upper(p_currency_code),

Line 1306: NULL, ra_cust_trx_types.name,

1302: and decode(upper(p_credit_option),
1303: 'AGE', 'dummy', 'SUMMARY','dummy',
1304: 'PMT') <> ps.class
1305: and decode(p_invoice_type_low,
1306: NULL, ra_cust_trx_types.name,
1307: p_invoice_type_low) <= ra_cust_trx_types.name
1308: and decode(p_invoice_type_high,
1309: NULL, ra_cust_trx_types.name,
1310: p_invoice_type_high) >= ra_cust_trx_types.name

Line 1307: p_invoice_type_low) <= ra_cust_trx_types.name

1303: 'AGE', 'dummy', 'SUMMARY','dummy',
1304: 'PMT') <> ps.class
1305: and decode(p_invoice_type_low,
1306: NULL, ra_cust_trx_types.name,
1307: p_invoice_type_low) <= ra_cust_trx_types.name
1308: and decode(p_invoice_type_high,
1309: NULL, ra_cust_trx_types.name,
1310: p_invoice_type_high) >= ra_cust_trx_types.name
1311: UNION ALL

Line 1309: NULL, ra_cust_trx_types.name,

1305: and decode(p_invoice_type_low,
1306: NULL, ra_cust_trx_types.name,
1307: p_invoice_type_low) <= ra_cust_trx_types.name
1308: and decode(p_invoice_type_high,
1309: NULL, ra_cust_trx_types.name,
1310: p_invoice_type_high) >= ra_cust_trx_types.name
1311: UNION ALL
1312: select -sum(decode(p_currency_code, NULL, app.acctd_amount_applied_from,
1313: app.amount_applied)),

Line 1310: p_invoice_type_high) >= ra_cust_trx_types.name

1306: NULL, ra_cust_trx_types.name,
1307: p_invoice_type_low) <= ra_cust_trx_types.name
1308: and decode(p_invoice_type_high,
1309: NULL, ra_cust_trx_types.name,
1310: p_invoice_type_high) >= ra_cust_trx_types.name
1311: UNION ALL
1312: select -sum(decode(p_currency_code, NULL, app.acctd_amount_applied_from,
1313: app.amount_applied)),
1314: decode(v_bucket_line_type_0,

Line 1819: ra_cust_trx_types rctt

1815: decode(v_bucket_category,
1816: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
1817: 1))) b6
1818: from ar_payment_schedules ps,
1819: ra_cust_trx_types rctt
1820: where ps.gl_date <= p_as_of_date
1821: and ps.gl_date_closed > p_as_of_date
1822: and ps.cust_trx_type_id = rctt.cust_trx_type_id
1823: and ps.customer_id = p_customer_id

Line 2337: from ra_cust_trx_types,

2333: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
2334: decode(v_bucket_category,
2335: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
2336: 1))) b6
2337: from ra_cust_trx_types,
2338: ar_payment_schedules ps
2339: where ps.gl_date <= p_as_of_date
2340: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
2341: and ps.gl_date_closed > p_as_of_date

Line 2340: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id

2336: 1))) b6
2337: from ra_cust_trx_types,
2338: ar_payment_schedules ps
2339: where ps.gl_date <= p_as_of_date
2340: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
2341: and ps.gl_date_closed > p_as_of_date
2342: and ps.customer_id = p_customer_id
2343: and decode(upper(p_currency_code),
2344: NULL, ps.invoice_currency_code,

Line 2353: NULL, ra_cust_trx_types.name,

2349: and decode(upper(p_credit_option),
2350: 'AGE', 'dummy', 'SUMMARY','dummy',
2351: 'PMT') <> ps.class
2352: and decode(p_invoice_type_low,
2353: NULL, ra_cust_trx_types.name,
2354: p_invoice_type_low) <= ra_cust_trx_types.name
2355: and decode(p_invoice_type_high,
2356: NULL, ra_cust_trx_types.name,
2357: p_invoice_type_high) >= ra_cust_trx_types.name

Line 2354: p_invoice_type_low) <= ra_cust_trx_types.name

2350: 'AGE', 'dummy', 'SUMMARY','dummy',
2351: 'PMT') <> ps.class
2352: and decode(p_invoice_type_low,
2353: NULL, ra_cust_trx_types.name,
2354: p_invoice_type_low) <= ra_cust_trx_types.name
2355: and decode(p_invoice_type_high,
2356: NULL, ra_cust_trx_types.name,
2357: p_invoice_type_high) >= ra_cust_trx_types.name
2358: UNION ALL

Line 2356: NULL, ra_cust_trx_types.name,

2352: and decode(p_invoice_type_low,
2353: NULL, ra_cust_trx_types.name,
2354: p_invoice_type_low) <= ra_cust_trx_types.name
2355: and decode(p_invoice_type_high,
2356: NULL, ra_cust_trx_types.name,
2357: p_invoice_type_high) >= ra_cust_trx_types.name
2358: UNION ALL
2359: select nvl(-sum(decode(p_currency_code, NULL, app.amount_applied,
2360: app.acctd_amount_applied_from)),0) amount_due_remaining,

Line 2357: p_invoice_type_high) >= ra_cust_trx_types.name

2353: NULL, ra_cust_trx_types.name,
2354: p_invoice_type_low) <= ra_cust_trx_types.name
2355: and decode(p_invoice_type_high,
2356: NULL, ra_cust_trx_types.name,
2357: p_invoice_type_high) >= ra_cust_trx_types.name
2358: UNION ALL
2359: select nvl(-sum(decode(p_currency_code, NULL, app.amount_applied,
2360: app.acctd_amount_applied_from)),0) amount_due_remaining,
2361: decode(v_bucket_line_type_0,