INV Physical inventory adjustments

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Physical inventory adjustments report
Application: Inventory
Source: Physical inventory adjustments report (XML)
Short Name: INVARPAR_XML
DB package: INV_INVARPAR_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 Name SQL text Validation
Display and Break on Subinventory
 
LOV Oracle
Include Rejected Items
 
LOV Oracle
Adjustment Value Sort Option
 
LOV Oracle
Physical Inventory
 
LOV Oracle