[Home] [Help]
1208: , 0 -- SECONDARY_TRANSACTION_QUANTITY
1209: );
1210:
1211: IF p_lot_number IS NOT NULL THEN
1212: INSERT INTO mtl_transaction_lots_temp(
1213: transaction_temp_id
1214: , last_update_date
1215: , last_updated_by
1216: , creation_date
1408: CURSOR c_lpn_lot_pri_qty IS
1409: SELECT SUM(mtlt.primary_quantity)
1410: , SUM(mtlt.secondary_quantity)
1411: FROM mtl_material_transactions_temp mmtt
1412: , mtl_transaction_lots_temp mtlt
1413: WHERE (mmtt.content_lpn_id = p_lpn_id
1414: OR mmtt.transfer_lpn_id = p_lpn_id)
1415: AND mmtt.inventory_item_id = p_inventory_item_id
1416: AND mmtt.parent_line_id IS NULL
1438: , mmtt.move_order_line_id
1439: , mtlt.primary_quantity
1440: , mtlt.secondary_quantity
1441: FROM mtl_material_transactions_temp mmtt
1442: , mtl_transaction_lots_temp mtlt
1443: WHERE (mmtt.content_lpn_id = p_lpn_id
1444: OR mmtt.transfer_lpn_id = p_lpn_id)
1445: AND mmtt.inventory_item_id = p_inventory_item_id
1446: AND mmtt.parent_line_id IS NULL
1489:
1490: CURSOR c_lot_rsv_qty(p_rsv_id IN NUMBER) IS
1491: SELECT NVL(SUM(mtlt.primary_quantity),0)
1492: FROM mtl_material_transactions_temp mmtt
1493: , mtl_transaction_lots_temp mtlt
1494: , mtl_lot_numbers mln
1495: , mtl_secondary_inventories msi
1496: , mtl_item_locations mil
1497: WHERE mmtt.reservation_id = p_rsv_id
2736: , 4);
2737: END IF;
2738:
2739: IF p_lot_number IS NOT NULL THEN
2740: UPDATE mtl_transaction_lots_temp
2741: SET primary_quantity = primary_quantity - l_sku_pri_decr
2742: WHERE transaction_temp_id = t_temp_id(i)
2743: AND lot_number = p_lot_number;
2744: END IF;
3049: END IF;
3050: END IF; --} end if l_att < l_sku_pri_incr
3051:
3052: IF p_lot_number IS NOT NULL THEN
3053: UPDATE mtl_transaction_lots_temp
3054: SET primary_quantity = primary_quantity + l_sku_pri_incr
3055: WHERE transaction_temp_id = t_temp_id(j)
3056: AND lot_number = p_lot_number;
3057: IF (l_debug = 1) THEN
3333: AND NVL(content_lpn_id, transfer_lpn_id) = p_lpn_id;
3334:
3335: CURSOR mtlt_cur(p_trx_temp_id NUMBER) IS
3336: SELECT rowid, transaction_quantity
3337: FROM mtl_transaction_lots_temp
3338: WHERE transaction_temp_id = p_trx_temp_id
3339: AND lot_number = p_lot_number;
3340:
3341: l_del_det_id NUMBER;
3462: ELSE -- p_lot_number is not null
3463: l_progress := '600';
3464: IF ( p_secondary_quantity IS NULL ) THEN
3465: -- Caller wants to null out all secondary_quantity for this lot
3466: UPDATE mtl_transaction_lots_temp
3467: SET secondary_quantity = NULL,
3468: secondary_unit_of_measure = NULL
3469: WHERE lot_number = p_lot_number
3470: AND transaction_temp_id IN (
3510: ELSE
3511: l_line_quantity := mtlt_rec.transaction_quantity;
3512: END IF;
3513:
3514: UPDATE mtl_transaction_lots_temp
3515: SET secondary_quantity = round(p_secondary_quantity*(l_line_quantity/p_quantity), g_precision),
3516: secondary_unit_of_measure = p_secondary_uom_code
3517: WHERE rowid = mtlt_rec.rowid;
3518:
3803: BEGIN
3804: SELECT 1 INTO l_temp FROM DUAL
3805: WHERE EXISTS (
3806: SELECT 1
3807: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
3808: WHERE mmtt.organization_id = mmtt_item_rec.organization_id
3809: AND mmtt.inventory_item_id = mmtt_item_rec.inventory_item_id
3810: AND mmtt.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder
3811: AND mmtt.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr
4273: OPEN x_lpn_lov FOR
4274: SELECT distinct wlpn.license_plate_number, mmtt.content_lpn_id
4275: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
4276: ,wms_license_plate_numbers wlpn
4277: ,mtl_transaction_lots_temp mtlt
4278: WHERE mmtt.transfer_lpn_id = p_outer_lpn_id
4279: AND mmtt.organization_id = p_org_id
4280: AND mmtt.parent_line_id IS NULL
4281: AND mmtt.organization_id = msi.organization_id