APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 2437: FROM mtl_system_items

2433: END IF;
2434:
2435: IF l_no_info THEN
2436: SELECT Nvl(reservable_type,2) INTO l_reservable_type
2437: FROM mtl_system_items
2438: WHERE organization_id = p_organization_id
2439: AND inventory_item_id = p_inventory_item_id;
2440: g_is_item_reservable(p_inventory_item_id).org_id := p_organization_id;
2441: IF (l_reservable_type = 1) THEN

Line 10299: FROM mtl_system_items

10295: SELECT NVL(grade_control_flag, 'N')
10296: , NVL(lot_control_code, 1)
10297: , tracking_quantity_ind
10298: , lot_status_enabled
10299: FROM mtl_system_items
10300: WHERE inventory_item_id = item_id
10301: AND organization_id = org_id;
10302:
10303: -- invConv changes end