DBA Data[Home] [Help]

APPS.ARP_PROCESS_DIST dependencies on AR_ADJUSTMENTS

Line 1231: FROM ar_adjustments adj

1227: AND nvl(ard.ref_cust_trx_line_gl_dist_id,-9999) = p_cust_trx_line_gl_dist_id
1228: AND nvl(ard.ref_dist_ccid,-9999) <> p_dist_rec.code_combination_id)
1229: UNION ALL
1230: SELECT adj.adjustment_id, 'ADJ'
1231: FROM ar_adjustments adj
1232: WHERE adj.customer_trx_id = p_dist_rec.customer_trx_id
1233: AND adj.posting_control_id = -3
1234: AND nvl(adj.status, 'Y') = 'A'
1235: AND EXISTS