VIEW: BOM.CST_PC_ITEM_COST_INTERFACE#

Source

View Text - Preformatted

select INTERFACE_HEADER_ID INTERFACE_HEADER_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, COST_GROUP COST_GROUP, COST_TYPE COST_TYPE, PERIOD_NAME PERIOD_NAME, PROCESS_FLAG PROCESS_FLAG, BEGIN_LAYER_QUANTITY BEGIN_LAYER_QUANTITY, ISSUE_QUANTITY ISSUE_QUANTITY, BUY_QUANTITY BUY_QUANTITY, MAKE_QUANTITY MAKE_QUANTITY, INTERFACE_GROUP_ID INTERFACE_GROUP_ID, COST_LAYER_ID COST_LAYER_ID, QUANTITY_LAYER_ID QUANTITY_LAYER_ID, PAC_PERIOD_ID PAC_PERIOD_ID, COST_GROUP_ID COST_GROUP_ID, ITEM_COST ITEM_COST, MARKET_VALUE MARKET_VALUE, JUSTIFICATION JUSTIFICATION, BEGIN_ITEM_COST BEGIN_ITEM_COST, ITEM_BUY_COST ITEM_BUY_COST, ITEM_MAKE_COST ITEM_MAKE_COST, PL_MATERIAL PL_MATERIAL, PL_MATERIAL_OVERHEAD PL_MATERIAL_OVERHEAD, PL_RESOURCE PL_RESOURCE, PL_OUTSIDE_PROCESSING PL_OUTSIDE_PROCESSING, PL_OVERHEAD PL_OVERHEAD, TL_MATERIAL TL_MATERIAL, TL_MATERIAL_OVERHEAD TL_MATERIAL_OVERHEAD, TL_RESOURCE TL_RESOURCE, TL_OUTSIDE_PROCESSING TL_OUTSIDE_PROCESSING, TL_OVERHEAD TL_OVERHEAD, PL_ITEM_COST PL_ITEM_COST, TL_ITEM_COST TL_ITEM_COST, UNBURDENED_COST UNBURDENED_COST, BURDEN_COST BURDEN_COST, MATERIAL_COST MATERIAL_COST, MATERIAL_OVERHEAD_COST MATERIAL_OVERHEAD_COST, RESOURCE_COST RESOURCE_COST, OVERHEAD_COST OVERHEAD_COST, OUTSIDE_PROCESSING_COST OUTSIDE_PROCESSING_COST, REFERENCE REFERENCE, ERROR_FLAG ERROR_FLAG, ERROR_EXPLANATION ERROR_EXPLANATION, LOCK_FLAG LOCK_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAYER_QUANTITY LAYER_QUANTITY from "BOM"."CST_PC_ITEM_COST_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, COST_GROUP COST_GROUP
, COST_TYPE COST_TYPE
, PERIOD_NAME PERIOD_NAME
, PROCESS_FLAG PROCESS_FLAG
, BEGIN_LAYER_QUANTITY BEGIN_LAYER_QUANTITY
, ISSUE_QUANTITY ISSUE_QUANTITY
, BUY_QUANTITY BUY_QUANTITY
, MAKE_QUANTITY MAKE_QUANTITY
, INTERFACE_GROUP_ID INTERFACE_GROUP_ID
, COST_LAYER_ID COST_LAYER_ID
, QUANTITY_LAYER_ID QUANTITY_LAYER_ID
, PAC_PERIOD_ID PAC_PERIOD_ID
, COST_GROUP_ID COST_GROUP_ID
, ITEM_COST ITEM_COST
, MARKET_VALUE MARKET_VALUE
, JUSTIFICATION JUSTIFICATION
, BEGIN_ITEM_COST BEGIN_ITEM_COST
, ITEM_BUY_COST ITEM_BUY_COST
, ITEM_MAKE_COST ITEM_MAKE_COST
, PL_MATERIAL PL_MATERIAL
, PL_MATERIAL_OVERHEAD PL_MATERIAL_OVERHEAD
, PL_RESOURCE PL_RESOURCE
, PL_OUTSIDE_PROCESSING PL_OUTSIDE_PROCESSING
, PL_OVERHEAD PL_OVERHEAD
, TL_MATERIAL TL_MATERIAL
, TL_MATERIAL_OVERHEAD TL_MATERIAL_OVERHEAD
, TL_RESOURCE TL_RESOURCE
, TL_OUTSIDE_PROCESSING TL_OUTSIDE_PROCESSING
, TL_OVERHEAD TL_OVERHEAD
, PL_ITEM_COST PL_ITEM_COST
, TL_ITEM_COST TL_ITEM_COST
, UNBURDENED_COST UNBURDENED_COST
, BURDEN_COST BURDEN_COST
, MATERIAL_COST MATERIAL_COST
, MATERIAL_OVERHEAD_COST MATERIAL_OVERHEAD_COST
, RESOURCE_COST RESOURCE_COST
, OVERHEAD_COST OVERHEAD_COST
, OUTSIDE_PROCESSING_COST OUTSIDE_PROCESSING_COST
, REFERENCE REFERENCE
, ERROR_FLAG ERROR_FLAG
, ERROR_EXPLANATION ERROR_EXPLANATION
, LOCK_FLAG LOCK_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAYER_QUANTITY LAYER_QUANTITY
FROM "BOM"."CST_PC_ITEM_COST_INTERFACE"