VIEW: GMF.GMF_XLA_EXTRACT_HEADERS#

Source

View Text - Preformatted

select HEADER_ID HEADER_ID, REFERENCE_NO REFERENCE_NO, EVENT_ID EVENT_ID, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, EVENT_TYPE_CODE EVENT_TYPE_CODE, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LEDGER_ID LEDGER_ID, XFER_LEGAL_ENTITY_ID XFER_LEGAL_ENTITY_ID, XFER_LEDGER_ID XFER_LEDGER_ID, OPERATING_UNIT OPERATING_UNIT, BASE_CURRENCY BASE_CURRENCY, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_DATE TRANSACTION_DATE, VALUATION_COST_TYPE_ID VALUATION_COST_TYPE_ID, VALUATION_COST_TYPE VALUATION_COST_TYPE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, LOT_NUMBER LOT_NUMBER, TRANSACTION_QUANTITY TRANSACTION_QUANTITY, TRANSACTION_UOM TRANSACTION_UOM, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, TRANSACTION_VALUE TRANSACTION_VALUE, TRANSACTION_VALUE_RAW TRANSACTION_VALUE_RAW, TRANSACTION_CURRENCY TRANSACTION_CURRENCY, TXN_SOURCE TXN_SOURCE, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID, SOURCE_LINE_ID SOURCE_LINE_ID, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, RESOURCES RESOURCES, LINE_TYPE LINE_TYPE, AR_TRX_TYPE_ID AR_TRX_TYPE_ID, ORDER_TYPE ORDER_TYPE, ACCOUNTED_FLAG ACCOUNTED_FLAG, ACTUAL_POSTING_DATE ACTUAL_POSTING_DATE, SHIPMENT_COSTED SHIPMENT_COSTED, INVOICED_FLAG INVOICED_FLAG, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, ITEM_REVISION ITEM_REVISION, REASON_ID REASON_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, 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 from "GMF"."GMF_XLA_EXTRACT_HEADERS"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, REFERENCE_NO REFERENCE_NO
, EVENT_ID EVENT_ID
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LEDGER_ID LEDGER_ID
, XFER_LEGAL_ENTITY_ID XFER_LEGAL_ENTITY_ID
, XFER_LEDGER_ID XFER_LEDGER_ID
, OPERATING_UNIT OPERATING_UNIT
, BASE_CURRENCY BASE_CURRENCY
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_DATE TRANSACTION_DATE
, VALUATION_COST_TYPE_ID VALUATION_COST_TYPE_ID
, VALUATION_COST_TYPE VALUATION_COST_TYPE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LOT_NUMBER LOT_NUMBER
, TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, TRANSACTION_UOM TRANSACTION_UOM
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, TRANSACTION_VALUE TRANSACTION_VALUE
, TRANSACTION_VALUE_RAW TRANSACTION_VALUE_RAW
, TRANSACTION_CURRENCY TRANSACTION_CURRENCY
, TXN_SOURCE TXN_SOURCE
, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, RESOURCES RESOURCES
, LINE_TYPE LINE_TYPE
, AR_TRX_TYPE_ID AR_TRX_TYPE_ID
, ORDER_TYPE ORDER_TYPE
, ACCOUNTED_FLAG ACCOUNTED_FLAG
, ACTUAL_POSTING_DATE ACTUAL_POSTING_DATE
, SHIPMENT_COSTED SHIPMENT_COSTED
, INVOICED_FLAG INVOICED_FLAG
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, ITEM_REVISION ITEM_REVISION
, REASON_ID REASON_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, 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
FROM "GMF"."GMF_XLA_EXTRACT_HEADERS"