CST Period Close Value Summary - Warehouse Management

Description
Categories: BI Publisher, Financials, Manufacturing
Application: Bills of Material
Source: Period Close Value Summary - Warehouse Management (XML)
Short Name: CSTRPCGW_XML
DB package: BOM_CSTRPCGW_XMLP_PKG
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 NameSQL textValidation
Organization
 
Number
Period Close Date
 
LOV Oracle
Sort By
 
LOV Oracle