[Home] [Help]
1440: cr.currency_code,
1441: cr.legal_entity_id,
1442: cr.org_id,
1443: -1* ps.amount_due_remaining balance_due
1444: from ar_cash_receipts cr,
1445: ar_payment_schedules ps,
1446: ar_lc_cust_sites_t cust_site,
1447: ar_late_charge_cust_balance_gt bal
1448: where ps.actual_date_closed > l_fin_charge_date
2245: and nvl(ps.receipt_confirmed_flag, 'Y') = 'Y') a,
2246: ra_customer_trx trx,
2247: ar_transaction_history th,
2248: ra_cust_trx_types types,
2249: ar_cash_receipts cr
2250: where trx.customer_trx_id(+) = a.customer_trx_id
2251: and nvl(trx.finance_charges,decode(a.class,'DEP','N','Y')) = 'Y'
2252: and a.customer_trx_id = th.customer_trx_id(+)
2253: and nvl(th.current_record_flag,'Y') = 'Y'
3106: and nvl(ps.receipt_confirmed_flag, 'Y') = 'Y') a,
3107: ra_customer_trx trx,
3108: ra_cust_trx_types types,
3109: ar_transaction_history th,
3110: ar_cash_receipts cr
3111: where trx.customer_trx_id(+) = a.customer_trx_id
3112: and nvl(trx.finance_charges,decode(a.class,'DEP','N','Y')) = 'Y'
3113: and a.customer_trx_id = th.customer_trx_id(+)
3114: and nvl(th.current_record_flag,'Y') = 'Y'
3515: from ar_payment_schedules ps,
3516: ar_lc_cust_sites_t cust_site,
3517: ar_late_charge_cust_balance_gt bal,
3518: ar_receivable_applications app,
3519: ar_cash_receipts cr,
3520: ra_cust_trx_types types,
3521: ra_customer_trx trx,
3522: ar_transaction_history th,
3523: (select ps.payment_schedule_id ,sum(adj.amount) fin_charge_charged