CST Item Cost Reports

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 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.

SQL 50 lines

Parameters 11

ParameterTypeList of values SQL
Organization CodeLOV
mp.organization_code=:organization_code
LedgerLOV
gl.name=:ledger
Report NameLOV Oracle
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
Cost TypeLOV
cct.cost_type=:cost_type
Category SetLOV
Category FromLOV
mck.concatenated_segments>=:category_from
Category ToLOV
mck.concatenated_segments<=:category_to
ItemLOV
msiv.concatenated_segments=:item
Item FromLOV
msiv.concatenated_segments>=:item_from
Item ToLOV
msiv.concatenated_segments<=:item_to
Sort OptionLOV Oracle
item