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 RA_CUST_TRX_TYPES

Line 291: from ra_cust_trx_types,

287: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
288: decode(v_bucket_category,
289: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
290: 1))) b6
291: from ra_cust_trx_types,
292: ar_payment_schedules ps
293: where ps.gl_date <= p_as_of_date
294: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
295: and ps.gl_date_closed > p_as_of_date

Line 294: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id

290: 1))) b6
291: from ra_cust_trx_types,
292: ar_payment_schedules ps
293: where ps.gl_date <= p_as_of_date
294: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
295: and ps.gl_date_closed > p_as_of_date
296: and ps.customer_id = p_customer_id
297: and ra_cust_trx_types.org_id= ps.org_id --Added for Bug 9902108 03-Aug-2010 barathsr
298: and decode(p_customer_site_use_id,

Line 297: and ra_cust_trx_types.org_id= ps.org_id --Added for Bug 9902108 03-Aug-2010 barathsr

293: where ps.gl_date <= p_as_of_date
294: and ps.cust_trx_type_id = ra_cust_trx_types.cust_trx_type_id
295: and ps.gl_date_closed > p_as_of_date
296: and ps.customer_id = p_customer_id
297: and ra_cust_trx_types.org_id= ps.org_id --Added for Bug 9902108 03-Aug-2010 barathsr
298: and decode(p_customer_site_use_id,
299: NULL, ps.customer_site_use_id,
300: p_customer_site_use_id) = ps.customer_site_use_id
301: and decode(upper(p_currency_code),

Line 311: NULL, ra_cust_trx_types.name,

307: and decode(upper(p_credit_option),
308: 'AGE', 'dummy',
309: 'PMT') <> ps.class
310: and decode(p_invoice_type_low,
311: NULL, ra_cust_trx_types.name,
312: p_invoice_type_low) <= ra_cust_trx_types.name
313: and decode(p_invoice_type_high,
314: NULL, ra_cust_trx_types.name,
315: p_invoice_type_high) >= ra_cust_trx_types.name

Line 312: p_invoice_type_low) <= ra_cust_trx_types.name

308: 'AGE', 'dummy',
309: 'PMT') <> ps.class
310: and decode(p_invoice_type_low,
311: NULL, ra_cust_trx_types.name,
312: p_invoice_type_low) <= ra_cust_trx_types.name
313: and decode(p_invoice_type_high,
314: NULL, ra_cust_trx_types.name,
315: p_invoice_type_high) >= ra_cust_trx_types.name
316: AND PS.STATUS = 'OP' -- bug 14085877

Line 314: NULL, ra_cust_trx_types.name,

310: and decode(p_invoice_type_low,
311: NULL, ra_cust_trx_types.name,
312: p_invoice_type_low) <= ra_cust_trx_types.name
313: and decode(p_invoice_type_high,
314: NULL, ra_cust_trx_types.name,
315: p_invoice_type_high) >= ra_cust_trx_types.name
316: AND PS.STATUS = 'OP' -- bug 14085877
317: UNION ALL
318: select -sum(decode(p_currency_code, NULL, app.acctd_amount_applied_from,

Line 315: p_invoice_type_high) >= ra_cust_trx_types.name

311: NULL, ra_cust_trx_types.name,
312: p_invoice_type_low) <= ra_cust_trx_types.name
313: and decode(p_invoice_type_high,
314: NULL, ra_cust_trx_types.name,
315: p_invoice_type_high) >= ra_cust_trx_types.name
316: AND PS.STATUS = 'OP' -- bug 14085877
317: UNION ALL
318: select -sum(decode(p_currency_code, NULL, app.acctd_amount_applied_from,
319: app.amount_applied)),