DBA Data[Home] [Help]

APPS.ARP_REVERSE_RECEIPT dependencies on AR_ADJUSTMENTS

Line 1182: FROM ar_adjustments adj

1178: AND ps.customer_trx_id = ctlg.customer_trx_id
1179: AND ( NVL( ps.amount_applied, 0 ) <> 0
1180: OR NVL( ps.amount_credited, 0 ) <> 0
1181: OR 0 <> ( SELECT sum( adj.amount )
1182: FROM ar_adjustments adj
1183: WHERE adj.payment_schedule_id = ps.payment_schedule_id
1184: AND adj.receivables_trx_id <>
1185: arp_global.G_CB_REV_RT_ID
1186: )