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 312: UPDATE mtl_txn_request_lines

308:
309: BEGIN
310: l_return_status:= FND_API.G_RET_STS_SUCCESS;
311:
312: UPDATE mtl_txn_request_lines
313: SET wms_process_flag = p_wms_process_flag
314: WHERE lpn_id = p_lpn_id;
315:
316: x_return_status:=l_return_status;