DBA Data[Home] [Help]

VIEW: INV.MTL_TXN_COST_DET_INTERFACE#

Source

View Text - Preformatted

select TRANSACTION_INTERFACE_ID TRANSACTION_INTERFACE_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, ORGANIZATION_NAME ORGANIZATION_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, COST_ELEMENT_ID COST_ELEMENT_ID, COST_ELEMENT COST_ELEMENT, LEVEL_TYPE LEVEL_TYPE, LEVEL_NAME LEVEL_NAME, TRANSACTION_COST TRANSACTION_COST, NEW_AVERAGE_COST NEW_AVERAGE_COST, PERCENTAGE_CHANGE PERCENTAGE_CHANGE, VALUE_CHANGE VALUE_CHANGE, ERROR_CODE ERROR_CODE, ERROR_EXPLANATION ERROR_EXPLANATION from "INV"."MTL_TXN_COST_DET_INTERFACE"
View Text - HTML Formatted

SELECT TRANSACTION_INTERFACE_ID TRANSACTION_INTERFACE_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
, ORGANIZATION_NAME ORGANIZATION_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, COST_ELEMENT_ID COST_ELEMENT_ID
, COST_ELEMENT COST_ELEMENT
, LEVEL_TYPE LEVEL_TYPE
, LEVEL_NAME LEVEL_NAME
, TRANSACTION_COST TRANSACTION_COST
, NEW_AVERAGE_COST NEW_AVERAGE_COST
, PERCENTAGE_CHANGE PERCENTAGE_CHANGE
, VALUE_CHANGE VALUE_CHANGE
, ERROR_CODE ERROR_CODE
, ERROR_EXPLANATION ERROR_EXPLANATION
FROM "INV"."MTL_TXN_COST_DET_INTERFACE"