APPS.AR_TRX_SUMMARY_PKG dependencies on AR_ADJUSTMENTS_ALL

Line 494: AR_ADJUSTMENTS_ALL ADJ

490: PS.AMOUNT_DUE_ORIGINAL,
491: nvl(trx_hist.amount_in_dispute, ps.amount_in_dispute),
492: ps.actual_date_closed, PS.PAYMENT_SCHEDULE_ID
493: ) A,
494: AR_ADJUSTMENTS_ALL ADJ
495: WHERE A.PAYMENT_SCHEDULE_ID = ADJ.PAYMENT_SCHEDULE_ID(+)
496: AND ADJ.CREATION_DATE (+) <= l_program_start_date
497: AND ADJ.STATUS(+) = 'A'
498: GROUP BY A.CUSTOMER_ID, A.CUSTOMER_SITE_USE_ID,

Line 690: ar_adjustments_all adj

686: 0 app_amt_days_late,
687: sum(adj.amount) adj_amount,
688: count(adjustment_id) adj_count
689: from ar_payment_schedules_all ps,
690: ar_adjustments_all adj
691: where ps.payment_schedule_id = adj.payment_schedule_id
692: and adj.receivables_trx_id(+) > 0
693: and ps.trx_date > add_months(sysdate, -24)
694: and ps.creation_date <= l_program_start_date

Line 906: ar_adjustments_all adj

902: union all
903: select ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
904: adj.apply_date as_of_date, sum(adj.amount)
905: from ar_payment_schedules_all ps,
906: ar_adjustments_all adj
907: where ps.payment_schedule_id = adj.payment_schedule_id
908: and ps.class in ('||''''||'INV'||''''||','
909: ||''''||'CM'||''''||','
910: ||''''||'DM'||''''||','