CST Period Close Subinventory Value Summary

Description
Categories: Enginatics, Toolkit - Operations
Repository: Github Columns: Period, Ledger, Org, Organization Code, Subinventory, Subinventory Description, Inventory Value ...
Summary report that lists selected ledgers and operating units with corresponding sub inventory code and Inventory value.With Ledger export capability.
select
x.period,
x.ledger,
x.organization,
x.organization_code,
x.subinventory,
x.subinventory_description,
nvl(cpsv.inventory_value,0) inventory_value
from
(
select
oap.period_name period,
gl.name ledger,
ood.organization_name organization,
ood.organization_code,
msi.secondary_inventory_name subinventory,
msi.description subinventory_description,
oap.acct_period_id,
ood.organization_id
from
gl_sets_of_books gl,
org_organization_definitions ood,
mtl_secondary_inventories msi,
org_acct_periods oap
where
1=1 and
gl.set_of_books_id=ood.set_of_books_id and
ood.organization_id=msi.organization_id and
ood.organization_id=oap.organization_id
) x,
(
select
cpsv.acct_period_id,
cpsv.organization_id,
cpsv.secondary_inventory,
cpsv.description,
nvl(sum(cpsv.inventory_value),0) inventory_value
from
cst_period_summary_v cpsv
group by
cpsv.acct_period_id,
cpsv.organization_id,
cpsv.secondary_inventory,
cpsv.description
) cpsv
where
x.acct_period_id=cpsv.acct_period_id(+) and
x.organization_id=cpsv.organization_id(+) and
x.subinventory=cpsv.secondary_inventory(+)
order by
x.period,
x.ledger,
x.organization_code,
x.subinventory
Parameter Name SQL text Validation
Period
oap.period_name=:period
LOV
Ledger
gl.name=:ledger
LOV
Organization Code
ood.organization_code=:organization_code
LOV