APPS.AR_PURGE dependencies on AR_ADJUSTMENTS

Line 1827: ar_adjustments adj,

1823: FROM ra_cust_trx_types ctt,
1824: fnd_document_sequences doc,
1825: gl_sets_of_books sob,
1826: ar_lookups lu,
1827: ar_adjustments adj,
1828: hz_cust_accounts cust,
1829: hz_parties cust_party,
1830: ra_customer_trx ct
1831: WHERE lu.lookup_code (+) = adj.reason_code

Line 2836: ar_adjustments adj

2832: to_number(null), /* expiration_days */
2833: '' /* override_auto_accounting_flag */
2834: FROM ra_cust_trx_types ctt,
2835: ra_customer_trx ct,
2836: ar_adjustments adj
2837: WHERE adj.customer_trx_id = cp_customer_trx_id
2838: and adj.customer_trx_id = ct.customer_trx_id
2839: and ctt.cust_trx_type_id = ct.cust_trx_type_id
2840: and cp_archive_level <> 'H'

Line 3863: from ar_adjustments adj

3859: FOR UPDATE OF sales.customer_trx_id NOWAIT;
3860:
3861: cursor adj_cur is
3862: SELECT 'Found' record_found
3863: from ar_adjustments adj
3864: WHERE adj.customer_trx_id = p_entity_id
3865: FOR UPDATE OF adj.customer_trx_id NOWAIT;
3866:
3867: cursor recv_app_cur is

Line 3888: ar_adjustments adj,

3884: SELECT 'Found' record_found
3885: FROM ra_cust_trx_line_salesreps sales,
3886: ar_receivable_applications ra,
3887: ar_payment_schedules ps,
3888: ar_adjustments adj,
3889: ra_cust_trx_line_gl_dist dist,
3890: ra_customer_trx_lines lines,
3891: ra_customer_trx trx
3892: WHERE trx.customer_trx_id = p_entity_id

Line 4060: FROM ar_adjustments

4056: l_violate_adjustments NUMBER;
4057: BEGIN
4058: SELECT COUNT(*)
4059: INTO l_violate_adjustments
4060: FROM ar_adjustments
4061: WHERE customer_trx_id = p_entity_id
4062: AND status in ('A', 'M', 'W') -- bug1999155
4063: AND
4064: (

Line 4096: FROM ar_adjustments

4092: l_violate_adjustments NUMBER;
4093: BEGIN
4094: SELECT COUNT(*)
4095: INTO l_violate_adjustments
4096: FROM ar_adjustments
4097: WHERE customer_trx_id = p_entity_id
4098: AND status in ('A', 'M', 'W')
4099: AND decode ( status, 'A', gl_date , p_as_of_gl_date + 1)
4100: > p_as_of_gl_date ;

Line 4226: FROM ar_adjustments

4222: l_violate_adjustments NUMBER;
4223: BEGIN
4224: SELECT COUNT(*)
4225: INTO l_violate_adjustments
4226: FROM ar_adjustments
4227: WHERE customer_trx_id = p_entity_id
4228: AND status in ('A', 'M', 'W') -- bug1999155
4229: AND
4230: (

Line 4285: FROM ar_adjustments

4281: p_running_total := p_running_total + l_receivable_amount ;
4282:
4283: SELECT NVL(SUM(acctd_amount),0)
4284: INTO l_adjustment_amount
4285: FROM ar_adjustments
4286: WHERE customer_trx_id = p_entity_id
4287: AND status in ('A', 'M', 'W') ; -- bug1999155
4288:
4289: p_running_total := p_running_total + l_adjustment_amount;

Line 4409: from ar_adjustments

4405:
4406: --
4407: DELETE FROM ar_distributions
4408: WHERE source_id in ( select adjustment_id
4409: from ar_adjustments
4410: where customer_trx_id = p_entity_id )
4411: AND source_table = 'ADJ';
4412:
4413:

Line 4416: DELETE FROM ar_adjustments

4412:
4413:
4414: --
4415:
4416: DELETE FROM ar_adjustments
4417: WHERE customer_trx_id = p_entity_id;
4418:
4419:
4420: --