VIEW: BOM.CST_QUANTITY_LAYERS#

Source

View Text - Preformatted

select LAYER_ID LAYER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, LAYER_QUANTITY LAYER_QUANTITY, CREATE_TRANSACTION_ID CREATE_TRANSACTION_ID, UPDATE_TRANSACTION_ID UPDATE_TRANSACTION_ID, 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, MATERIAL_COST MATERIAL_COST, MATERIAL_OVERHEAD_COST MATERIAL_OVERHEAD_COST, RESOURCE_COST RESOURCE_COST, OUTSIDE_PROCESSING_COST OUTSIDE_PROCESSING_COST, OVERHEAD_COST OVERHEAD_COST, PL_ITEM_COST PL_ITEM_COST, TL_ITEM_COST TL_ITEM_COST, ITEM_COST ITEM_COST, UNBURDENED_COST UNBURDENED_COST, BURDEN_COST BURDEN_COST, COST_GROUP_ID COST_GROUP_ID from "BOM"."CST_QUANTITY_LAYERS"

View Text - HTML Formatted

SELECT LAYER_ID LAYER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LAYER_QUANTITY LAYER_QUANTITY
, CREATE_TRANSACTION_ID CREATE_TRANSACTION_ID
, UPDATE_TRANSACTION_ID UPDATE_TRANSACTION_ID
, 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
, MATERIAL_COST MATERIAL_COST
, MATERIAL_OVERHEAD_COST MATERIAL_OVERHEAD_COST
, RESOURCE_COST RESOURCE_COST
, OUTSIDE_PROCESSING_COST OUTSIDE_PROCESSING_COST
, OVERHEAD_COST OVERHEAD_COST
, PL_ITEM_COST PL_ITEM_COST
, TL_ITEM_COST TL_ITEM_COST
, ITEM_COST ITEM_COST
, UNBURDENED_COST UNBURDENED_COST
, BURDEN_COST BURDEN_COST
, COST_GROUP_ID COST_GROUP_ID
FROM "BOM"."CST_QUANTITY_LAYERS"