DBA Data[Home] [Help]

APPS.AR_CALC_LATE_CHARGE dependencies on AR_CHARGE_SCHEDULE_HDRS

Line 517: ar_charge_schedule_hdrs sched_hdrs,

513: decode(cust_site.interest_calculation_period,
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(+)

Line 2706: ar_charge_schedule_hdrs sched_hdrs,

2702: and b.customer_site_use_id = credits.customer_site_use_id (+)
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(+)

Line 3578: ar_charge_schedule_hdrs sched_hdrs,

3574: a.last_accrue_charge_date)))),
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(+)

Line 4066: ar_charge_schedule_hdrs sched_hdrs,

4062: 'DAILY',ps.due_date,
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(+)

Line 5414: ar_charge_schedule_hdrs sched_hdrs,

5410: decode(trx.charge_type,'AVERAGE_DAILY_BALANCE',trx.charge_type, NULL) charge_type,
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