CST Period Close Value Summary - Warehouse Management
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
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 |