[Home] [Help]
973: '',sp.finchrg_receivables_trx_id,
974: rsu_bt.finchrg_receivables_trx_id),
975: rsu_st.finchrg_receivables_trx_id
976: )
977: from ra_customer_trx ctrx,
978: hz_cust_site_uses rsu_st,
979: hz_cust_site_uses rsu_bt,
980: ar_system_parameters sp
981: where ctrx.customer_trx_id = p_customer_trx_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,
1627: hz_cust_profile_amts prof_amts,
1880: l_fin_charge_date,
1881: 'CM',
1882: 'Y') balance_due
1883: from ar_payment_schedules ps,
1884: ra_customer_trx trx,
1885: ra_cust_trx_types types,
1886: ar_lc_cust_sites_t cust_site,
1887: ar_late_charge_cust_balance_gt bal
1888: where ps.customer_id = cust_site.customer_id
2641: and nvl(cust_site.charge_begin_date,ps.due_date) <= ps.due_date
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
3506: and decode(ps.class,
3507: 'PMT',ps.trx_date,
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
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
3935: from ar_payment_schedules ps,
3936: ar_adjustments adj,
4923: * ps.amount_due_remaining) overdue_bal,
4924: ps.org_id
4925: FROM ar_payment_schedules_all ps,
4926: ar_lc_cust_sites_t cust_site,
4927: ra_customer_trx ct,
4928: ra_cust_trx_types typ
4929: WHERE ps.customer_id = cust_site.customer_id
4930: AND ps.customer_trx_id = ct.customer_trx_id --Bug12884574
4931: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
4963: FROM ar_payment_schedules ps,
4964: ar_receivable_applications ra,
4965: ar_payment_schedules ps_cm_cr,
4966: ar_lc_cust_sites_t cust_site,
4967: ra_customer_trx ct,
4968: ra_cust_trx_types typ
4969: WHERE ps.customer_id = cust_site.customer_id
4970: AND ct.customer_trx_id = ps.customer_trx_id --Bug12884574
4971: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
5009: FROM ar_payment_schedules ps,
5010: ar_receivable_applications ra,
5011: ar_payment_schedules ps_cm_cr,
5012: ar_lc_cust_sites_t cust_site,
5013: ra_customer_trx ct,
5014: ra_cust_trx_types typ
5015: WHERE ps.customer_id = cust_site.customer_id
5016: AND ct.customer_trx_id = ps.customer_trx_id --Bug12884574
5017: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
5052: ps.org_id
5053: FROM ar_payment_schedules ps,
5054: ar_receivable_applications ra,
5055: ar_lc_cust_sites_t cust_site,
5056: ra_customer_trx ct,
5057: ra_cust_trx_types typ
5058: WHERE ps.customer_id = cust_site.customer_id
5059: AND ct.customer_trx_id = ps.customer_trx_id --Bug12884574
5060: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
5094: ps.org_id
5095: FROM ar_adjustments adj ,
5096: ar_payment_schedules ps,
5097: ar_lc_cust_sites_t cust_site,
5098: ra_customer_trx ct,
5099: ra_cust_trx_types typ
5100: WHERE ps.customer_id = cust_site.customer_id
5101: AND ct.customer_trx_id = ps.customer_trx_id --Bug12884574
5102: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
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
5173: WHERE ps.customer_id = cust_site.customer_id
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
5173: WHERE ps.customer_id = cust_site.customer_id
5174: AND ps.customer_trx_id = ct.customer_trx_id --Bug12884574
5175: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574