[Home] [Help]
551: -- get the on-account credit applied on the transaction
552: -- Fix for bug 931292
553: select nvl(sum(rec.acctd_amount_applied_from),0)*(-1)
554: into l_base_total_credits2
555: from ar_receivable_applications rec,
556: ra_customer_trx trx
557: where rec.applied_customer_trx_id = p_customer_trx_id
558: and rec.customer_trx_id = trx.customer_trx_id
559: and rec.status = 'APP'
726: nvl(sum(rec.freight_applied),0)*(-1)
727: into l_line_credits2,
728: l_tax_credits2,
729: l_freight_credits2
730: from ar_receivable_applications rec,
731: ra_customer_trx trx
732: where rec.applied_customer_trx_id = p_customer_trx_id
733: and rec.customer_trx_id = trx.customer_trx_id
734: and rec.status = 'APP'
743: into l_cm_refunds,
744: l_line_act_credits,
745: l_tax_act_credits,
746: l_freight_act_credits
747: FROM ar_receivable_applications rec
748: WHERE rec.customer_trx_id = p_customer_trx_id
749: AND rec.status = 'ACTIVITY';
750:
751:
873: l_charges_uedreceipts,
874: l_base_total_receipts,
875: l_total_discount,
876: l_base_total_discount
877: FROM ar_receivable_applications
878: WHERE applied_customer_trx_id = p_customer_trx_id
879: AND application_type = 'CASH'
880: AND NVL( confirmed_flag, 'Y' ) = 'Y';
881:
2276: ar_adjustments a
2277: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2278: and a.subsequent_trx_id IN
2279: (select cma.customer_trx_id
2280: from ar_receivable_applications cma
2281: where cma.applied_customer_trx_id =
2282: t.customer_trx_id
2283: and cma.application_type = 'CM')
2284: and ty.type not in ('DEP', 'GUAR')
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
2598: applied_customer_Trx_id = p_customer_trx_id and
2599: cash_receipt_id is not null )
2600: AND ref_customer_trx_line_id = l_customer_trx_line_id
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
2616: applied_customer_Trx_id = p_customer_trx_id and
2617: cash_receipt_id is not null )
2618: AND tax_link_id = l_customer_trx_line_id
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
2653: where status = 'APP' and
2654: applied_customer_Trx_id = p_customer_trx_id and
2655: cash_receipt_id is not null )
2656: AND ctl.link_to_cust_trx_line_id = l_customer_trx_line_id
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
2673: applied_customer_Trx_id = p_customer_trx_id and
2674: cash_receipt_id is not null )
2675: AND tax_link_id = l_customer_trx_line_id
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
2690: applied_customer_Trx_id = p_customer_trx_id and
2691: cash_receipt_id is not null )
2692: AND ref_customer_trx_line_id = l_customer_trx_line_id
2700: NVL(sum(NVL(acctd_amount_dr,0) - NVL(acctd_amount_cr,0)),0)
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'
2718: NVL(sum(NVL(acctd_amount_dr,0) - NVL(acctd_amount_cr,0)),0)
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'