Query to get Cycle Count Information of an Item

select
  mp.organization_code "Org",
  cch.cycle_count_header_name "Cycle Count",
  cce.count_list_sequence "Count Seq",
  msi.segment1 "Item",
  cce.abc_class_name "Class",
  cce.subinventory "Subinventory",
  mil.segment1 "Locator",
  cce.lot_number "Lot",
  nvl(cce.count_uom_current, cce.count_uom_prior) "UOM",
  nvl(cce.count_quantity_current, cce.count_quantity_prior) "Count Qty",
  nvl(cce.system_quantity_current, cce.system_quantity_prior) "System Qty",
  cce.adjustment_quantity "Adjust Qty",
  round(cce.adjustment_amount, 2) "Adjust Value",
  nvl(cce.number_of_counts, 0) "# of Cnts",
  cce.creation_date "Count Creation Date",
  cce.count_date_first "First Count Date",
  cce.count_date_prior "Previous Count Date",
  nvl(cce.count_date_current, cce.count_date_prior) "Last Count Date",
  cce.count_status "Status",
  cce.approval_date "Approval Date",
  decode(cce.count_status, 'Rejected', cce.last_update_date, null) "Reject Date"
from
  mtl_cycle_count_entries_v cce,
  mtl_system_items_b msi,
  mtl_cycle_count_headers cch,
  mtl_parameters mp,
  mtl_item_locations mil
where 1=1
  and cce.inventory_item_id = msi.inventory_item_id
  and cce.organization_id = msi.organization_id
  and cce.cycle_count_header_id = cch.cycle_count_header_id
  and cch.organization_id = mp.organization_id
  and cce.locator_id = mil.inventory_location_id(+)
  and msi.segment1 = '&ITEM'   --
  and cce.count_status not in('Completed','Rejected')
order by 1,2,3;