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 NameSQL textValidation
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™