APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on MTL_SYSTEM_ITEMS

Line 788: FROM mtl_system_items

784: INTO
785: l_primary_uom,
786: l_lot_code,
787: l_serial_code
788: FROM mtl_system_items
789: WHERE organization_id = p_org_id
790: AND inventory_item_id = p_item_id;
791:
792:

Line 3127: FROM mtl_system_items

3123:
3124: -- Getting info about item being lot/Serial controlled
3125: SELECT lot_control_code,serial_number_control_code,primary_uom_code
3126: INTO l_lot_code,l_serial_code,l_primary_uom
3127: FROM mtl_system_items
3128: WHERE organization_id = l_rec.organization_id
3129: AND inventory_item_id = l_inventory_item_id;
3130: IF (l_debug = 1) THEN
3131: trace('l_lot_code := '||l_lot_code||':l_serial_code:='||l_serial_code);