[Home] [Help]
541: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
542: AND msi.organization_id = mmtt.organization_id
543: AND msi.enable_bulk_pick = 'Y')
544: OR EXISTS (SELECT 1 -- item is bulk picking enabled
545: FROM mtl_system_items msi
546: WHERE msi.inventory_item_id = mmtt.inventory_item_id
547: AND msi.bulk_picked_flag = 'Y')
548: )
549: for update of mmtt.transaction_temp_id; -- to lock the records
611: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
612: AND msi.organization_id = mmtt.organization_id
613: AND msi.enable_bulk_pick = 'Y')
614: OR EXISTS (SELECT 1 -- item is bulk picking enabled
615: FROM mtl_system_items msi
616: WHERE msi.inventory_item_id = mmtt.inventory_item_id
617: AND msi.bulk_picked_flag = 'Y')
618: )
619: for update of mmtt.transaction_temp_id; -- to lock the records
693: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
694: AND msi.organization_id = mmtt.organization_id
695: AND msi.enable_bulk_pick = 'Y')
696: OR EXISTS (SELECT 1 -- item is bulk picking enabled
697: FROM mtl_system_items msi
698: WHERE msi.inventory_item_id = mmtt.inventory_item_id
699: AND msi.bulk_picked_flag = 'Y')
700: )
701: for update of mmtt.transaction_temp_id; -- to lock the records
837: if (g_trace_on = 1) then -- log_event('PATCHSET J-- BULK PICKING -- START');
838: log_event('checking the lot and serial control code'); end if;
839: select lot_control_code,serial_number_control_code
840: into l_lot_control_code,l_serial_control_code
841: from mtl_system_items_b msi, mtl_material_transactions_temp mmtt
842: where mmtt.transaction_temp_id = mmtt_rec.transaction_Temp_id
843: and mmtt.organization_id = msi.organization_id
844: and msi.inventory_item_id = mmtt.inventory_item_id;
845: if (g_trace_on = 1) then log_event('transaction_temp_id:'|| mmtt_rec.transaction_Temp_id ||
1671: l_ut_vol,
1672: l_std_wt_uom,
1673: l_std_vol_uom
1674: FROM
1675: mtl_system_items
1676: WHERE
1677: organization_id = p_org_id AND
1678: inventory_item_id = x_inventory_item_id;
1679:
2094: l_weight,
2095: l_volume,
2096: l_gross_weight_uom_code,
2097: l_content_volume_uom_code
2098: from mtl_system_items msi
2099: where
2100: inventory_item_id = l_item_id AND
2101: organization_id = l_org_id;
2102:
2965: if (g_trace_on = 1) then log_event('processsing temp_id '||curr_temp_id); END IF;
2966:
2967: select msi.lot_control_code, msi.serial_number_control_code
2968: INTO v_lot_control_code, v_serial_control_code
2969: from mtl_system_items msi where
2970: (msi.inventory_item_id, msi.organization_id) =
2971: (
2972: select mmtt.inventory_item_id, mmtt.organization_id from
2973: wms_cartonization_temp mmtt WHERE mmtt.transaction_temp_id = curr_temp_id
3078:
3079: SELECT 'Y' INTO l_ret
3080: FROM dual WHERE exists
3081: (SELECT inventory_item_id
3082: FROM MTL_SYSTEM_ITEMS
3083: WHERE ORGANIZATION_ID = p_org_id
3084: AND INVENTORY_ITEM_ID = p_item_id
3085: AND mtl_transactions_enabled_flag = 'Y'
3086: AND enabled_flag = 'Y');
3834: INTO
3835: l_revision_code,
3836: l_lot_code,
3837: l_serial_code
3838: FROM mtl_system_items
3839: WHERE organization_id = v1.organization_id
3840: AND inventory_item_id = v1.inventory_item_id;
3841:
3842: if l_revision_code> 1 then
3959:
3960: end if;
3961:
3962: error_code := 'CARTONIZE 170';
3963: SELECT primary_uom_code INTO v_primary_uom_code FROM mtl_system_items
3964: WHERE inventory_item_id = v1.inventory_item_id AND
3965: organization_id = v1.ORGANIZATION_ID;
3966:
3967: if ( v1.content_lpn_id is not null ) THEN
4126: ELSE
4127:
4128: select msi.serial_number_control_code
4129: INTO v_serial_control_code
4130: from mtl_system_items msi
4131: where
4132: msi.inventory_item_id = v1.inventory_item_id AND
4133: msi.organization_id = v1.organization_id;
4134:
5524: msi.lot_control_code
5525: INTO
5526: l_serial_code,
5527: l_lot_code
5528: FROM mtl_system_items msi
5529: WHERE msi.inventory_item_id = p_mmtt_row.inventory_item_id
5530: AND msi.organization_id = p_mmtt_row.organization_id;
5531:
5532: