APPS.AR_TRX_SUMMARY_PKG dependencies on AR_ADJUSTMENTS_ALL

Line 608: AR_ADJUSTMENTS_ALL ADJ

604: PS.AMOUNT_DUE_ORIGINAL,
605: ps.amount_in_dispute,
606: ps.actual_date_closed, PS.PAYMENT_SCHEDULE_ID
607: ) A,
608: AR_ADJUSTMENTS_ALL ADJ
609: WHERE A.PAYMENT_SCHEDULE_ID = ADJ.PAYMENT_SCHEDULE_ID(+)
610: AND ADJ.CREATION_DATE (+) <= l_program_start_date
611: AND ADJ.STATUS(+) = 'A'
612: GROUP BY A.CUSTOMER_ID, A.CUSTOMER_SITE_USE_ID,

Line 792: ar_adjustments_all adj

788: 0 app_amt_days_late,
789: sum(adj.amount) adj_amount,
790: count(adjustment_id) adj_count
791: from ar_payment_schedules_all ps,
792: ar_adjustments_all adj
793: where ps.payment_schedule_id = adj.payment_schedule_id
794: and adj.receivables_trx_id(+) > 0
795: and ps.trx_date > add_months(sysdate, -24)
796: and ps.creation_date <= l_program_start_date

Line 1012: ar_adjustments_all adj

1008: union all
1009: select ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
1010: adj.apply_date as_of_date, sum(adj.amount)
1011: from ar_payment_schedules_all ps,
1012: ar_adjustments_all adj
1013: where ps.payment_schedule_id = adj.payment_schedule_id
1014: and ps.class in ('||''''||'INV'||''''||','
1015: ||''''||'CM'||''''||','
1016: ||''''||'DM'||''''||','

Line 1822: AR_ADJUSTMENTS_ALL ADJ

1818: PS.AMOUNT_DUE_ORIGINAL,
1819: PS.amount_in_dispute,
1820: ps.actual_date_closed, PS.PAYMENT_SCHEDULE_ID
1821: ) A,
1822: AR_ADJUSTMENTS_ALL ADJ
1823: WHERE A.PAYMENT_SCHEDULE_ID = ADJ.PAYMENT_SCHEDULE_ID(+)
1824: AND ADJ.STATUS(+) = 'A'
1825: GROUP BY A.CUSTOMER_ID, A.CUSTOMER_SITE_USE_ID,
1826: A.CURRENCY_CODE, A.ORG_ID,

Line 2003: ar_adjustments_all adj

1999: 0 app_amt_days_late,
2000: sum(adj.amount) adj_amount,
2001: count(adjustment_id) adj_count
2002: from ar_payment_schedules_all ps,
2003: ar_adjustments_all adj
2004: where ps.customer_id = p_cust_id(i)
2005: and ps.payment_schedule_id = adj.payment_schedule_id
2006: and adj.receivables_trx_id(+) > 0
2007: and ps.trx_date > add_months(sysdate, -24)

Line 2235: ar_adjustments_all adj

2231: union all
2232: select ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
2233: adj.apply_date as_of_date, sum(adj.amount)
2234: from ar_payment_schedules_all ps,
2235: ar_adjustments_all adj
2236: where ps.payment_schedule_id = adj.payment_schedule_id
2237: and ps.class in ('||''''||'INV'||''''||','
2238: ||''''||'CM'||''''||','
2239: ||''''||'DM'||''''||','