CST Period Close Subinventory Value Summary

➜ Back to Library
Description
Categories: Enginatics, Kcapps
Repository: Github
Summary report that lists selected ledgers and operating units with corresponding sub inventory code and Inventory value.With Ledger export capability.
Run CST Period Close Subinventory Value Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
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_ledgers gl,
org_organization_definitions ood,
mtl_secondary_inventories msi,
org_acct_periods oap
where
1=1 and
gl.ledger_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
Ledger 
gl.name=:ledger
 LOV
Organization Code 
ood.organization_code=:organization_code
 LOV
Period 
oap.period_name=:period
 LOV
Download
 
Related Blitz Reports
CAC Inventory Out-of-Balance CST Period Close Subinventory Value CAC Missing Material Accounting Transactions CAC Inventory to G/L Reconciliation (Unrestricted by Org Access) CAC Inventory Pending Cost Adjustment CAC ICP PII Inventory Pending Cost Adjustment CAC Inventory and Intransit Value (Period-End) CAC Inventory to G/L Reconciliation (Restricted by Org Access) CAC ICP PII Inventory and Intransit Value (Period-End)
Blitz Report™

Blitz Report™ provides multiple benefits: