[Home] [Help]
1618: prof_amts.penalty_schedule_id,
1619: site_use.last_accrue_charge_date,
1620: ps.org_id
1621: from ar_payment_schedules ps,
1622: ar_transaction_history th,
1623: ra_customer_trx trx,
1624: hz_cust_accounts cust_acct,
1625: hz_parties party,
1626: hz_customer_profiles profiles,
2642: and ps.due_date < (l_fin_charge_date - nvl(cust_site.payment_grace_days,0))
2643: and nvl(ps.last_charge_date,l_fin_charge_date-1) < 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'
3508: 'CM',ps.trx_date,ps.due_date) <= l_fin_charge_date
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(+)
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
3935: from ar_payment_schedules ps,
3936: ar_adjustments adj,
3937: ar_lc_cust_sites_t cust_site
5164: (ard.amount_cr * -1)))) overdue_bal,
5165: ps.org_id
5166: FROM ar_payment_schedules ps,
5167: ar_distributions ard,
5168: ar_transaction_history ath,
5169: ra_customer_trx_lines lines,
5170: ar_lc_cust_sites_t cust_site,
5171: ra_customer_trx ct,
5172: ra_cust_trx_types typ