INV Physical inventory adjustments

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Physical inventory adjustments report (XML)
Short Name: INVARPAR_XML
DB package: INV_INVARPAR_XMLP_PKG
select decode(:P_break_id,1,nvl(subinventory_name,' '),
              'X')        Break_option,
       &P_item_flex       C_item_flex,
       mpa.revision       Rev,
       subinventory_name  Subinv,
       &P_loc_flex        C_loc_flex,
       lot_number,
       serial_number,   
       system_quantity,
       nvl(count_quantity,0),
       msi.primary_uom_code UOM,
       adjustment_quantity,
       nvl(system_quantity*mpa.actual_cost,0)   system_value,
       round(nvl(count_quantity*mpa.actual_cost,0) ,:C_std_prec)   count_value,
 round(nvl(adjustment_quantity*mpa.actual_cost,0),:C_std_prec)   adjustment_value,
       loc.inventory_location_id       loc_id,
       rownum,
      decode(:P_break_id,2,nvl(subinventory_name,' '),
              'X')        second_sort_option,
      mpa.outermost_lpn_id,
      mpa.parent_lpn_id,
      mpa.cost_group_id,
      mpa.APPROVED_BY_EMPLOYEE_ID emp_id, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_field, 
        nvl2(mpa.locator_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_loc_field', 'INV', 'MTLL', 101, LOC.ORGANIZATION_ID, LOC.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE'), null) C_loc_field,
	INV_INVARPAR_XMLP_PKG.cf_outermost_lpnformula(mpa.outermost_lpn_id) CF_OUTERMOST_LPN, 
	INV_INVARPAR_XMLP_PKG.cf_parent_lpnformula(mpa.parent_lpn_id) CF_PARENT_LPN, 
	INV_INVARPAR_XMLP_PKG.cf_cost_groupformula(mpa.cost_group_id) CF_COST_GROUP, 
	INV_INVARPAR_XMLP_PKG.cf_approverformula(mpa.APPROVED_BY_EMPLOYEE_ID) CF_APPROVER
from 
       mtl_system_items