VIEW: INV.MTL_CST_LAYER_ACT_COST_DETAIL#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, ORGANIZATION_ID ORGANIZATION_ID, LAYER_ID LAYER_ID, INV_LAYER_ID INV_LAYER_ID, LAYER_QUANTITY LAYER_QUANTITY, LEVEL_TYPE LEVEL_TYPE, COST_ELEMENT_ID COST_ELEMENT_ID, ACTUAL_COST ACTUAL_COST, LAYER_COST LAYER_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, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, VARIANCE_AMOUNT VARIANCE_AMOUNT, USER_ENTERED USER_ENTERED, PAYBACK_VARIANCE_AMOUNT PAYBACK_VARIANCE_AMOUNT, ONHAND_VARIANCE_AMOUNT ONHAND_VARIANCE_AMOUNT from "INV"."MTL_CST_LAYER_ACT_COST_DETAILS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LAYER_ID LAYER_ID
, INV_LAYER_ID INV_LAYER_ID
, LAYER_QUANTITY LAYER_QUANTITY
, LEVEL_TYPE LEVEL_TYPE
, COST_ELEMENT_ID COST_ELEMENT_ID
, ACTUAL_COST ACTUAL_COST
, LAYER_COST LAYER_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
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, VARIANCE_AMOUNT VARIANCE_AMOUNT
, USER_ENTERED USER_ENTERED
, PAYBACK_VARIANCE_AMOUNT PAYBACK_VARIANCE_AMOUNT
, ONHAND_VARIANCE_AMOUNT ONHAND_VARIANCE_AMOUNT
FROM "INV"."MTL_CST_LAYER_ACT_COST_DETAILS"