VIEW: BOM.CST_PAC_PERIOD_BALANCES#

Source

View Text - Preformatted

select PAC_PERIOD_ID PAC_PERIOD_ID, COST_GROUP_ID COST_GROUP_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, COST_LAYER_ID COST_LAYER_ID, QUANTITY_LAYER_ID QUANTITY_LAYER_ID, COST_ELEMENT_ID COST_ELEMENT_ID, LEVEL_TYPE LEVEL_TYPE, TXN_CATEGORY TXN_CATEGORY, TXN_CATEGORY_QTY TXN_CATEGORY_QTY, TXN_CATEGORY_VALUE TXN_CATEGORY_VALUE, PERIOD_QUANTITY PERIOD_QUANTITY, PERIODIC_COST PERIODIC_COST, PERIOD_BALANCE PERIOD_BALANCE, VARIANCE_AMOUNT VARIANCE_AMOUNT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "BOM"."CST_PAC_PERIOD_BALANCES"

View Text - HTML Formatted

SELECT PAC_PERIOD_ID PAC_PERIOD_ID
, COST_GROUP_ID COST_GROUP_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, COST_LAYER_ID COST_LAYER_ID
, QUANTITY_LAYER_ID QUANTITY_LAYER_ID
, COST_ELEMENT_ID COST_ELEMENT_ID
, LEVEL_TYPE LEVEL_TYPE
, TXN_CATEGORY TXN_CATEGORY
, TXN_CATEGORY_QTY TXN_CATEGORY_QTY
, TXN_CATEGORY_VALUE TXN_CATEGORY_VALUE
, PERIOD_QUANTITY PERIOD_QUANTITY
, PERIODIC_COST PERIODIC_COST
, PERIOD_BALANCE PERIOD_BALANCE
, VARIANCE_AMOUNT VARIANCE_AMOUNT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "BOM"."CST_PAC_PERIOD_BALANCES"