82: rct.invoice_currency_code
83: FROM
84: ra_customer_trx_lines_all rctl,
85: ra_customer_trx_all rct,
86: ra_cust_trx_types_all rctt
87: WHERE
88: line_type = 'LINE' AND
89: inventory_item_id = p_inventory_item_id AND
90: uom_code = p_uom_code AND
101: MAX(rctl1.customer_trx_line_id)
102: FROM
103: ra_customer_trx_lines_all rctl1,
104: ra_customer_trx_all rct1,
105: ra_cust_trx_types_all rctt1
106: WHERE
107: line_type = 'LINE' AND
108: inventory_item_id = p_inventory_item_id AND
109: uom_code = p_uom_code AND