[Home] [Help]
2303: and b.customer_site_use_id = credits.customer_site_use_id (+)
2304: and b.invoice_currency_code = credits.currency_code (+)
2305: and b.org_id = credits.org_id (+)
2306: and b.legal_entity_id = credits.legal_entity_id(+))c,
2307: ar_charge_schedule_hdrs sched_hdrs,
2308: ar_charge_schedule_lines sched_lines,
2309: ar_aging_bucket_lines bucket_lines
2310: where c.interest_schedule_id = sched_hdrs.schedule_id(+)
2311: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
3171: a.last_accrue_charge_date)))),
3172: decode(a.interest_calculation_period,
3173: 'DAILY',a.due_date,
3174: 'MONTHLY',first_day(a.due_date)))b,
3175: ar_charge_schedule_hdrs sched_hdrs,
3176: ar_charge_schedule_lines sched_lines,
3177: ar_aging_bucket_lines bucket_lines
3178: where b.interest_schedule_id = sched_hdrs.schedule_id(+)
3179: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
3649: decode(cust_site.interest_calculation_period,
3650: 'DAILY',ps.due_date,
3651: 'MONTHLY',first_day(ps.due_date)),
3652: cust_site.late_charge_calculation_trx) a,
3653: ar_charge_schedule_hdrs sched_hdrs,
3654: ar_charge_schedule_lines sched_lines,
3655: ar_aging_bucket_lines bucket_lines
3656: where a.interest_schedule_id = sched_hdrs.schedule_id(+)
3657: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
4917: decode(trx.charge_type,'AVERAGE_DAILY_BALANCE',trx.charge_type, NULL) charge_type,
4918: cust_site.penalty_type
4919: from ar_lc_cust_sites_t cust_site,
4920: ar_late_charge_trx_t trx,
4921: ar_charge_schedule_hdrs sched_hdrs,
4922: ar_charge_schedule_lines sched_lines,
4923: ar_aging_bucket_lines bucket_lines
4924: where cust_site.customer_id = trx.customer_id
4925: and cust_site.customer_site_use_id = trx.customer_site_use_id