APPS.AR_AGING_BUCKETS_PKG dependencies on AR_ADJUSTMENTS

Line 1629: -- ar_adjustments adj

1625: -- ps.cons_inv_id
1626: -- FROM ar_aging_payment_schedules aging,
1627: -- ar_payment_schedules ps,
1628: -- ra_customer_trx ct,
1629: -- ar_adjustments adj
1630: -- WHERE aging.parent_request_id = :parent_request_id
1631: -- AND aging.worker_id = :worker_id
1632: -- AND aging.payment_schedule_id = ps.payment_schedule_id
1633: -- AND ps.gl_date <= :as_of_date

Line 2139: ar_adjustments adj

2135: nvl(ps.exchange_rate,1) exchange_rate,
2136: 0 cons_inv_id
2137: FROM ar_aging_payment_schedules aging,
2138: ar_payment_schedules ps,
2139: ar_adjustments adj
2140: WHERE aging.parent_request_id = :parent_request_id
2141: AND aging.worker_id = :worker_id
2142: AND aging.source_type = ''INV''
2143: AND aging.payment_schedule_id = ps.payment_schedule_id

Line 2797: select /*+ leading(ext) index(adj AR_ADJUSTMENTS_N3)*/

2793: ext.amt_due_remaining
2794:
2795: UNION ALL
2796:
2797: select /*+ leading(ext) index(adj AR_ADJUSTMENTS_N3)*/
2798: adj.event_id,
2799: ext.payment_schedule_id,
2800: ext.amt_due_remaining,
2801: 'ADJ' source_identifier

Line 2803: ar_adjustments adj

2799: ext.payment_schedule_id,
2800: ext.amt_due_remaining,
2801: 'ADJ' source_identifier
2802: from ar_aging_extract ext,
2803: ar_adjustments adj
2804: where ext.parent_request_id = pg_parent_request_id
2805: and ext.worker_id = pg_worker_id
2806: and ext.payment_schedule_id = adj.payment_schedule_id
2807: and adj.gl_date <= pg_in_as_of_date_low