[Home] [Help]
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;
1386: INTO l_prim_qty ,l_item_id,l_sub,
1387: l_loc,l_rev,l_transaction_type_id,
1388: l_transfer_lpn_id,l_cnt_lpn_id,l_prim_uom
1389: ,l_lot_control_code, l_serial_control_code
1390: FROM mtl_material_transactions_temp t,
1391: mtl_system_items i
1392: WHERE t.transaction_temp_id=l_temp_id
1393: AND t.organization_id=l_org_id
1394: AND t.organization_id =i.organization_id
2469: , mtrl.backorder_delivery_detail_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