VIEW: APPS.CST_CQL_CIC_ITEM_COSTS_V

Source

View Text - Preformatted

SELECT cql.organization_id ,cql.inventory_item_id ,cql.cost_group_id ,-1 ,cql.item_cost ,cql.pl_material ,cql.pl_material_overhead ,cql.pl_resource ,cql.pl_outside_processing ,cql.pl_overhead ,cql.tl_material ,cql.tl_material_overhead ,cql.tl_resource ,cql.tl_outside_processing ,cql.tl_overhead ,cql.material_cost ,cql.material_overhead_cost ,cql.resource_cost ,cql.outside_processing_cost ,cql.overhead_cost ,cql.pl_item_cost ,cql.tl_item_cost ,cql.unburdened_cost ,cql.burden_cost ,decode(msi.inventory_asset_flag,'Y',1,0) FROM cst_quantity_layers cql, mtl_system_items msi WHERE cql.inventory_item_id = msi.inventory_item_id AND cql.organization_id = msi.organization_id UNION ALL SELECT organization_id ,inventory_item_id ,-1 ,cost_type_id ,item_cost ,pl_material ,pl_material_overhead ,pl_resource ,pl_outside_processing ,pl_overhead ,tl_material ,tl_material_overhead ,tl_resource ,tl_outside_processing ,tl_overhead ,material_cost ,material_overhead_cost ,resource_cost ,outside_processing_cost ,overhead_cost ,pl_item_cost ,tl_item_cost ,unburdened_cost ,burden_cost ,inventory_asset_flag FROM cst_item_costs

View Text - HTML Formatted

SELECT CQL.ORGANIZATION_ID
, CQL.INVENTORY_ITEM_ID
, CQL.COST_GROUP_ID
, -1
, CQL.ITEM_COST
, CQL.PL_MATERIAL
, CQL.PL_MATERIAL_OVERHEAD
, CQL.PL_RESOURCE
, CQL.PL_OUTSIDE_PROCESSING
, CQL.PL_OVERHEAD
, CQL.TL_MATERIAL
, CQL.TL_MATERIAL_OVERHEAD
, CQL.TL_RESOURCE
, CQL.TL_OUTSIDE_PROCESSING
, CQL.TL_OVERHEAD
, CQL.MATERIAL_COST
, CQL.MATERIAL_OVERHEAD_COST
, CQL.RESOURCE_COST
, CQL.OUTSIDE_PROCESSING_COST
, CQL.OVERHEAD_COST
, CQL.PL_ITEM_COST
, CQL.TL_ITEM_COST
, CQL.UNBURDENED_COST
, CQL.BURDEN_COST
, DECODE(MSI.INVENTORY_ASSET_FLAG
, 'Y'
, 1
, 0)
FROM CST_QUANTITY_LAYERS CQL
, MTL_SYSTEM_ITEMS MSI
WHERE CQL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND CQL.ORGANIZATION_ID = MSI.ORGANIZATION_ID UNION ALL SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, -1
, COST_TYPE_ID
, ITEM_COST
, PL_MATERIAL
, PL_MATERIAL_OVERHEAD
, PL_RESOURCE
, PL_OUTSIDE_PROCESSING
, PL_OVERHEAD
, TL_MATERIAL
, TL_MATERIAL_OVERHEAD
, TL_RESOURCE
, TL_OUTSIDE_PROCESSING
, TL_OVERHEAD
, MATERIAL_COST
, MATERIAL_OVERHEAD_COST
, RESOURCE_COST
, OUTSIDE_PROCESSING_COST
, OVERHEAD_COST
, PL_ITEM_COST
, TL_ITEM_COST
, UNBURDENED_COST
, BURDEN_COST
, INVENTORY_ASSET_FLAG
FROM CST_ITEM_COSTS