VIEW: BOM.CST_PAC_ITEM_COSTS_EFC#

Source

View Text - Preformatted

select MARKET_VALUE MARKET_VALUE, RESOURCE_COST RESOURCE_COST, COST_LAYER_ID COST_LAYER_ID, PL_ITEM_COST PL_ITEM_COST, PAC_PERIOD_ID PAC_PERIOD_ID, PL_RESOURCE PL_RESOURCE, UNBURDENED_COST UNBURDENED_COST, ITEM_MAKE_COST ITEM_MAKE_COST, TL_ITEM_COST TL_ITEM_COST, OVERHEAD_COST OVERHEAD_COST, ITEM_COST ITEM_COST, MATERIAL_COST MATERIAL_COST, TL_RESOURCE TL_RESOURCE, PL_OVERHEAD PL_OVERHEAD, PL_MATERIAL PL_MATERIAL, BEGIN_ITEM_COST BEGIN_ITEM_COST, TL_OVERHEAD TL_OVERHEAD, TL_MATERIAL TL_MATERIAL, OUTSIDE_PROCESSING_COST OUTSIDE_PROCESSING_COST, COST_GROUP_ID COST_GROUP_ID, PL_OUTSIDE_PROCESSING PL_OUTSIDE_PROCESSING, MATERIAL_OVERHEAD_COST MATERIAL_OVERHEAD_COST, ITEM_BUY_COST ITEM_BUY_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_PAC_ITEM_COSTS_EFC"

View Text - HTML Formatted

SELECT MARKET_VALUE MARKET_VALUE
, RESOURCE_COST RESOURCE_COST
, COST_LAYER_ID COST_LAYER_ID
, PL_ITEM_COST PL_ITEM_COST
, PAC_PERIOD_ID PAC_PERIOD_ID
, PL_RESOURCE PL_RESOURCE
, UNBURDENED_COST UNBURDENED_COST
, ITEM_MAKE_COST ITEM_MAKE_COST
, TL_ITEM_COST TL_ITEM_COST
, OVERHEAD_COST OVERHEAD_COST
, ITEM_COST ITEM_COST
, MATERIAL_COST MATERIAL_COST
, TL_RESOURCE TL_RESOURCE
, PL_OVERHEAD PL_OVERHEAD
, PL_MATERIAL PL_MATERIAL
, BEGIN_ITEM_COST BEGIN_ITEM_COST
, TL_OVERHEAD TL_OVERHEAD
, TL_MATERIAL TL_MATERIAL
, OUTSIDE_PROCESSING_COST OUTSIDE_PROCESSING_COST
, COST_GROUP_ID COST_GROUP_ID
, PL_OUTSIDE_PROCESSING PL_OUTSIDE_PROCESSING
, MATERIAL_OVERHEAD_COST MATERIAL_OVERHEAD_COST
, ITEM_BUY_COST ITEM_BUY_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_PAC_ITEM_COSTS_EFC"