DBA Data[Home] [Help]

APPS.GML_RCV_COMMON_APIS dependencies on INV_RCV_COMMON_APIS

Line 307: inv_rcv_common_apis.g_order_lots_by

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: );

Line 308: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date

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:

Line 309: , inv_rcv_common_apis.g_order_lots_by_creation_date, creation_date

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