INV Period close value summary

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Period close value summary
Application: Inventory
Source: Period close value summary (XML)
Short Name: INVTRCLS_XML
DB package: INV_INVTRCLS_XMLP_PKG
Run INV Period close value summary and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT secondary_inventory subinventory,
       description description,
       --ROUND(SUM(NVL(CPSV.inventory_value,0)),:c_std_prec) SUM_CPSV_INVENTORY_VALUE
       ROUND(SUM(NVL(CPSV.inventory_value,0)),2) SUM_CPSV_INVENTORY_VALUE
       FROM   cst_period_summary_v CPSV
WHERE  CPSV.organization_id = :P_ORG_ID
AND    CPSV.acct_period_id = :C_ACCT_PERIOD_ID
GROUP
BY     secondary_inventory,
       description
UNION ALL
SELECT secondary_inventory_name,
       description,
       0
FROM   mtl_secondary_inventories MSI
WHERE  MSI.organization_id = :P_ORG_ID
AND    NOT EXISTS (
         SELECT 'X'
         FROM   cst_period_summary_v CPSV
         WHERE  CPSV.organization_id = MSI.organization_id
         AND    CPSV.secondary_inventory = MSI.secondary_inventory_name
         AND    CPSV.acct_period_id = :C_ACCT_PERIOD_ID
       )
&C_order_by
Parameter Name SQL text Validation
Sort By 
 
 LOV Oracle
Period Close Date 
 
 LOV Oracle
Download
Related Blitz Reports
CST Period Close Subinventory Value Summary CAC ICP PII Inventory Pending Cost Adjustment CAC Inventory Pending Cost Adjustment CAC ICP PII vs. Item Costs CAC ICP PII Inventory and Intransit Value (Period-End) CAC Inventory to G/L Reconciliation (Restricted by Org Access) CAC Inventory and Intransit Value (Period-End) CAC Inventory Out-of-Balance CST Period Close Subinventory Value
Blitz Report™

Blitz Report™ provides multiple benefits: