[Home] [Help]
416: THEN
417: /* 07-AUG-2000 J Rautiainen BR Implementation
418: * Need to know the transaction type since
419: * the accounting is stored in ar_distributions
420: * instead of ra_cust_trx_line_gl_dist for BR */
421: SELECT ctt.accounting_affect_flag,
422: ct.exchange_rate,
423: ctt.type
424: INTO l_open_receivables_flag,
431: ELSE
432: /* 07-AUG-2000 J Rautiainen BR Implementation
433: * Need to know the transaction type since
434: * the accounting is stored in ar_distributions
435: * instead of ra_cust_trx_line_gl_dist for BR */
436: SELECT ctt.type
437: INTO l_trx_type
438: FROM ra_cust_trx_types ctt,
439: ra_customer_trx ct
476: -- for regular CM applied on the invoice
477: /* bug2324069 added nvl */
478: SELECT nvl(SUM( acctd_amount ),0)
479: INTO l_base_total_credits1
480: FROM ra_cust_trx_line_gl_dist lgd,
481: ra_customer_trx ct
482: WHERE ct.customer_trx_id = lgd.customer_trx_id
483: AND lgd.account_class = 'REC'
484: AND lgd.latest_rec_flag = 'Y'
587: 'E', null,
588: MAX( lgd.acctd_amount )
589: )
590: INTO l_base_total_original
591: FROM ra_cust_trx_line_gl_dist lgd
592: WHERE lgd.customer_trx_id = p_customer_trx_id
593: AND lgd.account_class = 'REC'
594: AND lgd.latest_rec_flag = 'Y';
595:
646: INTO l_line_credits1,
647: l_tax_credits1,
648: l_freight_credits1
649: FROM ra_customer_trx_lines ctl,
650: ra_cust_trx_line_gl_dist rec,
651: ra_customer_trx ct
652: WHERE ct.customer_trx_id = ctl.customer_trx_id
653: AND ct.customer_trx_id = rec.customer_trx_id
654: AND rec.account_class = 'REC'
1020: l_tax_credits,
1021: l_freight_credits,
1022: l_total_credits,
1023: l_base_total_original
1024: FROM ra_cust_trx_line_gl_dist lgd,
1025: ra_customer_trx_lines orig_ctl,
1026: ra_customer_trx_lines ctl,
1027: ra_customer_trx ct
1028: WHERE (