[Home] [Help]
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')
305: and a.cust_trx_type_id = inv_type
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')
327: and a.cust_trx_type_id = inv_type
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')
347: and a.cust_trx_type_id = inv_type
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')
382: and a.cust_trx_type_id = inv_type
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')
403: and a.cust_trx_type_id = inv_type
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')
423: and a.cust_trx_type_id = inv_type
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'
535: and nvl(a.reason_code,'0') = reason
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'
556: and nvl(a.reason_code,'0') = reason
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'
576: and nvl(a.reason_code,'0') = reason
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'
612: and nvl(a.reason_code,'0') = reason
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'
634: and nvl(a.reason_code,'0') = reason
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'
653: and nvl(a.reason_code,'0') = reason