[Home] [Help]
266: NULL LAST_RECEIPT_NUMBER,
267: 0 PENDING_ADJ_AMT
268: FROM AR_CASH_RECEIPTS_ALL CR,
269: AR_CASH_RECEIPT_HISTORY_ALL CRH,
270: AR_RECEIVABLE_APPLICATIONS_ALL RAP
271: WHERE NVL(CR.CONFIRMED_FLAG, 'Y') = 'Y'
272: AND CR.REVERSAL_DATE IS NULL
273: AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
274: AND CR.PAY_FROM_CUSTOMER > 0
465: sum(decode(ps.class, 'INV',
466: decode(ra.unearned_discount_taken,0,
467: null,ra.unearned_discount_taken), null)) unedisc_taken
468: FROM AR_PAYMENT_SCHEDULES_all ps,
469: AR_RECEIVABLE_APPLICATIONS_ALL RA,
470: ( select history_id, payment_schedule_id, due_date, amount_in_dispute
471: from ar_trx_summary_hist
472: where history_id in
473: (select max(history_id)
625: where nvl(complete_flag,'N') = 'N'
626: and creation_date <= l_program_start_date
627: group by payment_schedule_id)) TRX_HIST,
628: ra_terms_b rt,
629: ar_receivable_applications_all ra
630: where ps.payment_schedule_id = ra.applied_payment_schedule_id
631: and trx_hist.payment_schedule_id(+) = ps.payment_schedule_id
632: and ps.customer_id > 0
633: and ps.term_id = rt.term_id(+)
885: sum(-ra.amount_applied
886: -nvl(ra.earned_discount_taken,0)
887: -nvl(ra.unearned_discount_taken,0)) net_amount
888: from ar_payment_schedules_all ps,
889: ar_receivable_applications_all ra
890: where ps.payment_schedule_id = ra.applied_payment_schedule_id
891: and ps.customer_id > 0
892: and ra.status = '||''''||'APP'||''''||'
893: and nvl(ra.confirmed_flag,'||''''||'Y'||''''||') = '||''''||'Y'||''''||'
921: sum(nvl(ra.amount_applied_from, ra.amount_applied)
922: + nvl(ra.earned_discount_taken,0)
923: + nvl(ra.unearned_discount_taken,0)) net_amount
924: from ar_payment_schedules_all ps,
925: ar_receivable_applications_all ra
926: where ps.payment_schedule_id = ra.payment_schedule_id
927: and ps.class in ('||''''||'CM'||''''||')
928: and ra.status = '||''''||'APP'||''''||'
929: and nvl(ra.confirmed_flag,'||''''||'Y'||''''||') = '||''''||'Y'||''''||'