EBS QUERY TO FIND INVENTORY CYCLE COUNT

SELECT To_char(mtl_cycle_count_entries.cycle_count_entry_id) cycle_count_entry_id,
       hr_all_organization_units.name                        organization_name,
       mtl_system_items_b.segment1                           inventory_item,
       CASE
              WHEN mtl_cycle_count_classes.hit_miss_tolerance_negative IS NULL THEN mtl_cycle_count_headers.hit_miss_tolerance_negative
              ELSE mtl_cycle_count_classes.hit_miss_tolerance_negative
       END hit_miss_tolerance_negative,
       CASE
              WHEN mtl_cycle_count_classes.hit_miss_tolerance_positive IS NULL THEN mtl_cycle_count_headers.hit_miss_tolerance_positive
              ELSE mtl_cycle_count_classes.hit_miss_tolerance_positive
       END hit_miss_tolerance_positive
FROM   apps.mtl_cycle_count_entries,
       apps.mtl_cycle_count_classes,
       apps.mtl_cycle_count_headers,
       apps.mtl_cycle_count_items,
       apps.hr_all_organization_units,
       apps.mtl_system_items_b
WHERE  mtl_cycle_count_entries.organization_id = mtl_cycle_count_classes.organization_id
AND    mtl_cycle_count_entries.cycle_count_header_id = mtl_cycle_count_classes.cycle_count_header_id
AND    mtl _cycle_count_entries.cycle_count_header_id = mtl_cycle_count_headers.cycle_count_header_id
AND    mtl_cycle_count_entries.inventory_item_id = mtl_cycle_count_items.inventory_item_id
AND    mtl_cycle_count_entries.cycle_count_header_id = mtl_cycle_count_items.cycle_count_header_id
AND    mtl_cycle_count_classes.abc_class_id = mtl_cycle_count_items.abc_class_id
AND    mtl_cycle_count_entries.organization_id = hr_all_organization_units.organization_id
AND    mtl_cycle_count_entries.inventory_item_id = mtl_system_items_b.inventory_item_id;