[Home] [Help]
442: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
443: AND msi.organization_id = mmtt.organization_id
444: AND msi.enable_bulk_pick = 'Y')
445: OR EXISTS (SELECT 1 -- item is bulk picking enabled
446: FROM mtl_system_items msi
447: WHERE msi.inventory_item_id = mmtt.inventory_item_id
448: AND msi.bulk_picked_flag = 'Y')
449: )
450: for update of mmtt.transaction_temp_id; -- to lock the records
514: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
515: AND msi.organization_id = mmtt.organization_id
516: AND msi.enable_bulk_pick = 'Y')
517: OR EXISTS (SELECT 1 -- item is bulk picking enabled
518: FROM mtl_system_items msi
519: WHERE msi.inventory_item_id = mmtt.inventory_item_id
520: AND msi.bulk_picked_flag = 'Y')
521: )
522: for update of mmtt.transaction_temp_id; -- to lock the records
598: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
599: AND msi.organization_id = mmtt.organization_id
600: AND msi.enable_bulk_pick = 'Y')
601: OR EXISTS (SELECT 1 -- item is bulk picking enabled
602: FROM mtl_system_items msi
603: WHERE msi.inventory_item_id = mmtt.inventory_item_id
604: AND msi.bulk_picked_flag = 'Y')
605: )
606: for update of mmtt.transaction_temp_id; -- to lock the records
742: if (g_trace_on = 1) then -- log_event('PATCHSET J-- BULK PICKING -- START');
743: log_event('checking the lot and serial control code'); end if;
744: select lot_control_code,serial_number_control_code
745: into l_lot_control_code,l_serial_control_code
746: from mtl_system_items_b msi, mtl_material_transactions_temp mmtt
747: where mmtt.transaction_temp_id = mmtt_rec.transaction_Temp_id
748: and mmtt.organization_id = msi.organization_id
749: and msi.inventory_item_id = mmtt.inventory_item_id;
750: if (g_trace_on = 1) then log_event('transaction_temp_id:'|| mmtt_rec.transaction_Temp_id ||
1578: l_ut_vol,
1579: l_std_wt_uom,
1580: l_std_vol_uom
1581: FROM
1582: mtl_system_items
1583: WHERE
1584: organization_id = p_org_id AND
1585: inventory_item_id = x_inventory_item_id;
1586:
2021: l_weight,
2022: l_volume,
2023: l_gross_weight_uom_code,
2024: l_content_volume_uom_code
2025: from mtl_system_items msi
2026: where
2027: inventory_item_id = l_item_id AND
2028: organization_id = l_org_id;
2029:
2945: if (g_trace_on = 1) then log_event('processsing temp_id '||curr_temp_id); END IF;
2946:
2947: select msi.lot_control_code, msi.serial_number_control_code
2948: INTO v_lot_control_code, v_serial_control_code
2949: from mtl_system_items msi where
2950: (msi.inventory_item_id, msi.organization_id) =
2951: (
2952: select mmtt.inventory_item_id, mmtt.organization_id from
2953: wms_cartonization_temp mmtt WHERE mmtt.transaction_temp_id = curr_temp_id
3058:
3059: SELECT 'Y' INTO l_ret
3060: FROM dual WHERE exists
3061: (SELECT inventory_item_id
3062: FROM MTL_SYSTEM_ITEMS
3063: WHERE ORGANIZATION_ID = p_org_id
3064: AND INVENTORY_ITEM_ID = p_item_id
3065: AND mtl_transactions_enabled_flag = 'Y'
3066: AND enabled_flag = 'Y');
3816: INTO
3817: l_revision_code,
3818: l_lot_code,
3819: l_serial_code
3820: FROM mtl_system_items
3821: WHERE organization_id = v1.organization_id
3822: AND inventory_item_id = v1.inventory_item_id;
3823:
3824: if l_revision_code> 1 then
3941:
3942: end if;
3943:
3944: error_code := 'CARTONIZE 170';
3945: SELECT primary_uom_code INTO v_primary_uom_code FROM mtl_system_items
3946: WHERE inventory_item_id = v1.inventory_item_id AND
3947: organization_id = v1.ORGANIZATION_ID;
3948:
3949: if ( v1.content_lpn_id is not null ) THEN
4108: ELSE
4109:
4110: select msi.serial_number_control_code
4111: INTO v_serial_control_code
4112: from mtl_system_items msi
4113: where
4114: msi.inventory_item_id = v1.inventory_item_id AND
4115: msi.organization_id = v1.organization_id;
4116:
5560: msi.lot_control_code
5561: INTO
5562: l_serial_code,
5563: l_lot_code
5564: FROM mtl_system_items msi
5565: WHERE msi.inventory_item_id = p_mmtt_row.inventory_item_id
5566: AND msi.organization_id = p_mmtt_row.organization_id;
5567:
5568: