VIEW: BOM.CST_ITEM_COSTS_EFC#

Source

View Text - Preformatted

select RESOURCE_COST RESOURCE_COST, ORGANIZATION_ID ORGANIZATION_ID, PL_ITEM_COST PL_ITEM_COST, PL_RESOURCE PL_RESOURCE, UNBURDENED_COST UNBURDENED_COST, TL_ITEM_COST TL_ITEM_COST, OVERHEAD_COST OVERHEAD_COST, COST_TYPE_ID COST_TYPE_ID, ITEM_COST ITEM_COST, MATERIAL_COST MATERIAL_COST, TL_RESOURCE TL_RESOURCE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PL_OVERHEAD PL_OVERHEAD, PL_MATERIAL PL_MATERIAL, TL_OVERHEAD TL_OVERHEAD, TL_MATERIAL TL_MATERIAL, OUTSIDE_PROCESSING_COST OUTSIDE_PROCESSING_COST, PL_OUTSIDE_PROCESSING PL_OUTSIDE_PROCESSING, MATERIAL_OVERHEAD_COST MATERIAL_OVERHEAD_COST, PL_MATERIAL_OVERHEAD PL_MATERIAL_OVERHEAD, BURDEN_COST BURDEN_COST, TL_OUTSIDE_PROCESSING TL_OUTSIDE_PROCESSING, TL_MATERIAL_OVERHEAD TL_MATERIAL_OVERHEAD, SET_OF_BOOKS_ID SET_OF_BOOKS_ID from "BOM"."CST_ITEM_COSTS_EFC"

View Text - HTML Formatted

SELECT RESOURCE_COST RESOURCE_COST
, ORGANIZATION_ID ORGANIZATION_ID
, PL_ITEM_COST PL_ITEM_COST
, PL_RESOURCE PL_RESOURCE
, UNBURDENED_COST UNBURDENED_COST
, TL_ITEM_COST TL_ITEM_COST
, OVERHEAD_COST OVERHEAD_COST
, COST_TYPE_ID COST_TYPE_ID
, ITEM_COST ITEM_COST
, MATERIAL_COST MATERIAL_COST
, TL_RESOURCE TL_RESOURCE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PL_OVERHEAD PL_OVERHEAD
, PL_MATERIAL PL_MATERIAL
, TL_OVERHEAD TL_OVERHEAD
, TL_MATERIAL TL_MATERIAL
, OUTSIDE_PROCESSING_COST OUTSIDE_PROCESSING_COST
, PL_OUTSIDE_PROCESSING PL_OUTSIDE_PROCESSING
, MATERIAL_OVERHEAD_COST MATERIAL_OVERHEAD_COST
, PL_MATERIAL_OVERHEAD PL_MATERIAL_OVERHEAD
, BURDEN_COST BURDEN_COST
, TL_OUTSIDE_PROCESSING TL_OUTSIDE_PROCESSING
, TL_MATERIAL_OVERHEAD TL_MATERIAL_OVERHEAD
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM "BOM"."CST_ITEM_COSTS_EFC"