INV Period close value summary

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
Blitz Report™