INV Physical inventory accuracy analysis

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Physical inventory accuracy analysis
Application: Inventory
Source: Physical inventory accuracy analysis (XML)
Short Name: INVARPIA_XML
DB package: INV_INVARPIA_XMLP_PKG
Run INV Physical inventory accuracy analysis and other Oracle EBS reports with Blitz Report™ on our demo environment
select &P_cat_flex        C_cat_flex,
          &P_cat_sort        C_cat_sort,
       &P_item_flex       C_item_flex,  
       mpav.revision       rev,
       round(system_quantity,:P_qty_precision) system_quantity,
       msi.primary_uom_code UOM,
       round(nvl(count_quantity,0), :P_qty_precision) count_quantity,
       round(adjustment_quantity,:P_qty_precision) adjustment_quantity,
       round(nvl(system_quantity*mpav.actual_cost,0),:C_std_prec)   system_value,
       round(nvl(count_quantity*mpav.actual_cost,0),:C_std_prec)    count_value,
       round(nvl(nvl(count_quantity*mpav.actual_cost,0) -
       system_quantity*mpav.actual_cost,0),:C_std_prec)   adjustment_value,
      decode (round(nvl(count_quantity*mpav.actual_cost,0),:C_std_prec),  0,  0,
                    (round(nvl(nvl(count_quantity*mpav.actual_cost,0) -
                    system_quantity*mpav.actual_cost,0),:C_std_prec) *  
       100/round(nvl(count_quantity*mpav.actual_cost,0),:C_std_prec))) adj_percent, 
	&C_cat_pad C_cat_pad, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_field', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_cat_field, 
	INV_INVARPIA_XMLP_PKG.c_adj_per_catformula(:C_cnt_val_cat, :C_adj_val_cat, :C_std_prec) C_adj_per_cat, 
	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
from   
       mtl_system_items           msi,
       mtl_item_categories        mic,
       mtl_categories              mc,
       mtl_phy_adj_cost_v  mpav
where  mic.category_id = mc.category_id
and    mic.category_set_id = :P_category_set_id
and    msi.organization_id = mic.organization_id
and    mic.organization_id = mpav.organization_id
and    mic.inventory_item_id = msi.inventory_item_id
and    mpav.inventory_item_id = mic.inventory_item_id
and    mpav.organization_id = :P_org_id
and    (nvl(count_quantity,0) <> 0 or  nvl(system_quantity,0) <> 0)
and    mpav.physical_inventory_id = :P_phys_inv_id
-- P_condition this does not do any thing
&P_include_rej_items_opt
order by C_cat_field ASC,nvl(count_quantity*mpav.actual_cost-system_quantity*mpav.actual_cost,0) &C_sort, &P_order_item
Parameter Name SQL text Validation
Category Set 
 
 LOV Oracle
Physical Inventory 
 
 LOV Oracle
Adjustment Value Sort Option 
 
 LOV Oracle
Include Rejected Items 
 
 LOV Oracle
Download
 
Related Blitz Reports
INV Physical inventory counts PO Purchase Price Variance INV Transaction Historical Summary CAC ICP PII Inventory and Intransit Value (Period-End) CST Item Costs CAC Inventory and Intransit Value (Period-End) CST Item Cost Reports MRP Order Reschedule MRP Supply Chain Order Reschedule
Blitz Report™

Blitz Report™ provides multiple benefits: