APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 2433: -- mtl_material_transactions_temp table

2429: -- Name: GET_SERIAL_LOV_ALLOC_PICKING
2430: --
2431: -- Input parameters:
2432: -- p_transaction_temp_id the transaction temp id from the
2433: -- mtl_material_transactions_temp table
2434: -- p_lot_code if '1' means not lot controlled
2435: -- if '2' means IS lot controlled
2436: -- the caller function would have to ensure that
2437: -- these are the only numbers used.

Line 2875: FROM mtl_material_transactions_temp

2871: WHERE inventory_item_id = p_item_id
2872: AND (group_mark_id IS NULL
2873: OR group_mark_id = -1
2874: OR group_mark_id IN (SELECT transaction_temp_id
2875: FROM mtl_material_transactions_temp
2876: WHERE move_order_line_id = p_move_order_line_id
2877: UNION
2878: SELECT mtlt.serial_transaction_temp_id
2879: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

Line 2879: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

2875: FROM mtl_material_transactions_temp
2876: WHERE move_order_line_id = p_move_order_line_id
2877: UNION
2878: SELECT mtlt.serial_transaction_temp_id
2879: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
2880: WHERE move_order_line_id = p_move_order_line_id
2881: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id
2882: AND mtlt.serial_transaction_temp_id IS NOT NULL)
2883: )