CST Period Close Value Summary - Warehouse Management

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Period Close Value Summary - Warehouse Management
Application: Bills of Material
Source: Period Close Value Summary - Warehouse Management (XML)
Short Name: CSTRPCGW_XML
DB package: BOM_CSTRPCGW_XMLP_PKG
Run CST Period Close Value Summary - Warehouse Management and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT CCG.cost_group costgroup,
             CCG.description description, 
             ROUND(SUM(NVL(CPCSV.inventory_value,0)),:c_std_prec) sum_value
FROM   cst_cost_groups CCG,
       cst_cost_group_accounts CCGA,
       cst_period_cg_summary_v CPCSV
WHERE  CCGA.organization_id = :P_ORG_ID
AND    CCG.cost_group_id = CCGA.cost_group_id
AND    CPCSV.organization_id(+) = CCGA.organization_id
AND    CPCSV.cost_group_id(+) = CCGA.cost_group_id
AND    CPCSV.acct_period_id(+) = :c_acct_period_id    
GROUP
BY      CCG.cost_group, 
          CCG.description
&c_order_by
Parameter Name SQL text Validation
Sort By 
 
 LOV Oracle
Period Close Date 
 
 LOV Oracle
Download
Related Blitz Reports
CAC Inventory to G/L Reconciliation (Restricted by Org Access) CAC ICP PII Inventory and Intransit Value (Period-End) CAC Inventory Pending Cost Adjustment CAC Inventory Organization Summary CAC ICP PII Inventory Pending Cost Adjustment CAC Inventory and Intransit Value (Period-End) CAC Inventory to G/L Reconciliation (Unrestricted by Org Access) CAC Inventory Out-of-Balance RD INV Inventory Aging
Blitz Report™

Blitz Report™ provides multiple benefits: