[Home] [Help]
405: 'DAILY',int_lines.due_date,
406: 'MONTHLY',first_day(int_lines.due_date)) eff_due_date
407: from ar_interest_lines int_lines,
408: ar_interest_headers int_headers,
409: ar_cash_receipts cr,
410: ar_payment_schedules ps,
411: ar_lc_cust_sites_t cust_site,
412: ar_late_charge_cust_balance_gt bal
413: where ps.customer_id = cust_site.customer_id
1831: cr.currency_code,
1832: cr.legal_entity_id,
1833: cr.org_id,
1834: -1* ps.amount_due_remaining balance_due
1835: from ar_cash_receipts cr,
1836: ar_payment_schedules ps,
1837: ar_lc_cust_sites_t cust_site,
1838: ar_late_charge_cust_balance_gt bal
1839: where ps.actual_date_closed > l_fin_charge_date
2644: and nvl(ps.receipt_confirmed_flag, 'Y') = 'Y') a,
2645: ra_customer_trx trx,
2646: ar_transaction_history th,
2647: ra_cust_trx_types types,
2648: ar_cash_receipts cr
2649: where trx.customer_trx_id(+) = a.customer_trx_id
2650: and nvl(trx.finance_charges,decode(a.class,'DEP','N','Y')) = 'Y'
2651: and a.customer_trx_id = th.customer_trx_id(+)
2652: and nvl(th.current_record_flag,'Y') = 'Y'
3509: and nvl(ps.receipt_confirmed_flag, 'Y') = 'Y') a,
3510: ra_customer_trx trx,
3511: ra_cust_trx_types types,
3512: ar_transaction_history th,
3513: ar_cash_receipts cr
3514: where trx.customer_trx_id(+) = a.customer_trx_id
3515: and nvl(trx.finance_charges,decode(a.class,'DEP','N','Y')) = 'Y'
3516: and a.customer_trx_id = th.customer_trx_id(+)
3517: and nvl(th.current_record_flag,'Y') = 'Y'
3926: from ar_payment_schedules ps,
3927: ar_lc_cust_sites_t cust_site,
3928: ar_late_charge_cust_balance_gt bal,
3929: ar_receivable_applications app,
3930: ar_cash_receipts cr,
3931: ra_cust_trx_types types,
3932: ra_customer_trx trx,
3933: ar_transaction_history th,
3934: (select ps.payment_schedule_id ,sum(adj.amount) fin_charge_charged