[Home] [Help]
415: )
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
430: AND ct.customer_trx_id = p_customer_trx_id;
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,
569: MAX( dist.acctd_amount_dr )
570: )
571: INTO l_base_total_original
572: FROM ar_transaction_history trh,
573: ar_distributions dist
574: WHERE trh.customer_trx_id = p_customer_trx_id
575: AND trh.first_posted_record_flag = 'Y'
576: AND dist.source_id = trh.transaction_history_id
577: AND dist.source_table = 'TH'
2502: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2503: INTO
2504: l_line_receipts,
2505: l_base_line_receipts
2506: FROM ar_distributions
2507: WHERE source_table = 'RA'
2508: AND source_id in (select receivable_application_id
2509: from ar_receivable_applications
2510: where status = 'APP' and
2520: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2521: INTO
2522: l_tax_receipts,
2523: l_base_tax_receipts
2524: FROM ar_distributions
2525: WHERE source_table = 'RA'
2526: AND source_id in (select receivable_application_id
2527: from ar_receivable_applications
2528: where status = 'APP' and
2557: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2558: INTO
2559: l_freight_receipts,
2560: l_base_freight_receipts
2561: FROM ar_distributions ard,
2562: ra_customer_trx_lines ctl
2563: WHERE ard.source_table = 'RA'
2564: AND ard.source_id in (select receivable_application_id
2565: from ar_receivable_applications
2577: NVL(sum(NVL(acctd_amount_dr,0) - NVL(acctd_amount_cr,0)),0)
2578: INTO
2579: l_tax_discount,
2580: l_base_tax_discount
2581: FROM ar_distributions
2582: WHERE source_table = 'RA'
2583: AND source_id in (select receivable_application_id
2584: from ar_receivable_applications
2585: where status = 'APP' and
2594: NVL(sum(NVL(acctd_amount_dr,0) - NVL(acctd_amount_cr,0)),0)
2595: INTO
2596: l_line_discount,
2597: l_base_line_discount
2598: FROM ar_distributions
2599: WHERE source_table = 'RA'
2600: AND source_id in (select receivable_application_id
2601: from ar_receivable_applications
2602: where status = 'APP' and
2613: INTO
2614: l_line_credits,
2615: l_base_line_credits
2616: from ar_receivable_applications rec,
2617: ar_distributions dist
2618: where rec.applied_customer_trx_id = p_customer_trx_id
2619: and dist.ref_customer_trx_line_id = l_customer_trx_line_id
2620: and rec.status = 'APP'
2621: and rec.application_type = 'CM'
2630: INTO
2631: l_tax_credits,
2632: l_base_tax_credits
2633: from ar_receivable_applications rec,
2634: ar_distributions dist
2635: where rec.applied_customer_trx_id = p_customer_trx_id
2636: and dist.ref_customer_trx_line_id = l_customer_trx_line_id
2637: and rec.status = 'APP'
2638: and rec.application_type = 'CM'
2648: SELECT NVL(sum(NVL(amount_cr,0) - NVL(amount_dr,0)),0),
2649: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2650: INTO l_line_adjustments,
2651: l_base_line_adjustments
2652: from ar_distributions dist
2653: where dist.ref_customer_trx_line_id = l_customer_trx_line_id
2654: and dist.source_table = 'ADJ'
2655: and dist.activity_bucket = 'ADJ_LINE';
2656:
2658: SELECT NVL(sum(NVL(amount_cr,0) - NVL(amount_dr,0)),0),
2659: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2660: INTO l_tax_adjustments,
2661: l_base_tax_adjustments
2662: from ar_distributions dist,
2663: ra_customer_trx_lines lines
2664: where lines.link_to_cust_trx_line_id = l_customer_trx_line_id
2665: and lines.line_type = 'TAX'
2666: and dist.ref_customer_trx_line_id = lines.customer_trx_line_id
2671: SELECT NVL(sum(NVL(amount_cr,0) - NVL(amount_dr,0)),0),
2672: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2673: INTO l_freight_adjustments,
2674: l_base_freight_adjustments
2675: from ar_distributions dist,
2676: ra_customer_trx_lines lines
2677: where lines.link_to_cust_trx_line_id = l_customer_trx_line_id
2678: and dist.ref_customer_trx_line_id = lines.link_to_cust_trx_line_id
2679: and lines.line_type = 'FREIGHT'