DBA Data[Home] [Help]

APPS.AR_PURGE dependencies on AR_LINE_CONTS

Line 2954: ar_line_conts lc

2950: lc.expiration_days, /* expiration_days */
2951: '' /* override_auto_accounting_flag */
2952: FROM
2953: ra_customer_trx_lines ctl,
2954: ar_line_conts lc
2955: WHERE cp_customer_trx_id = ctl.customer_trx_id
2956: and ctl.customer_trx_line_id = lc.customer_trx_line_id
2957: and cp_archive_level <> 'H'
2958: UNION ALL /* Bug 5105156 - fix 5044763 */

Line 4361: DELETE FROM ar_line_conts

4357: -- bug3975105 added 'N'
4358: print( p_recursive_level, ' ...deleting rows', 'N' );
4359: --
4360: /* bug3873165 added two tables for line rev */
4361: DELETE FROM ar_line_conts
4362: WHERE customer_trx_line_id in ( select customer_trx_line_id
4363: from ra_customer_trx
4364: where customer_trx_id = p_entity_id );
4365: --