INV ABC descending value

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: ABC descending value report (XML)
Short Name: INVARADV_XML
DB package: INV_INVARADV_XMLP_PKG
select sys.item_number,
       sys.description,
       com.sequence_number,
       com.compile_quantity,
       round (nvl(com.compile_value,0), :C_std_prec)                   
                                                                                      compile_value,     
       to_number(decode (com.compile_quantity,
       0, null, 
       round(com.compile_value / com.compile_quantity,  
                                                      :C_std_prec) ) ) compile_unit_cost,
       sys1.primary_uom_code  uom,
       decode (sys1.planning_make_buy_code,
               null,'', mfg.meaning )   org_code,
   decode(:P_DisplayCumValue,
                             1, round(com.cumulative_value,:C_std_prec),
                             2, com.cumulative_quantity,
               decode(
               decode( hdr.compile_type,  1,1,4,1,5,1,7,1,9,1,10,1,2),
                1, com.cumulative_quantity, 
                   round(com.cumulative_value,:C_std_prec) ))
         cumulative_column,
 decode( :P_DisplayCumValue, 1,2, 2,1, 
        decode(hdr.compile_type,  1,1,4,1,5,1,7,1,9,1,10,1,2)) qty_base
from 
       mfg_lookups   mfg,
       mtl_item_flexfields sys,
       mtl_abc_compile_headers hdr,
       mtl_system_items    sys1,
       mtl_abc_compiles    com
where
       sys.organization_id  = :ORGANIZATION_ID
 and   sys1.organization_id = :ORGANIZATION_ID
 and   com.organization_id  = :ORGANIZATION_ID
 and  com.compile_id  = hdr.compile_id
 and   hdr.organization_id = com.organization_id
 and   com.compile_id       = :COMPILE_ID
 and   com.inventory_item_id = sys.item_id
 and   sys1.inventory_item_id = sys.item_id
 and  ( mfg.lookup_code = decode(sys1.planning_make_buy_code,NULL,2,                                                                                 sys1.planning_make_buy_code)
        and  mfg.lookup_type = 'MTL_PLANNING_MAKE_BUY' )
 ORDER BY com.sequence_number
Ask a question
Parameter Name SQL text Validation
Organization
 
Number
Cumulative Display Criteria
 
LOV Oracle
ABC Compile Header
 
LOV Oracle