APPS.AR_AUTOREC_API dependencies on RA_CUSTOMER_TRX_LINES

Line 3997: from ra_customer_trx_lines ctl

3993: uned.code_combination_id uned_disc_ccid,
3994: crh.batch_id,
3995: rgt.customer_trx_id,
3996: (select 'Y' rev_rec_flag
3997: from ra_customer_trx_lines ctl
3998: where ctl.customer_trx_id = rgt.customer_trx_id
3999: and ctl.autorule_complete_flag||'' = 'N'
4000: and rownum = 1 ) rev_rec_flag,
4001: (select 'Y' def_tax_flag

Line 4950: UPDATE RA_CUSTOMER_TRX_LINES TL SET (

4946:
4947: arp_standard.debug('Reset Invoice Line Level Balances If maintained on the invoice');
4948: IF unbal_rec_appln.upgrade_method IN ('R12', 'R12_11IMFAR') THEN
4949:
4950: UPDATE RA_CUSTOMER_TRX_LINES TL SET (
4951: AMOUNT_DUE_REMAINING,
4952: ACCTD_AMOUNT_DUE_REMAINING,
4953: CHRG_AMOUNT_REMAINING,
4954: CHRG_ACCTD_AMOUNT_REMAINING,

Line 5023: ra_customer_trx_lines ctl

5019: ard.ref_account_class,
5020: ard.activity_bucket,
5021: ctl.line_type
5022: FROM ar_distributions ard,
5023: ra_customer_trx_lines ctl
5024: WHERE ctl.customer_trx_id =
5025: unbal_rec_appln.applied_customer_trx_id
5026: AND ctl.customer_trx_line_id = ard.ref_customer_trx_line_id (+)
5027: GROUP BY ctl.customer_trx_line_id,