INV Period close value summary

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Period close value summary (XML)
Short Name: INVTRCLS_XML
DB package: INV_INVTRCLS_XMLP_PKG
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
Organization
 
Number
Period Close Date
 
LOV Oracle
Sort By
 
LOV Oracle