[Home] [Help]
479: )
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
494: AND ct.customer_trx_id = p_customer_trx_id;
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,
633: MAX( dist.acctd_amount_dr )
634: )
635: INTO l_base_total_original
636: FROM ar_transaction_history trh,
637: ar_distributions dist
638: WHERE trh.customer_trx_id = p_customer_trx_id
639: AND trh.first_posted_record_flag = 'Y'
640: AND dist.source_id = trh.transaction_history_id
641: AND dist.source_table = 'TH'
2589: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2590: INTO
2591: l_line_receipts,
2592: l_base_line_receipts
2593: FROM ar_distributions
2594: WHERE source_table = 'RA'
2595: AND source_id in (select receivable_application_id
2596: from ar_receivable_applications
2597: where status = 'APP' and
2607: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2608: INTO
2609: l_tax_receipts,
2610: l_base_tax_receipts
2611: FROM ar_distributions
2612: WHERE source_table = 'RA'
2613: AND source_id in (select receivable_application_id
2614: from ar_receivable_applications
2615: where status = 'APP' and
2644: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2645: INTO
2646: l_freight_receipts,
2647: l_base_freight_receipts
2648: FROM ar_distributions ard,
2649: ra_customer_trx_lines ctl
2650: WHERE ard.source_table = 'RA'
2651: AND ard.source_id in (select receivable_application_id
2652: from ar_receivable_applications
2664: NVL(sum(NVL(acctd_amount_dr,0) - NVL(acctd_amount_cr,0)),0)
2665: INTO
2666: l_tax_discount,
2667: l_base_tax_discount
2668: FROM ar_distributions
2669: WHERE source_table = 'RA'
2670: AND source_id in (select receivable_application_id
2671: from ar_receivable_applications
2672: where status = 'APP' and
2681: NVL(sum(NVL(acctd_amount_dr,0) - NVL(acctd_amount_cr,0)),0)
2682: INTO
2683: l_line_discount,
2684: l_base_line_discount
2685: FROM ar_distributions
2686: WHERE source_table = 'RA'
2687: AND source_id in (select receivable_application_id
2688: from ar_receivable_applications
2689: where status = 'APP' and
2701: INTO
2702: l_line_credits,
2703: l_base_line_credits
2704: from ar_receivable_applications rec,
2705: ar_distributions dist
2706: where rec.applied_customer_trx_id = p_customer_trx_id
2707: and dist.ref_customer_trx_line_id = l_customer_trx_line_id
2708: and rec.status = 'APP'
2709: and rec.application_type = 'CM'
2719: INTO
2720: l_tax_credits,
2721: l_base_tax_credits
2722: from ar_receivable_applications rec,
2723: ar_distributions dist
2724: where rec.applied_customer_trx_id = p_customer_trx_id
2725: and dist.ref_customer_trx_line_id = l_customer_trx_line_id
2726: and rec.status = 'APP'
2727: and rec.application_type = 'CM'
2737: SELECT NVL(sum(NVL(amount_cr,0) - NVL(amount_dr,0)),0),
2738: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2739: INTO l_line_adjustments,
2740: l_base_line_adjustments
2741: from ar_distributions dist
2742: where dist.ref_customer_trx_line_id = l_customer_trx_line_id
2743: and dist.source_table = 'ADJ'
2744: and dist.activity_bucket = 'ADJ_LINE';
2745:
2747: SELECT NVL(sum(NVL(amount_cr,0) - NVL(amount_dr,0)),0),
2748: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2749: INTO l_tax_adjustments,
2750: l_base_tax_adjustments
2751: from ar_distributions dist,
2752: ra_customer_trx_lines lines
2753: where lines.link_to_cust_trx_line_id = l_customer_trx_line_id
2754: and lines.line_type = 'TAX'
2755: and dist.ref_customer_trx_line_id = lines.customer_trx_line_id
2760: SELECT NVL(sum(NVL(amount_cr,0) - NVL(amount_dr,0)),0),
2761: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2762: INTO l_freight_adjustments,
2763: l_base_freight_adjustments
2764: from ar_distributions dist,
2765: ra_customer_trx_lines lines
2766: where lines.link_to_cust_trx_line_id = l_customer_trx_line_id
2767: and dist.ref_customer_trx_line_id = lines.link_to_cust_trx_line_id
2768: and lines.line_type = 'FREIGHT'