[Home] [Help]
1490: 'CM',
1491: 'Y') balance_due
1492: from ar_payment_schedules ps,
1493: ra_customer_trx trx,
1494: ra_cust_trx_types types,
1495: ar_lc_cust_sites_t cust_site,
1496: ar_late_charge_cust_balance_gt bal
1497: where ps.customer_id = cust_site.customer_id
1498: and ps.customer_site_use_id = cust_site.customer_site_use_id
2244: and nvl(ps.last_charge_date,l_fin_charge_date-1) < 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(+)
3104: 'PMT',ps.trx_date,
3105: 'CM',ps.trx_date,ps.due_date) <= l_fin_charge_date
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'
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
3524: from ar_payment_schedules ps,