APPS.WMS_POSTALLOC_PVT dependencies on MTL_SYSTEM_ITEMS

Line 2716: FROM mtl_system_items

2712: , serial_number_control_code
2713: INTO l_revision_code
2714: , l_lot_code
2715: , l_serial_code
2716: FROM mtl_system_items
2717: WHERE organization_id = v1.organization_id
2718: AND inventory_item_id = v1.inventory_item_id;
2719:
2720: IF l_revision_code > 1 THEN

Line 2828: FROM mtl_system_items

2824:
2825: error_code := 'CARTONIZE 170';
2826: SELECT primary_uom_code
2827: INTO v_primary_uom_code
2828: FROM mtl_system_items
2829: WHERE inventory_item_id = v1.inventory_item_id
2830: AND organization_id = v1.ORGANIZATION_ID;
2831:
2832: IF v1.content_lpn_id IS NOT NULL THEN

Line 2979: FROM mtl_system_items msi

2975: END IF;
2976: ELSE --{
2977: SELECT msi.serial_number_control_code
2978: INTO v_serial_control_code
2979: FROM mtl_system_items msi
2980: WHERE msi.inventory_item_id = v1.inventory_item_id
2981: AND msi.organization_id = v1.organization_id;
2982:
2983: IF ((v_serial_control_code NOT IN (1,6))

Line 3731: FROM mtl_system_items msi

3727: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
3728: AND msi.organization_id = mmtt.organization_id
3729: AND msi.enable_bulk_pick= 'Y' )
3730: OR EXISTS( SELECT 1 -- item is bulk picking enabled
3731: FROM mtl_system_items msi
3732: WHERE msi.inventory_item_id = mmtt.inventory_item_id
3733: AND msi.organization_id = mmtt.organization_id
3734: AND msi.bulk_picked_flag = 'Y' )
3735: )

Line 3808: FROM mtl_system_items msi

3804: WHERE msi.secondary_inventory_name = mmtt.subinventory_code
3805: AND msi.organization_id = mmtt.organization_id
3806: AND msi.enable_bulk_pick= 'Y' )
3807: OR EXISTS( SELECT 1 -- item is bulk picking enabled
3808: FROM mtl_system_items msi
3809: WHERE msi.inventory_item_id = mmtt.inventory_item_id
3810: AND msi.organization_id = mmtt.organization_id
3811: AND msi.bulk_picked_flag = 'Y' )
3812: )

Line 4335: , mtl_system_items item

4331: , l_serial_number_control_code
4332: FROM mtl_material_transactions_temp mmtt
4333: , mtl_item_locations mil
4334: , mtl_secondary_inventories msi
4335: , mtl_system_items item
4336: WHERE mmtt.transaction_temp_id = p_mmtt_temp_id
4337: AND mmtt.locator_id = mil.inventory_location_id(+)
4338: AND mmtt.organization_id = mil.organization_id(+)
4339: AND mmtt.subinventory_code = msi.secondary_inventory_name

Line 4540: FROM mtl_system_items msi

4536: INTO l_equip_v_uom
4537: , l_equip_w_uom
4538: , l_equip_weight
4539: , l_equip_vol
4540: FROM mtl_system_items msi
4541: WHERE msi.organization_id = l_organization_id
4542: AND msi.inventory_item_id = l_eqp_id;
4543:
4544: -- Cache equipment attributes