[Home] [Help]
487: -- get the on-account credit applied on the transaction
488: -- Fix for bug 931292
489: select nvl(sum(rec.acctd_amount_applied_from),0)*(-1)
490: into l_base_total_credits2
491: from ar_receivable_applications rec,
492: ra_customer_trx trx
493: where rec.applied_customer_trx_id = p_customer_trx_id
494: and rec.customer_trx_id = trx.customer_trx_id
495: and rec.status = 'APP'
662: nvl(sum(rec.freight_applied),0)*(-1)
663: into l_line_credits2,
664: l_tax_credits2,
665: l_freight_credits2
666: from ar_receivable_applications rec,
667: ra_customer_trx trx
668: where rec.applied_customer_trx_id = p_customer_trx_id
669: and rec.customer_trx_id = trx.customer_trx_id
670: and rec.status = 'APP'
673:
674: /* Bug 4112494 CM refund total */
675: SELECT NVL(SUM(rec.amount_applied),0)
676: INTO l_cm_refunds
677: FROM ar_receivable_applications rec
678: WHERE rec.customer_trx_id = p_customer_trx_id
679: AND rec.status = 'ACTIVITY';
680:
681: l_line_credits := NVL(l_line_credits1,0) +
799: l_charges_uedreceipts,
800: l_base_total_receipts,
801: l_total_discount,
802: l_base_total_discount
803: FROM ar_receivable_applications
804: WHERE applied_customer_trx_id = p_customer_trx_id
805: AND application_type = 'CASH'
806: AND NVL( confirmed_flag, 'Y' ) = 'Y';
807:
2189: ar_adjustments a
2190: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2191: and a.subsequent_trx_id IN
2192: (select cma.customer_trx_id
2193: from ar_receivable_applications cma
2194: where cma.applied_customer_trx_id =
2195: t.customer_trx_id
2196: and cma.application_type = 'CM')
2197: and ty.type not in ('DEP', 'GUAR')
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
2511: applied_customer_Trx_id = p_customer_trx_id and
2512: cash_receipt_id is not null )
2513: AND ref_customer_trx_line_id = l_customer_trx_line_id
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
2529: applied_customer_Trx_id = p_customer_trx_id and
2530: cash_receipt_id is not null )
2531: AND tax_link_id = l_customer_trx_line_id
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
2566: where status = 'APP' and
2567: applied_customer_Trx_id = p_customer_trx_id and
2568: cash_receipt_id is not null )
2569: AND ctl.link_to_cust_trx_line_id = l_customer_trx_line_id
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
2586: applied_customer_Trx_id = p_customer_trx_id and
2587: cash_receipt_id is not null )
2588: AND tax_link_id = l_customer_trx_line_id
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
2603: applied_customer_Trx_id = p_customer_trx_id and
2604: cash_receipt_id is not null )
2605: AND ref_customer_trx_line_id = l_customer_trx_line_id
2612: NVL(sum(NVL(acctd_amount_cr,0)),0)
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'
2629: NVL(sum(NVL(acctd_amount_cr,0)),0)
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'