APPS.AR_PURGE dependencies on AR_ADJUSTMENTS

Line 910: ar_adjustments adj,

906: FROM ra_cust_trx_types ctt,
907: fnd_document_sequences doc,
908: gl_sets_of_books sob,
909: ar_lookups lu,
910: ar_adjustments adj,
911: hz_cust_accounts cust,
912: hz_parties cust_party,
913: ra_customer_trx ct
914: WHERE lu.lookup_code (+) = adj.reason_code

Line 1919: ar_adjustments adj

1915: to_number(null), /* expiration_days */
1916: '' /* override_auto_accounting_flag */
1917: FROM ra_cust_trx_types ctt,
1918: ra_customer_trx ct,
1919: ar_adjustments adj
1920: WHERE adj.customer_trx_id = cp_customer_trx_id
1921: and adj.customer_trx_id = ct.customer_trx_id
1922: and ctt.cust_trx_type_id = ct.cust_trx_type_id
1923: and cp_archive_level <> 'H'

Line 2946: from ar_adjustments adj

2942: FOR UPDATE OF sales.customer_trx_id NOWAIT;
2943:
2944: cursor adj_cur is
2945: SELECT 'Found' record_found
2946: from ar_adjustments adj
2947: WHERE adj.customer_trx_id = p_entity_id
2948: FOR UPDATE OF adj.customer_trx_id NOWAIT;
2949:
2950: cursor recv_app_cur is

Line 2971: ar_adjustments adj,

2967: SELECT 'Found' record_found
2968: FROM ra_cust_trx_line_salesreps sales,
2969: ar_receivable_applications ra,
2970: ar_payment_schedules ps,
2971: ar_adjustments adj,
2972: ra_cust_trx_line_gl_dist dist,
2973: ra_customer_trx_lines lines,
2974: ra_customer_trx trx
2975: WHERE trx.customer_trx_id = p_entity_id

Line 3143: FROM ar_adjustments

3139: l_violate_adjustments NUMBER;
3140: BEGIN
3141: SELECT COUNT(*)
3142: INTO l_violate_adjustments
3143: FROM ar_adjustments
3144: WHERE customer_trx_id = p_entity_id
3145: AND status in ('A', 'M', 'W') -- bug1999155
3146: AND
3147: (

Line 3179: FROM ar_adjustments

3175: l_violate_adjustments NUMBER;
3176: BEGIN
3177: SELECT COUNT(*)
3178: INTO l_violate_adjustments
3179: FROM ar_adjustments
3180: WHERE customer_trx_id = p_entity_id
3181: AND status in ('A', 'M', 'W')
3182: AND decode ( status, 'A', gl_date , p_as_of_gl_date + 1)
3183: > p_as_of_gl_date ;

Line 3309: FROM ar_adjustments

3305: l_violate_adjustments NUMBER;
3306: BEGIN
3307: SELECT COUNT(*)
3308: INTO l_violate_adjustments
3309: FROM ar_adjustments
3310: WHERE customer_trx_id = p_entity_id
3311: AND status in ('A', 'M', 'W') -- bug1999155
3312: AND
3313: (

Line 3368: FROM ar_adjustments

3364: p_running_total := p_running_total + l_receivable_amount ;
3365:
3366: SELECT NVL(SUM(acctd_amount),0)
3367: INTO l_adjustment_amount
3368: FROM ar_adjustments
3369: WHERE customer_trx_id = p_entity_id
3370: AND status in ('A', 'M', 'W') ; -- bug1999155
3371:
3372: p_running_total := p_running_total + l_adjustment_amount;

Line 3521: from ar_adjustments

3517:
3518: --
3519: DELETE FROM ar_distributions
3520: WHERE source_id in ( select adjustment_id
3521: from ar_adjustments
3522: where customer_trx_id = p_entity_id )
3523: AND source_table = 'ADJ'
3524: RETURNING line_id
3525: BULK COLLECT INTO l_ar_dist_key_value_list;

Line 3540: DELETE FROM ar_adjustments

3536: p_key_value_list => l_ar_dist_key_value_list);*/
3537:
3538: --
3539:
3540: DELETE FROM ar_adjustments
3541: WHERE customer_trx_id = p_entity_id
3542: RETURNING adjustment_id
3543: BULK COLLECT INTO l_adj_key_value_list;
3544:

Line 3552: p_table_name => 'AR_ADJUSTMENTS',

3548: +---------------------------------*/
3549:
3550: /* ar_mrc_engine.maintain_mrc_data(
3551: p_event_mode => 'DELETE',
3552: p_table_name => 'AR_ADJUSTMENTS',
3553: p_mode => 'BATCH',
3554: p_key_value_list => l_adj_key_value_list);*/
3555: --
3556: DELETE FROM ra_cust_trx_line_salesreps