303: , vendor_name
304: FROM mtl_transaction_lots_temp
305: WHERE transaction_temp_id = p_original_tid
306: ORDER BY DECODE(
307: inv_rcv_common_apis.g_order_lots_by
308: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date
309: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date
310: , lot_expiration_date
311: );
304: FROM mtl_transaction_lots_temp
305: WHERE transaction_temp_id = p_original_tid
306: ORDER BY DECODE(
307: inv_rcv_common_apis.g_order_lots_by
308: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date
309: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date
310: , lot_expiration_date
311: );
312:
305: WHERE transaction_temp_id = p_original_tid
306: ORDER BY DECODE(
307: inv_rcv_common_apis.g_order_lots_by
308: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date
309: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date
310: , lot_expiration_date
311: );
312:
313: --Changed the order by for bug 2422193