APPS.WMS_TASK_LOAD dependencies on MTL_TXN_REQUEST_LINES

Line 5339: , mtl_txn_request_lines mtrl

5335: CURSOR cur_cancelled_MOLs IS
5336: SELECT mtrl.line_id
5337: , mtrl.uom_code
5338: FROM mtl_material_transactions_temp mmtt
5339: , mtl_txn_request_lines mtrl
5340: WHERE (mmtt.transaction_temp_id = p_transaction_temp_id
5341: -- shld add : and mmtt.mmtt.transaction_temp_id <> mmtt.parent_line_id
5342: OR mmtt.parent_line_id = p_transaction_temp_id)
5343: AND mtrl.line_id = mmtt.move_order_line_id

Line 5418: UPDATE mtl_txn_request_lines

5414: AND NOT EXISTS ( SELECT 1
5415: FROM mtl_material_transactions_temp t1
5416: WHERE t1.parent_line_id = mmtt.transaction_temp_id);
5417:
5418: UPDATE mtl_txn_request_lines
5419: SET quantity_detailed =(quantity_detailed - l_deleted_mmtt_qty)
5420: , SECONDARY_QUANTITY_DETAILED = (SECONDARY_QUANTITY_DETAILED - l_deleted_mmtt_sec_qty)
5421: , line_status = DECODE(l_mmtt_count, 0, INV_GLOBALS.G_TO_STATUS_CLOSED, line_status)
5422: , last_update_date = SYSDATE

Line 6746: FROM mtl_txn_request_lines

6742:
6743: --Fetch the UOM code of the MO line and lock the MO line
6744: SELECT uom_code
6745: INTO l_mol_uom
6746: FROM mtl_txn_request_lines
6747: WHERE line_id = l_mo_line_id
6748: FOR UPDATE;
6749:
6750: --Fetch the primary quantity for all MMTTs for this MO line

Line 6775: UPDATE mtl_txn_request_lines

6771: mydebug('update quantity_detailed in MOL with: ' || l_mmtt_qty_in_mol_uom);
6772: END IF;
6773:
6774: --Now update quantity_detailed as quanity_delivered + sum(mmtt qty)
6775: UPDATE mtl_txn_request_lines
6776: SET quantity_detailed = NVL(quantity_delivered, 0) + l_mmtt_qty_in_mol_uom
6777: , last_update_date = SYSDATE
6778: , last_updated_by = p_user_id
6779: WHERE line_id = l_mo_line_id;

Line 10316: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

10312: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
10313: CURSOR c_cancelled_tasks IS
10314: --SELECT decode(mmtt.transaction_type_id, 35,'N',51,'N','Y')
10315: SELECT 'FAIL'
10316: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
10317: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
10318: AND mmtt.move_order_line_id = mol.line_id
10319: AND mol.line_status = inv_globals.g_to_status_cancel_by_source
10320: AND ROWNUM = 1;

Line 10734: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

10730: AND mmtt.transaction_temp_id = p_temp_id;
10731:
10732: CURSOR current_carton_grouping_cursor IS
10733: SELECT mol.carton_grouping_id
10734: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
10735: WHERE mmtt.transaction_temp_id = p_temp_id
10736: AND mmtt.organization_id = mol.organization_id
10737: AND mmtt.move_order_line_id = mol.line_id;
10738:

Line 10741: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

10737: AND mmtt.move_order_line_id = mol.line_id;
10738:
10739: CURSOR others_carton_grouping_cursor(p_lpn_id IN NUMBER) IS
10740: SELECT DISTINCT mol.carton_grouping_id
10741: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
10742: WHERE mmtt.transfer_lpn_id = p_lpn_id
10743: AND mmtt.organization_id = mol.organization_id
10744: AND mmtt.move_order_line_id = mol.line_id;
10745:

Line 11167: , mtl_txn_request_lines mtrl

11163: INTO l_mmtt_mo_type
11164: , l_mmtt_txn_type_id
11165: , l_mmtt_wip_entity_type
11166: FROM mtl_txn_request_headers mtrh
11167: , mtl_txn_request_lines mtrl
11168: , mtl_material_transactions_temp mmtt
11169: WHERE mtrh.header_id = mtrl.header_id
11170: AND mtrl.line_id = mmtt.move_order_line_id
11171: AND mmtt.transaction_temp_id = p_temp_id;

Line 11179: , mtl_txn_request_lines mtrl

11175: , mmtt.wip_entity_type
11176: INTO l_mo_type_in_lpn
11177: , l_wip_entity_type_in_lpn
11178: FROM mtl_txn_request_headers mtrh
11179: , mtl_txn_request_lines mtrl
11180: , mtl_material_transactions_temp mmtt
11181: WHERE mtrh.header_id = mtrl.header_id
11182: AND mtrl.line_id = mmtt.move_order_line_id
11183: AND mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id