[Home] [Help]
480: THEN
481: /* 07-AUG-2000 J Rautiainen BR Implementation
482: * Need to know the transaction type since
483: * the accounting is stored in ar_distributions
484: * instead of ra_cust_trx_line_gl_dist for BR */
485: SELECT ctt.accounting_affect_flag,
486: ct.exchange_rate,
487: ctt.type
488: INTO l_open_receivables_flag,
495: ELSE
496: /* 07-AUG-2000 J Rautiainen BR Implementation
497: * Need to know the transaction type since
498: * the accounting is stored in ar_distributions
499: * instead of ra_cust_trx_line_gl_dist for BR */
500: SELECT ctt.type
501: INTO l_trx_type
502: FROM ra_cust_trx_types ctt,
503: ra_customer_trx ct
540: -- for regular CM applied on the invoice
541: /* bug2324069 added nvl */
542: SELECT nvl(SUM( acctd_amount ),0)
543: INTO l_base_total_credits1
544: FROM ra_cust_trx_line_gl_dist lgd,
545: ra_customer_trx ct
546: WHERE ct.customer_trx_id = lgd.customer_trx_id
547: AND lgd.account_class = 'REC'
548: AND lgd.latest_rec_flag = 'Y'
651: 'E', null,
652: MAX( lgd.acctd_amount )
653: )
654: INTO l_base_total_original
655: FROM ra_cust_trx_line_gl_dist lgd
656: WHERE lgd.customer_trx_id = p_customer_trx_id
657: AND lgd.account_class = 'REC'
658: AND lgd.latest_rec_flag = 'Y';
659:
710: INTO l_line_credits1,
711: l_tax_credits1,
712: l_freight_credits1
713: FROM ra_customer_trx_lines ctl,
714: ra_cust_trx_line_gl_dist rec,
715: ra_customer_trx ct
716: WHERE ct.customer_trx_id = ctl.customer_trx_id
717: AND ct.customer_trx_id = rec.customer_trx_id
718: AND rec.account_class = 'REC'
1094: l_tax_credits,
1095: l_freight_credits,
1096: l_total_credits,
1097: l_base_total_original
1098: FROM ra_cust_trx_line_gl_dist lgd,
1099: ra_customer_trx_lines orig_ctl,
1100: ra_customer_trx_lines ctl,
1101: ra_customer_trx ct
1102: WHERE (