APPS.WMS_OP_INBOUND_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 83: FROM mtl_transaction_lots_temp

79: AND organization_id = v_organization_id;
80:
81: CURSOR c_mtlt_rec IS
82: SELECT *
83: FROM mtl_transaction_lots_temp
84: WHERE transaction_temp_id=p_source_task_id;
85:
86: l_module_name VARCHAR2(30) := 'INIT';
87: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

Line 90: l_mtlt_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;

86: l_module_name VARCHAR2(30) := 'INIT';
87: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
88: l_progress NUMBER;
89:
90: l_mtlt_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
91: l_item_details_rec c_item_details%ROWTYPE;
92: l_wms_task_type NUMBER;
93: l_insert_lot NUMBER;
94: l_ser_trx_id NUMBER;

Line 2036: UPDATE mtl_transaction_lots_temp

2032: END IF;
2033:
2034: l_progress := 300;
2035:
2036: UPDATE mtl_transaction_lots_temp
2037: SET transaction_temp_id = x_source_task_id
2038: WHERE transaction_temp_id = p_source_task_id;
2039:
2040: l_progress := 310;