VIEW: INV.MTL_CST_ACTUAL_COST_DETAILS#

Source

View Text - Preformatted

select LAYER_ID LAYER_ID, TRANSACTION_ID TRANSACTION_ID, ORGANIZATION_ID ORGANIZATION_ID, COST_ELEMENT_ID COST_ELEMENT_ID, LEVEL_TYPE LEVEL_TYPE, TRANSACTION_ACTION_ID TRANSACTION_ACTION_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, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ACTUAL_COST ACTUAL_COST, PRIOR_COST PRIOR_COST, NEW_COST NEW_COST, INSERTION_FLAG INSERTION_FLAG, VARIANCE_AMOUNT VARIANCE_AMOUNT, USER_ENTERED USER_ENTERED, TRANSACTION_COSTED_DATE TRANSACTION_COSTED_DATE, PAYBACK_VARIANCE_AMOUNT PAYBACK_VARIANCE_AMOUNT, ONHAND_VARIANCE_AMOUNT ONHAND_VARIANCE_AMOUNT from "INV"."MTL_CST_ACTUAL_COST_DETAILS"

View Text - HTML Formatted

SELECT LAYER_ID LAYER_ID
, TRANSACTION_ID TRANSACTION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COST_ELEMENT_ID COST_ELEMENT_ID
, LEVEL_TYPE LEVEL_TYPE
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_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
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ACTUAL_COST ACTUAL_COST
, PRIOR_COST PRIOR_COST
, NEW_COST NEW_COST
, INSERTION_FLAG INSERTION_FLAG
, VARIANCE_AMOUNT VARIANCE_AMOUNT
, USER_ENTERED USER_ENTERED
, TRANSACTION_COSTED_DATE TRANSACTION_COSTED_DATE
, PAYBACK_VARIANCE_AMOUNT PAYBACK_VARIANCE_AMOUNT
, ONHAND_VARIANCE_AMOUNT ONHAND_VARIANCE_AMOUNT
FROM "INV"."MTL_CST_ACTUAL_COST_DETAILS"