APPS.AR_TRX_SUMMARY_PKG dependencies on AR_TRX_SUMMARY_HIST

Line 471: from ar_trx_summary_hist

467: null,ra.unearned_discount_taken), null)) unedisc_taken
468: FROM AR_PAYMENT_SCHEDULES_all ps,
469: AR_RECEIVABLE_APPLICATIONS_ALL RA,
470: ( select history_id, payment_schedule_id, due_date, amount_in_dispute
471: from ar_trx_summary_hist
472: where history_id in
473: (select max(history_id)
474: from ar_trx_summary_hist
475: where nvl(complete_flag,'N') = 'N'

Line 474: from ar_trx_summary_hist

470: ( select history_id, payment_schedule_id, due_date, amount_in_dispute
471: from ar_trx_summary_hist
472: where history_id in
473: (select max(history_id)
474: from ar_trx_summary_hist
475: where nvl(complete_flag,'N') = 'N'
476: and creation_date <= l_program_start_date
477: group by payment_schedule_id)) TRX_HIST
478: WHERE RA.APPLIED_PAYMENT_SCHEDULE_ID(+) = PS.PAYMENT_SCHEDULE_ID

Line 621: from ar_trx_summary_hist

617: sum(decode(ps.class, 'INV',
618: (ra.apply_date - nvl(trx_hist.due_date, ps.due_date))* ra.amount_applied, null)) app_amt_days_late
619: from ar_payment_schedules_all ps,
620: ( select history_id, payment_schedule_id, due_date, amount_in_dispute
621: from ar_trx_summary_hist
622: where history_id in
623: (select max(history_id)
624: from ar_trx_summary_hist
625: where nvl(complete_flag,'N') = 'N'

Line 624: from ar_trx_summary_hist

620: ( select history_id, payment_schedule_id, due_date, amount_in_dispute
621: from ar_trx_summary_hist
622: where history_id in
623: (select max(history_id)
624: from ar_trx_summary_hist
625: where nvl(complete_flag,'N') = 'N'
626: and creation_date <= l_program_start_date
627: group by payment_schedule_id)) TRX_HIST,
628: ra_terms_b rt,