APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1308: FROM mtl_system_items

1304: INTO
1305: l_primary_uom,
1306: l_lot_code,
1307: l_serial_code
1308: FROM mtl_system_items
1309: WHERE organization_id = p_org_id
1310: AND inventory_item_id = p_item_id;
1311:
1312:

Line 3672: FROM mtl_system_items

3668:
3669: -- Getting info about item being lot/Serial controlled
3670: SELECT lot_control_code,serial_number_control_code,primary_uom_code
3671: INTO l_lot_code,l_serial_code,l_primary_uom
3672: FROM mtl_system_items
3673: WHERE organization_id = l_rec.organization_id
3674: AND inventory_item_id = l_inventory_item_id;
3675: IF (l_debug = 1) THEN
3676: trace('l_lot_code := '||l_lot_code||':l_serial_code:='||l_serial_code);

Line 4521: FROM mtl_system_items_b

4517:
4518: /* changes for bug 8197536 */
4519: select dual_uom_control,secondary_uom_code
4520: into l_dual_uom_control,l_secondary_uom
4521: FROM mtl_system_items_b
4522: where inventory_item_id = l_inventory_item_id
4523: and organization_id = l_rec.organization_id;
4524: if(l_dual_uom_control <> 1)
4525: THEN