CST Period Close Value Summary - Warehouse Management

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Bills of Material
Source
Period Close Value Summary - Warehouse Management (XML)
Short Name
CSTRPCGW_XML
DB package
BOM_CSTRPCGW_XMLP_PKG
Imported from BI Publisher
Period Close Value Summary - Warehouse Management

SQL 16 lines

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

Parameters 2

ParameterTypeList of values SQL
Sort ByLOV Oracle
Period Close DateLOV Oracle