[Home] [Help]
1227: prof_amts.penalty_schedule_id,
1228: site_use.last_accrue_charge_date,
1229: ps.org_id
1230: from ar_payment_schedules ps,
1231: ar_transaction_history th,
1232: ra_customer_trx trx,
1233: hz_cust_accounts cust_acct,
1234: hz_parties party,
1235: hz_customer_profiles profiles,
2243: and ps.due_date < (l_fin_charge_date - nvl(cust_site.payment_grace_days,0))
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'
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'
3113: and a.customer_trx_id = th.customer_trx_id(+)
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,
3525: ar_adjustments adj,
3526: ar_lc_cust_sites_t cust_site
4678: (ard.amount_cr * -1)))) overdue_bal,
4679: ps.org_id
4680: FROM ar_payment_schedules ps,
4681: ar_distributions ard,
4682: ar_transaction_history ath,
4683: ra_customer_trx_lines lines,
4684: ar_lc_cust_sites_t cust_site
4685: WHERE ps.customer_id = cust_site.customer_id
4686: AND cust_site.customer_site_use_id = decode(ps.class,