INV Cycle count hit/miss analysis

Description
Categories: BI Publisher
Columns: Cycle Count Entry Id, Subinventory, Abc Class Name, Entryflag, Sys Quantity, Pos Tol, Neg Tol, Adj Quantity, Serial Detail, Serial Number ...
Application: Inventory
Source: Cycle count hit/miss analysis (XML)
Short Name: INVARHMA_XML
DB package: INV_INVARHMA_XMLP_PKG
select  
      cce.cycle_count_entry_id,
      cce.subinventory                       Subinventory,
      abc.abc_class_name,
      1                                                   EntryFlag,
      cce.system_quantity_first        sys_quantity,
      nvl(cla.hit_miss_tolerance_positive, cch.hit_miss_tolerance_positive)    pos_tol,
      nvl(cla.hit_miss_tolerance_negative, cch.hit_miss_tolerance_negative)   neg_tol,
      (cce.count_quantity_first  -  
                             cce.system_quantity_first)
                                                           adj_quantity,
      serial_detail,
      serial_number, 
	INV_INVARHMA_XMLP_PKG.fs_accuracypercentformula(:SS_TotalEn