INV Physical inventory trend and summary analysis

Description
Categories: BI Publisher, Logistics
Columns: Pi Date, Subinv, System Value, Count Value, Adjmnt Value, Absolute Variance, Num Tags, Num Txns, C Adj Pct, C Var Pct ...
Application: Inventory
Source: Physical inventory trend and summary analysis (XML)
Short Name: INVARPTS_XML
DB package: INV_INVARPTS_XMLP_PKG
SELECT   decode(:P_report_option,1,MPI.PHYSICAL_INVENTORY_DATE ,sysdate)    PI_DATE,
         MPA.SUBINVENTORY_NAME           SUBINV,
         ROUND(SUM(MPA.SYSTEM_QUANTITY * nvl(MPA.ACTUAL_COST,0)),:C_std_prec)        SYSTEM_VALUE,
         ROUND(SUM(NVL(MPA.COUNT_QUANTITY,0) *  nvl(MPA.ACTUAL_COST,0)),:C_std_prec) COUNT_VALUE,
         ROUND(SUM((NVL(MPA.COUNT_QUANTITY,0)-MPA.SYSTEM_QUANTITY) 
             * nvl(MPA.ACTUAL_COST,0)),:C_std_prec)                           ADJMNT_VALUE,
         ROUND(SUM(ABS(NVL(MPA.COUNT_QUANTITY,0)-SYSTEM_QUANTITY)
             * nvl(MPA.ACTUAL_COST,0)),:C_std_prec)                            ABSOLUTE_VARIANCE,
         0                                           NUM_TAGS,
         COUNT  ( DECODE(MPA.ADJUSTMENT_QUANTITY,0,NULL,MPA.ADJUSTMENT_QUANTITY))     NUM_TXNS, 
	INV_INVARPTS_XMLP_PKG.c_adj_pctformula(ROUND ( SUM ( ( NVL ( MPA.COUNT_QUANTITY , 0 ) - MPA.SYSTEM_QUANTITY ) * nvl ( MPA.ACTUAL_COST , 0 ) ) , :C_std_prec ), ROUND ( SUM ( NVL ( MPA.COUNT_QUANTITY , 0 ) * nvl ( MPA.ACTUAL_COST , 0