APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 295: FROM mtl_system_items_b mtl, csi_item_instances csi

291: -- Added by rnahata for Issue 105
292: -- To fetch if the instance is serial controlled/non-serial controlled.
293: CURSOR c_check_inst_nonserial(c_instance_id IN NUMBER) IS
294: SELECT 'X'
295: FROM mtl_system_items_b mtl, csi_item_instances csi
296: WHERE csi.instance_id = c_instance_id
297: AND csi.inventory_item_id = mtl.inventory_item_id
298: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
299: AND mtl.serial_number_control_code = 1;