APPS.GME_LPN_MOBILE_TXN dependencies on MTL_TXN_REQUEST_LINES

Line 46: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

42: BEGIN
43:
44: SELECT mmtt.TRANSACTION_HEADER_ID, mmtt.TRANSACTION_TEMP_ID
45: INTO txn_header_id, txn_temp_id
46: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
47: WHERE move_order_line_id = mtrl.line_id
48: AND mtrl.lpn_id = p_lpn_id;
49: RETURN TRUE;
50:

Line 316: UPDATE mtl_txn_request_lines

312:
313: BEGIN
314: l_return_status:= FND_API.G_RET_STS_SUCCESS;
315:
316: UPDATE mtl_txn_request_lines
317: SET wms_process_flag = p_wms_process_flag
318: WHERE lpn_id = p_lpn_id;
319:
320: x_return_status:=l_return_status;