CST Item Cost Reports
Description
Categories: Enginatics
Repository: Github
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 ... more
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 ... 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 |
|
LOV | |
Ledger |
|
LOV | |
Report Name |
|
LOV Oracle | |
Cost Type |
|
LOV | |
Category Set |
|
LOV | |
Category From |
|
LOV | |
Category To |
|
LOV | |
Item |
|
LOV | |
Item From |
|
LOV | |
Item To |
|
LOV | |
Sort Option |
|
LOV Oracle |