APPS.WMS_RULES_WORKBENCH_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 682: l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;

678: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
679:
680:
681: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
682: l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
683:
684:
685: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
686: l_return_type_code wms_selection_criteria_txn.return_type_code%type;

Line 731: from mtl_txn_request_lines mtrl

727: mtrl.transaction_source_type_id,
728: mtrl.reference_id,
729: mtrl.reference,
730: mtrl.uom_code
731: from mtl_txn_request_lines mtrl
732: where mtrl.header_id = l_rec_mtrl.header_id
733: AND mtrl.organization_id = l_from_organization_id
734: AND mtrl.line_status <> 5
735: AND NVL(mtrl.from_subinventory_code,'###') = NVL(l_from_subinventory_name,NVL(mtrl.from_subinventory_code,'###'))

Line 1112: UPDATE mtl_txn_request_lines

1108: FETCH SIMILAR_MTRL_LINES BULK COLLECT INTO mtrl_line_tab;
1109: CLOSE SIMILAR_MTRL_LINES;
1110:
1111: FORALL i IN mtrl_line_tab.first..mtrl_line_tab.last
1112: UPDATE mtl_txn_request_lines
1113: SET put_away_strategy_id = l_return_type_id
1114: WHERE line_id = mtrl_line_tab(i);
1115:
1116: if l_debug = 1 then

Line 1134: UPDATE mtl_txn_request_lines

1130: FETCH SIMILAR_MTRL_LINES BULK COLLECT INTO mtrl_line_tab;
1131: CLOSE SIMILAR_MTRL_LINES;
1132:
1133: FORALL i IN mtrl_line_tab.first..mtrl_line_tab.last
1134: UPDATE mtl_txn_request_lines
1135: SET pick_strategy_id = l_return_type_id
1136: WHERE line_id = mtrl_line_tab(i);
1137: if l_debug = 1 then
1138: log_event(l_api_name,'msg:','p_type_code => '||p_type_code);

Line 1264: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;

1260:
1261: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
1262:
1263: l_rec_wsct WMS_SELECTION_CRITERIA_TXN%ROWTYPE;
1264: -- l_rec_mtrl MTL_TXN_REQUEST_LINES%ROWTYPE;
1265:
1266: TYPE rec_mmtt is RECORD (
1267: line_id mtl_material_transactions_temp.transaction_temp_id%TYPE,
1268: organization_id mtl_material_transactions_temp.organization_id%TYPE,

Line 1874: from mtl_txn_request_lines mtrl

1870:
1871: /* -- Bug #3387877
1872: select nvl(mtrl.transaction_source_type_id,0) , nvl(mtrl.reference_id, 0)
1873: into l_transaction_source_type_id, l_reference_id
1874: from mtl_txn_request_lines mtrl
1875: where mtrl.line_id = p_move_order_line_id; */
1876:
1877: l_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;
1878: l_reference_id := inv_cache.mol_rec.reference_id;