[Home] [Help]
172: mtrl.last_update_login,
173: mtrl.reference,
174: mtrl.reference_id,
175: mtrl.transaction_source_type_id
176: FROM mtl_txn_request_lines mtrl,
177: mtl_system_items msi,
178: mtl_units_of_measure muom
179: WHERE mtrl.lpn_id = l_lpn_id -- the MTRL is within the LPN
180: AND (mtrl.line_id = p_move_order_line_id OR p_move_order_line_id IS NULL)
199: operation_seq_num,
200: repetitive_schedule_id,
201: transaction_source_type_id
202: FROM
203: mtl_txn_request_lines mtrl
204: WHERE mtrl.lpn_id = l_lpn_id -- the MTRL is within the LPN
205: AND mtrl.line_id = NVL(p_move_order_line_id, mtrl.line_id)
206: AND mtrl.backorder_delivery_detail_id IS NOT NULL -- also including lines planned crossdocked
207: AND (mtrl.quantity_detailed = 0 OR mtrl.quantity_detailed IS NULL) -- no MMTT is created for this LPN
223: operation_seq_num,
224: repetitive_schedule_id,
225: transaction_source_type_id
226: FROM
227: mtl_txn_request_lines mtrl
228: WHERE mtrl.lpn_id = l_lpn_id -- the MTRL is within the LPN
229: AND p_move_order_line_id IS NOT NULL
230: AND mtrl.reference_detail_id = p_move_order_line_id
231: AND mtrl.backorder_delivery_detail_id IS NOT NULL -- also including lines planned crossdocked
574: nvl(nvl(supply_locator_id, mp.default_crossdock_locator_id), wp.default_pull_supply_locator_id)
575: INTO l_to_sub_code,
576: l_to_loc_id
577: FROM wip_requirement_operations wro,
578: mtl_txn_request_lines mtrl,
579: mtl_parameters mp,
580: wip_parameters wp
581: WHERE wro.organization_id = l_org_id
582: AND mp.organization_id = l_org_id
1065: END IF; -- end sales order or WIP crossdock IF
1066:
1067: IF (l_xdock_type = 2) THEN
1068:
1069: UPDATE mtl_txn_request_lines
1070: SET to_subinventory_code = l_to_sub_code,
1071: to_locator_id = l_to_loc_id
1072: WHERE line_id = l_line_id;
1073:
1072: WHERE line_id = l_line_id;
1073:
1074: ELSE
1075:
1076: UPDATE mtl_txn_request_lines
1077: SET to_subinventory_code = Nvl(l_to_sub_code, l_default_ship_staging_sub),
1078: to_locator_id = Nvl(l_to_loc_id, l_default_ship_staging_loc_id)
1079: WHERE line_id = l_line_id;
1080:
1313: SELECT
1314: l.line_id, l.backorder_delivery_detail_id,l.inventory_item_id,Nvl(crossdock_type,1)
1315: ,l.transaction_source_type_id,l.txn_source_id
1316: INTO l_mo_line_id,l_del_id,l_item_id,l_crossdock_type,l_transaction_source_type_id,l_txn_supply_source_id
1317: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t, wsh_delivery_details_ob_grp_v wdd
1318: WHERE t.transaction_temp_id=l_temp_id
1319: AND l.backorder_delivery_detail_id = wdd.delivery_detail_id
1320: AND t.move_order_line_id=l.line_id
1321: AND exists (
1331: SELECT
1332: l.line_id, l.backorder_delivery_detail_id,l.inventory_item_id,Nvl(crossdock_type,1)
1333: ,l.transaction_source_type_id,l.txn_source_id
1334: INTO l_mo_line_id,l_del_id,l_item_id,l_crossdock_type,l_transaction_source_type_id,l_txn_supply_source_id
1335: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t
1336: WHERE t.transaction_temp_id=l_temp_id
1337: AND t.move_order_line_id=l.line_id;
1338:
1339: END;
2417: RETURN;
2418: END IF;
2419:
2420: --Update MOL
2421: UPDATE mtl_txn_request_lines
2422: SET backorder_delivery_detail_id = NULL
2423: , crossdock_type = 1
2424: , quantity_detailed = (quantity - Nvl(quantity_delivered,0))
2425: WHERE line_id = p_move_order_line_id;
2470: INTO l_txn_src_type_id
2471: , l_move_order_line_id
2472: , l_backorder_delivery_detail_id
2473: FROM mtl_material_transactions_temp mmtt
2474: , mtl_txn_request_lines mtrl
2475: , mtl_txn_request_headers mtrh
2476: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
2477: AND mmtt.move_order_line_id = mtrl.line_id
2478: AND mtrh.header_id = mtrl.header_id