CST Period Close Subinventory Value

Description

Categories
Enginatics
Repository
GitHub
Summary report that lists selected operating units with corresponding sub inventory code and Inventory value on a historic basis.

SQL 104 lines

Parameters 6

ParameterTypeList of values SQL
LedgerLOV
gl.name=:ledger
Organization CodeLOV
ood.organization_code=:organization_code
PeriodLOV
oap.period_name=:period
Category Set 1LOV
select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'cpcs') sql_text from dual
Category Set 2LOV
select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'cpcs') sql_text from dual
Show Last PO PriceLOV
Y