CST Periodic Incremental LIFO Valuation

Description

Categories
BI Publisher
Application
Bills of Material
Source
Periodic Incremental LIFO Valuation Report (XML)
Short Name
CSTGILEV_XML
DB package
BOM_CSTGILEV_XMLP_PKG

SQL 18 lines

SELECT   
     item_id
   , item_desc
   , period_id
   , period_name
   , wac
   , lifo_cost
   , market_value
   , justification
   , layer_quantity
   , total_layer_quantity
   , item_code
   , uom_code
   , inventory_value
   , total_inventory_value
FROM 
   cstgilev_temp

Parameters 10

ParameterTypeList of values SQL
Detailed ReportLOV Oracle
Legal EntityLOV Oracle
Cost TypeLOV Oracle
PeriodLOV Oracle
Cost GroupLOV Oracle
Item FromChar
Item ToChar
Quantity PrecisionNumber
Cost PrecisionNumber
Value PrecisionNumber