CST Period Close Subinventory Value Summary

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Summary report that lists selected ledgers and operating units with corresponding sub inventory code and Inventory value.With Ledger export capability.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
oap.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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 to G/L Reconciliation (Restricted by Org Access) CAC Inventory Out-of-Balance CST Period Close Subinventory Value CAC Missing Material Accounting Transactions CAC ICP PII vs. Item Costs CAC Inventory Pending Cost Adjustment - No Currencies CAC ICP PII Inventory Pending Cost Adjustment CAC Inventory and Intransit Value (Period-End) CAC ICP PII Inventory and Intransit Value (Period-End)
Blitz Report™

Blitz Report™ provides multiple benefits: