DBA Data[Home] [Help]

APPS.AR_CALC_LATE_CHARGE dependencies on AR_CHARGE_SCHEDULE_LINES

Line 518: ar_charge_schedule_lines sched_lines,

514: 'DAILY',int_lines.due_date,
515: 'MONTHLY',first_day(int_lines.due_date))
516: ) b,
517: ar_charge_schedule_hdrs sched_hdrs,
518: ar_charge_schedule_lines sched_lines,
519: ar_aging_bucket_lines bucket_lines
520: where b.interest_schedule_id = sched_hdrs.schedule_id(+)
521: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
522: and sched_hdrs.schedule_id = sched_lines.schedule_id(+)

Line 2707: ar_charge_schedule_lines sched_lines,

2703: and b.invoice_currency_code = credits.currency_code (+)
2704: and b.org_id = credits.org_id (+)
2705: and b.legal_entity_id = credits.legal_entity_id(+))c,
2706: ar_charge_schedule_hdrs sched_hdrs,
2707: ar_charge_schedule_lines sched_lines,
2708: ar_aging_bucket_lines bucket_lines
2709: where c.interest_schedule_id = sched_hdrs.schedule_id(+)
2710: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
2711: and sched_hdrs.schedule_id = sched_lines.schedule_id(+)

Line 3579: ar_charge_schedule_lines sched_lines,

3575: decode(a.interest_calculation_period,
3576: 'DAILY',a.due_date,
3577: 'MONTHLY',first_day(a.due_date)))b,
3578: ar_charge_schedule_hdrs sched_hdrs,
3579: ar_charge_schedule_lines sched_lines,
3580: ar_aging_bucket_lines bucket_lines
3581: where b.interest_schedule_id = sched_hdrs.schedule_id(+)
3582: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
3583: and sched_hdrs.schedule_id = sched_lines.schedule_id(+)

Line 4067: ar_charge_schedule_lines sched_lines,

4063: 'MONTHLY',first_day(ps.due_date)),
4064: cust_site.late_charge_calculation_trx,
4065: cr.cash_receipt_id) a,
4066: ar_charge_schedule_hdrs sched_hdrs,
4067: ar_charge_schedule_lines sched_lines,
4068: ar_aging_bucket_lines bucket_lines
4069: where a.interest_schedule_id = sched_hdrs.schedule_id(+)
4070: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
4071: and sched_hdrs.schedule_id = sched_lines.schedule_id(+)

Line 5415: ar_charge_schedule_lines sched_lines,

5411: cust_site.penalty_type
5412: from ar_lc_cust_sites_t cust_site,
5413: ar_late_charge_trx_t trx,
5414: ar_charge_schedule_hdrs sched_hdrs,
5415: ar_charge_schedule_lines sched_lines,
5416: ar_aging_bucket_lines bucket_lines
5417: where cust_site.customer_id = trx.customer_id
5418: and cust_site.customer_site_use_id = trx.customer_site_use_id
5419: and cust_site.currency_code = trx.currency_code