APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on AHL_MR_ITEMS_V

Line 282: SELECT COUNT(*) FROM Ahl_MR_Items_V

278: l_org_id NUMBER;
279:
280: -- To find out Item and MR Header Id combination exists
281: CURSOR c_check(c_item_id IN NUMBER, c_mr_header_id IN NUMBER) IS
282: SELECT COUNT(*) FROM Ahl_MR_Items_V
283: WHERE Inventory_Item_ID = c_item_id AND MR_HEADER_ID = c_mr_header_id;
284:
285: -- To find visit related information
286: CURSOR c_visit(c_visit_id IN NUMBER) IS

Line 385: -- This check in Ahl_MR_Items_V for a valid item/MR does not cover all cases

381: p_x_task_Rec.inventory_item_id := l_item_id;
382: p_x_task_Rec.item_organization_id := l_org_id;
383:
384: /* Begin fix for Bug 4081044 on Dec 22, 2004 by JR */
385: -- This check in Ahl_MR_Items_V for a valid item/MR does not cover all cases
386: -- viz. MR/PC and MR/Position. So disabling this check for now.
387: -- If a validation is required, then all application cases should also be handled
388: /******
389: IF l_item_id IS NOT NULL AND p_x_task_Rec.MR_Id IS NOT NULL THEN