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           msi,
       mtl_item_locations         loc,
       mtl_physical_adjustments   mpa
where mpa.inventory_item_id = 
       msi.inventory_item_id
and    mpa.locator_id =  
       loc.inventory_location_id(+)
and    mpa.organization_id = msi.organization_id
and  mpa.organization_id   =       
        loc.organization_id(+)
and    mpa.organization_id = :P_org_id
and    mpa.physical_inventory_id = :P_phys_inv_id
and    mpa.adjustment_quantity <> 0
&p_include_rej_items_opt
-- P_condition does not do anything
order by
1,  (nvl(count_quantity*mpa.actual_cost, 0)-nvl(system_quantity*mpa.actual_cost,0)) &C_sort,  17 asc, 2 asc, 3 asc, 5 asc, 6 asc, 7 asc
Parameter NameSQL textValidation
Dynamic Precision Option
 
LOV Oracle
Organization
 
Number
Physical Inventory
 
LOV Oracle
Adjustment Value Sort Option
 
LOV Oracle
Include Rejected Items
 
LOV Oracle
Display and Break on Subinventory
 
LOV Oracle