CST Item Cost Reports

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Flexible costing set of reports - analyze item costs for any cost type.
Choose from the following options:
Choose one of the following options:
Activity Summary - Report item costs by activity.
Activity by Department - Report item costs by activity and department.
Activity by Flexfield Segment Value - Report item costs by the descriptive flexfield segment you enter.
Activity by ...  Flexible costing set of reports - analyze item costs for any cost type.
Choose from the following options:
Choose one of the following options:
Activity Summary - Report item costs by activity.
Activity by Department - Report item costs by activity and department.
Activity by Flexfield Segment Value - Report item costs by the descriptive flexfield segment you enter.
Activity by Operation - Report item costs by activity and operation sequence number.
Element - Report item costs by cost element and cost level.
Element by Activity - Report item costs by cost element and activity.
Element by Department - Report item costs by cost element and department.
Element by Operation - Report item costs by cost element and operation sequence number.
Element by Sub-Element - Report item costs by cost element and sub-element.
Operation Summary by Level - Report item costs by operation sequence number and cost level.
Operation by Activity - Report item costs by operation sequence number and activity.
Operation by Sub-Element - Report item costs by operation sequence number and sub-element.
Sub-Element - Report item costs by sub-element.
Sub-Element by Activity - Report item costs by sub-element and activity.
Sub-Element by Department - Report item costs by sub-element and department.
Sub-Element by Flexfield Segment Value - Report item costs by the descriptive flexfield segment you enter.
Sub-Element by Operation - Report item costs by sub-element and operation sequence number.

   more 
select distinct
gl.name ledger,
mp.organization_code,
msiv.concatenated_segments item,
msiv.description item_description,
xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type,
mck.concatenated_segments category,
misv.inventory_item_status_code_tl item_status,
muot.unit_of_measure_tl primary_uom,
&columns
round(sum(decode(cdcv.level_type,1,cdcv.item_cost,0)) over (partition by cdcv.organization_id, cdcv.inventory_item_id, &partition_by), fc.extended_precision) this_level,
round(sum(decode(cdcv.level_type,2,cdcv.item_cost,0)) over (partition by cdcv.organization_id, cdcv.inventory_item_id, &partition_by), fc.extended_precision) prev_level,
round(sum(cdcv.item_cost) over (partition by cdcv.organization_id, cdcv.inventory_item_id, &partition_by), fc.extended_precision) item_cost,
100*sum(cdcv.item_cost) over (partition by cdcv.organization_id, cdcv.inventory_item_id, &partition_by)/xxen_util.zero_to_null(sum(cdcv.item_cost) over (partition by cdcv.organization_id, cdcv.inventory_item_id)) percentage,
round(sum(cdcv.item_cost) over (partition by cdcv.organization_id, cdcv.inventory_item_id), fc.extended_precision) item_cost_total
from
gl_ledgers gl,
fnd_currencies fc,
org_organization_definitions ood,
mtl_parameters mp,
mtl_system_items_vl msiv,
mtl_units_of_measure_tl muot,
mtl_item_status_vl misv,
cst_detail_cost_view cdcv,
cst_cost_types cct,
mtl_category_sets_v mcsv,
mtl_item_categories mic,
mtl_categories_kfv mck
where
1=1 and
mcsv.category_set_name=:category_set_name and
gl.currency_code=fc.currency_code and
fc.enabled_flag='Y' and
gl.ledger_id=ood.set_of_books_id and
ood.organization_id=mp.organization_id and
ood.organization_id=msiv.organization_id and
msiv.primary_uom_code=muot.uom_code(+) and
muot.language(+)=userenv('lang') and
msiv.inventory_item_status_code=misv.inventory_item_status_code(+) and
msiv.inventory_item_id=cdcv.inventory_item_id and
mp.cost_organization_id=cdcv.organization_id and
cdcv.cost_type_id=cct.cost_type_id and
mcsv.category_set_id=mic.category_set_id and
msiv.inventory_item_id=mic.inventory_item_id and
msiv.organization_id=mic.organization_id and 
mic.category_id=mck.category_id
order by
ledger,
organization_code,
&order_by
Parameter Name SQL text Validation
Organization Code 
mp.organization_code=:organization_code
 LOV
Ledger 
gl.name=:ledger
 LOV
Report Name 
select crt.column1||' "'||crt.column1_heading||'",' from cst_report_types crt where crt.unique_id=:unique_id union all
select crt.column2||' "'||crt.column2_heading||'",' from cst_report_types crt where crt.unique_id=:unique_id
 LOV Oracle
Cost Type 
cct.cost_type=:cost_type
 LOV
Category Set 
 
 LOV
Category From 
mck.concatenated_segments>=:category_from
 LOV
Category To 
mck.concatenated_segments<=:category_to
 LOV
Item 
msiv.concatenated_segments=:item
 LOV
Item From 
msiv.concatenated_segments>=:item_from
 LOV
Item To 
msiv.concatenated_segments<=:item_to
 LOV
Sort Option 
item
 LOV Oracle
Download
Related Blitz Reports
CST Item Costs CAC New Items CAC Calculate ICP PII Item Costs by Where Used CAC Last Standard Item Cost CAC Zero Item Costs CAC Onhand Lot Value (Real-Time) CAC ICP PII Inventory Pending Cost Adjustment CAC New Standard Item Costs CAC Cost vs. Planning Item Controls
Blitz Report™

Blitz Report™ provides multiple benefits: