VIEW: BOM.CST_INV_LAYERS#

Source

View Text - Preformatted

select LAYER_ID LAYER_ID, INV_LAYER_ID INV_LAYER_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CREATION_QUANTITY CREATION_QUANTITY, LAYER_QUANTITY LAYER_QUANTITY, LAYER_COST LAYER_COST, CREATE_TRANSACTION_ID CREATE_TRANSACTION_ID, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE TRANSACTION_SOURCE, UNBURDENED_COST UNBURDENED_COST, BURDEN_COST BURDEN_COST, 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 from "BOM"."CST_INV_LAYERS"

View Text - HTML Formatted

SELECT LAYER_ID LAYER_ID
, INV_LAYER_ID INV_LAYER_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CREATION_QUANTITY CREATION_QUANTITY
, LAYER_QUANTITY LAYER_QUANTITY
, LAYER_COST LAYER_COST
, CREATE_TRANSACTION_ID CREATE_TRANSACTION_ID
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_SOURCE TRANSACTION_SOURCE
, UNBURDENED_COST UNBURDENED_COST
, BURDEN_COST BURDEN_COST
, 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
FROM "BOM"."CST_INV_LAYERS"