APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 2346: -- mtl_material_transactions_temp table

2342: -- Name: GET_SERIAL_LOV_ALLOC_PICKING
2343: --
2344: -- Input parameters:
2345: -- p_transaction_temp_id the transaction temp id from the
2346: -- mtl_material_transactions_temp table
2347: -- p_lot_code if '1' means not lot controlled
2348: -- if '2' means IS lot controlled
2349: -- the caller function would have to ensure that
2350: -- these are the only numbers used.

Line 2787: FROM mtl_material_transactions_temp

2783: WHERE inventory_item_id = p_item_id
2784: AND (group_mark_id IS NULL
2785: OR group_mark_id = -1
2786: OR group_mark_id IN (SELECT transaction_temp_id
2787: FROM mtl_material_transactions_temp
2788: WHERE move_order_line_id = p_move_order_line_id
2789: UNION
2790: SELECT mtlt.serial_transaction_temp_id
2791: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

Line 2791: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

2787: FROM mtl_material_transactions_temp
2788: WHERE move_order_line_id = p_move_order_line_id
2789: UNION
2790: SELECT mtlt.serial_transaction_temp_id
2791: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
2792: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
2793: AND mtlt.serial_transaction_temp_id IS NOT NULL)
2794: )
2795: AND current_organization_id = p_organization_id