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_RAXSKI_XMLP_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 300: from ra_cust_trx_line_gl_dist b,

296:
297: select sum(nvl(b.acctd_amount,0)),
298: NVL( count( distinct ( a.customer_trx_id )), 0 )
299: into current_inv_sum_t, current_inv_period_t
300: from ra_cust_trx_line_gl_dist b,
301: ra_customer_trx a,
302: ra_cust_trx_types c
303: where complete_flag = 'Y'
304: and c.type in ('INV','DM','DEP','CB')

Line 322: from ra_cust_trx_line_gl_dist b,

318:
319: select sum(nvl(b.acctd_amount,0)) amount,
320: nvl(count(distinct(a.customer_trx_id)),0) trx_id
321: into current_inv_sum1, current_inv_period1
322: from ra_cust_trx_line_gl_dist b,
323: ra_customer_trx a,
324: ra_cust_trx_types c
325: where complete_flag = 'Y'
326: and c.type in ('INV','DM','DEP','CB')

Line 342: from ra_cust_trx_line_gl_dist b,

338:
339: select sum(nvl(b.acctd_amount,0)) amount,
340: nvl(count(distinct(a.customer_trx_id)),0) trx_id
341: into current_inv_sum2, current_inv_period2
342: from ra_cust_trx_line_gl_dist b,
343: ra_customer_trx a,
344: ra_cust_trx_types c
345: where complete_flag = 'Y'
346: and c.type in ('INV','DM','DEP','CB')

Line 377: from ra_cust_trx_line_gl_dist b,

373:
374: select sum(nvl(b.acctd_amount,0)),
375: NVL( count( distinct ( a.customer_trx_id )), 0 )
376: into prior_inv_sum_t, prior_inv_period_t
377: from ra_cust_trx_line_gl_dist b,
378: ra_customer_trx a,
379: ra_cust_trx_types c
380: where complete_flag = 'Y'
381: and c.type in ('INV','DM','DEP','CB')

Line 398: from ra_cust_trx_line_gl_dist b,

394:
395: select sum(nvl(b.acctd_amount,0)) amount,
396: nvl(count(distinct(a.customer_trx_id)),0) trx_id
397: into prior_inv_sum1, prior_inv_period1
398: from ra_cust_trx_line_gl_dist b,
399: ra_customer_trx a,
400: ra_cust_trx_types c
401: where complete_flag = 'Y'
402: and c.type in ('INV','DM','DEP','CB')

Line 418: from ra_cust_trx_line_gl_dist b,

414:
415: select sum(nvl(b.acctd_amount,0)) amount,
416: nvl(count(distinct(a.customer_trx_id)),0) trx_id
417: into prior_inv_sum2, prior_inv_period2
418: from ra_cust_trx_line_gl_dist b,
419: ra_customer_trx a,
420: ra_cust_trx_types c
421: where complete_flag = 'Y'
422: and c.type in ('INV','DM','DEP','CB')

Line 530: from ra_cust_trx_line_gl_dist gld,

526: select NVL( count( distinct( a.customer_trx_id )), 0),
527: sum(gld.acctd_amount)
528: --into current_period, current_sum
529: into current_period_t, current_sum_t
530: from ra_cust_trx_line_gl_dist gld,
531: ra_customer_trx a,
532: ra_cust_trx_types c
533: where complete_flag = 'Y'
534: and c.type = 'CM'

Line 551: from ra_cust_trx_line_gl_dist gld,

547:
548: select nvl(count( distinct (a.customer_trx_id)),0) cust_trx_id,
549: sum(nvl(gld.acctd_amount,0)) amount
550: into current_period1, current_sum1
551: from ra_cust_trx_line_gl_dist gld,
552: ra_customer_trx a,
553: ra_cust_trx_types c
554: where complete_flag = 'Y'
555: and c.type = 'CM'

Line 571: from ra_cust_trx_line_gl_dist gld,

567:
568: select nvl(count( distinct (a.customer_trx_id)),0) cust_trx_id,
569: sum(nvl(gld.acctd_amount,0)) amount
570: into current_period2, current_sum2
571: from ra_cust_trx_line_gl_dist gld,
572: ra_customer_trx a,
573: ra_cust_trx_types c
574: where complete_flag = 'Y'
575: and c.type = 'CM'

Line 607: from ra_cust_trx_line_gl_dist gld,

603: select NVL( count( distinct( a.customer_trx_id )), 0),
604: sum(gld.acctd_amount)
605: --into prior_period, prior_sum
606: into prior_period_t, prior_sum_t
607: from ra_cust_trx_line_gl_dist gld,
608: ra_customer_trx a,
609: ra_cust_trx_types c
610: where complete_flag = 'Y'
611: and c.type = 'CM'

Line 629: from ra_cust_trx_line_gl_dist gld,

625:
626: select nvl(count(distinct(a.customer_trx_id)),0) cust_trx_id,
627: sum(nvl(gld.acctd_amount ,0)) amount
628: into prior_period1, prior_sum1
629: from ra_cust_trx_line_gl_dist gld,
630: ra_customer_trx a,
631: ra_cust_trx_types c
632: where complete_flag = 'Y'
633: and c.type = 'CM'

Line 648: from ra_cust_trx_line_gl_dist gld,

644:
645: select nvl(count(distinct(a.customer_trx_id)),0) cust_trx_id,
646: sum(nvl(gld.acctd_amount,0)) amount
647: into prior_period2, prior_sum2
648: from ra_cust_trx_line_gl_dist gld,
649: ra_customer_trx a,
650: ra_cust_trx_types c
651: where complete_flag = 'Y'
652: and c.type = 'CM'