[Home] [Help]
398: mtrl.last_update_login,
399: mtrl.reference,
400: mtrl.reference_id,
401: mtrl.transaction_source_type_id
402: FROM mtl_txn_request_lines mtrl,
403: mtl_system_items msi,
404: mtl_units_of_measure muom
405: WHERE mtrl.lpn_id = l_lpn_id -- the MTRL is within the LPN
406: AND (mtrl.line_id = p_move_order_line_id OR p_move_order_line_id IS NULL)
425: operation_seq_num,
426: repetitive_schedule_id,
427: transaction_source_type_id
428: FROM
429: mtl_txn_request_lines mtrl
430: WHERE mtrl.lpn_id = l_lpn_id -- the MTRL is within the LPN
431: AND mtrl.line_id = NVL(p_move_order_line_id, mtrl.line_id)
432: AND mtrl.backorder_delivery_detail_id IS NOT NULL -- also including lines planned crossdocked
433: AND (mtrl.quantity_detailed = 0 OR mtrl.quantity_detailed IS NULL) -- no MMTT is created for this LPN
449: operation_seq_num,
450: repetitive_schedule_id,
451: transaction_source_type_id
452: FROM
453: mtl_txn_request_lines mtrl
454: WHERE mtrl.lpn_id = l_lpn_id -- the MTRL is within the LPN
455: AND p_move_order_line_id IS NOT NULL
456: AND mtrl.reference_detail_id = p_move_order_line_id
457: AND mtrl.backorder_delivery_detail_id IS NOT NULL -- also including lines planned crossdocked
806: nvl(nvl(supply_locator_id, mp.default_crossdock_locator_id), wp.default_pull_supply_locator_id)
807: INTO l_to_sub_code,
808: l_to_loc_id
809: FROM wip_requirement_operations wro,
810: mtl_txn_request_lines mtrl,
811: mtl_parameters mp,
812: wip_parameters wp
813: WHERE wro.organization_id = l_org_id
814: AND mp.organization_id = l_org_id
1340: END IF; -- end sales order or WIP crossdock IF
1341:
1342: IF (l_xdock_type = 2) THEN
1343:
1344: UPDATE mtl_txn_request_lines
1345: SET to_subinventory_code = l_to_sub_code,
1346: to_locator_id = l_to_loc_id
1347: WHERE line_id = l_line_id;
1348:
1347: WHERE line_id = l_line_id;
1348:
1349: ELSE
1350:
1351: UPDATE mtl_txn_request_lines
1352: SET to_subinventory_code = Nvl(l_to_sub_code, l_default_ship_staging_sub),
1353: to_locator_id = Nvl(l_to_loc_id, l_default_ship_staging_loc_id)
1354: WHERE line_id = l_line_id;
1355:
1594: SELECT
1595: l.line_id, l.backorder_delivery_detail_id,l.inventory_item_id,Nvl(crossdock_type,1)
1596: ,l.transaction_source_type_id,l.txn_source_id
1597: INTO l_mo_line_id,l_del_id,l_item_id,l_crossdock_type,l_transaction_source_type_id,l_txn_supply_source_id
1598: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t, wsh_delivery_details_ob_grp_v wdd
1599: WHERE t.transaction_temp_id=l_temp_id
1600: AND l.backorder_delivery_detail_id = wdd.delivery_detail_id
1601: AND t.move_order_line_id=l.line_id
1602: AND exists (
1612: SELECT
1613: l.line_id, l.backorder_delivery_detail_id,l.inventory_item_id,Nvl(crossdock_type,1)
1614: ,l.transaction_source_type_id,l.txn_source_id
1615: INTO l_mo_line_id,l_del_id,l_item_id,l_crossdock_type,l_transaction_source_type_id,l_txn_supply_source_id
1616: FROM mtl_txn_request_lines l, mtl_material_transactions_temp t
1617: WHERE t.transaction_temp_id=l_temp_id
1618: AND t.move_order_line_id=l.line_id;
1619:
1620: END;
2773: RETURN;
2774: END IF;
2775:
2776: --Update MOL
2777: UPDATE mtl_txn_request_lines
2778: SET backorder_delivery_detail_id = NULL
2779: , crossdock_type = 1
2780: , quantity_detailed = (quantity - Nvl(quantity_delivered,0))
2781: WHERE line_id = p_move_order_line_id;
2826: INTO l_txn_src_type_id
2827: , l_move_order_line_id
2828: , l_backorder_delivery_detail_id
2829: FROM mtl_material_transactions_temp mmtt
2830: , mtl_txn_request_lines mtrl
2831: , mtl_txn_request_headers mtrh
2832: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
2833: AND mmtt.move_order_line_id = mtrl.line_id
2834: AND mtrh.header_id = mtrl.header_id