APPS.AR_MOVEMENT_STAT_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 39: FROM mtl_movement_statistics mtl, ra_customer_trx_lines lin

35: IS
36:
37: CURSOR get_invoice_lines (a_customer_trx_id NUMBER) IS
38: SELECT mtl.movement_id, lin.customer_trx_line_id
39: FROM mtl_movement_statistics mtl, ra_customer_trx_lines lin
40: WHERE lin.movement_id = mtl.movement_id
41: AND lin.movement_id is not null
42: AND lin.customer_trx_id = a_customer_trx_id
43: AND lin.line_type = 'LINE' FOR UPDATE OF

Line 50: -- *** ra_customer_trx_lines table related to the ***

46: BEGIN
47:
48: -- *** The Cursor get_invoice_lines locks all movement_id's ***
49: -- *** in mtl_movement_statistics table which exists in ***
50: -- *** ra_customer_trx_lines table related to the ***
51: -- *** requested customer_trx_id ***
52:
53: -- *** This Cursor also gets all customer_trx_lines rows ***
54: -- *** for a given customer_trx_id where a movement_id ***

Line 56: -- *** in the ra_customer_trx_lines table.

52:
53: -- *** This Cursor also gets all customer_trx_lines rows ***
54: -- *** for a given customer_trx_id where a movement_id ***
55: -- *** exists in the mtl_movement_statistics as well as ***
56: -- *** in the ra_customer_trx_lines table.
57:
58: FOR lines IN get_invoice_lines(p_customer_trx_id) LOOP
59:
60: -- *** Invoice Price Information Update ***