VIEW: GMF.GMF_TRANSACTION_VALUATION#

Source

View Text - Preformatted

select VALUATION_ID VALUATION_ID, HEADER_ID HEADER_ID, EVENT_ID EVENT_ID, LEDGER_ID LEDGER_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LEDGER_CURRENCY LEDGER_CURRENCY, VALUATION_COST_TYPE VALUATION_COST_TYPE, VALUATION_COST_TYPE_ID VALUATION_COST_TYPE_ID, REFERENCE_NO REFERENCE_NO, TRANSACTION_SOURCE_TYPE TRANSACTION_SOURCE_TYPE, TRANSACTION_SOURCE TRANSACTION_SOURCE, TRANSACTION_ID TRANSACTION_ID, DOC_ID DOC_ID, LINE_ID LINE_ID, ORG_ID ORG_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_NUMBER ITEM_NUMBER, LOT_NUMBER LOT_NUMBER, RESOURCES RESOURCES, SUBINVENTORY_CODE SUBINVENTORY_CODE, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, JOURNAL_LINE_TYPE JOURNAL_LINE_TYPE, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, EVENT_TYPE_CODE EVENT_TYPE_CODE, COMPONENT_CLASS_USAGE COMPONENT_CLASS_USAGE, COST_LEVEL COST_LEVEL, TXN_BASE_VALUE_RAW TXN_BASE_VALUE_RAW, TXN_BASE_VALUE TXN_BASE_VALUE, FINAL_POSTING_DATE FINAL_POSTING_DATE, ACCOUNTED_FLAG ACCOUNTED_FLAG, LINE_TYPE LINE_TYPE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, COMPONENT_CLASS_USAGE_TYPE COMPONENT_CLASS_USAGE_TYPE from "GMF"."GMF_TRANSACTION_VALUATION"

View Text - HTML Formatted

SELECT VALUATION_ID VALUATION_ID
, HEADER_ID HEADER_ID
, EVENT_ID EVENT_ID
, LEDGER_ID LEDGER_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LEDGER_CURRENCY LEDGER_CURRENCY
, VALUATION_COST_TYPE VALUATION_COST_TYPE
, VALUATION_COST_TYPE_ID VALUATION_COST_TYPE_ID
, REFERENCE_NO REFERENCE_NO
, TRANSACTION_SOURCE_TYPE TRANSACTION_SOURCE_TYPE
, TRANSACTION_SOURCE TRANSACTION_SOURCE
, TRANSACTION_ID TRANSACTION_ID
, DOC_ID DOC_ID
, LINE_ID LINE_ID
, ORG_ID ORG_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_NUMBER ITEM_NUMBER
, LOT_NUMBER LOT_NUMBER
, RESOURCES RESOURCES
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, JOURNAL_LINE_TYPE JOURNAL_LINE_TYPE
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, COMPONENT_CLASS_USAGE COMPONENT_CLASS_USAGE
, COST_LEVEL COST_LEVEL
, TXN_BASE_VALUE_RAW TXN_BASE_VALUE_RAW
, TXN_BASE_VALUE TXN_BASE_VALUE
, FINAL_POSTING_DATE FINAL_POSTING_DATE
, ACCOUNTED_FLAG ACCOUNTED_FLAG
, LINE_TYPE LINE_TYPE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, COMPONENT_CLASS_USAGE_TYPE COMPONENT_CLASS_USAGE_TYPE
FROM "GMF"."GMF_TRANSACTION_VALUATION"