DBA Data[Home] [Help] [Dependency Information]

TABLE: GMF.GMF_XLA_EXTRACT_HEADERS_GT

Object Details
Object Name: GMF_XLA_EXTRACT_HEADERS_GT
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.GMF_XLA_EXTRACT_HEADERS_GT
Subobject Name:
Status: VALID

Stores extract headers temporarily in a Session to create events in SLA. Once events get created, rows from this table are inserted into GMF_XLA_EXTRACT_HEADERS table.

Temporary Table Details

GMF.GMF_XLA_EXTRACT_HEADERS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes Header Identifier
REFERENCE_NO NUMBER
Yes Reference Number
EVENT_ID NUMBER

SLA Event identifier
ENTITY_CODE VARCHAR2 (50)
Entity Code
EVENT_CLASS_CODE VARCHAR2 (50)
Event Class Code
EVENT_TYPE_CODE VARCHAR2 (50)
Event Type Code
LEGAL_ENTITY_ID NUMBER
Yes Legal Entity identifier
LEDGER_ID NUMBER
Yes Ledger identifier
XFER_LEGAL_ENTITY_ID NUMBER

Transfer Legal Entity identifier
XFER_LEDGER_ID NUMBER

Transfer Ledger Identifier
OPERATING_UNIT NUMBER

Operating Unit
BASE_CURRENCY VARCHAR2 (50) Yes Base Currency
TRANSACTION_ID NUMBER
Yes Transaction identifier
TRANSACTION_DATE DATE
Yes Transaction Date
VALUATION_COST_TYPE_ID NUMBER
Yes Valuation Cost Type identifier
VALUATION_COST_TYPE VARCHAR2 (50)
Valuation Cost Type code
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item identifier
ORGANIZATION_ID NUMBER
Yes Organization Identifier
LOT_NUMBER VARCHAR2 (80)
Lot Number (for future use)
TRANSACTION_QUANTITY NUMBER
Yes Transaction Quantity
TRANSACTION_UOM VARCHAR2 (50) Yes Transaction UOM
TRANSACTION_SOURCE_TYPE_ID NUMBER
Yes Transaction Source Type Identifier
TRANSACTION_ACTION_ID NUMBER
Yes Transaction Action Identifier
TRANSACTION_TYPE_ID NUMBER
Yes Transaction Type Identifier
TRANSACTION_VALUE NUMBER
Yes Transaction Value, rounded
TRANSACTION_VALUE_RAW NUMBER
Yes Transaction Value, rounded
TRANSACTION_CURRENCY VARCHAR2 (50) Yes Transaction Currency
TXN_SOURCE VARCHAR2 (50) Yes Transaction Source
SOURCE_DOCUMENT_ID NUMBER

Source Document Identifier
SOURCE_LINE_ID NUMBER

Source Document Line Identifier
CURRENCY_CODE VARCHAR2 (50)
Currency Code
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_TYPE VARCHAR2 (50)
Currency Conversion Type
RESOURCES VARCHAR2 (50)
Resource
LINE_TYPE NUMBER

Line Type
AR_TRX_TYPE_ID NUMBER

AR Transaction Type Identifier
ORDER_TYPE NUMBER

Order Type
ACCOUNTED_FLAG VARCHAR2 (50)
Accounted Flag
ACTUAL_POSTING_DATE DATE

Actual Posting Date
ITEM_TYPE VARCHAR2 (50)
Item Type
FOB_POINT NUMBER

FOB Point
ORGANIZATION VARCHAR2 (50)
Organization. Values = SAME or TRANSFER
TRANSFER_TYPE VARCHAR2 (50)
Transfer Type. Values = RCPT or SHIP
TRANSFER_PRICE_FLAG VARCHAR2 (1)
Transfer Price Flag
TRANSACTION_TYPE VARCHAR2 (50)
Transaction Type
SHIPMENT_COSTED VARCHAR2 (1)
Shipment Costed Flag
INVOICED_FLAG VARCHAR2 (1)
Invoiced Flag
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
ITEM_REVISION VARCHAR2 (3)
REASON_ID NUMBER

Transaction Reason Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HEADER_ID
,      REFERENCE_NO
,      EVENT_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      LEGAL_ENTITY_ID
,      LEDGER_ID
,      XFER_LEGAL_ENTITY_ID
,      XFER_LEDGER_ID
,      OPERATING_UNIT
,      BASE_CURRENCY
,      TRANSACTION_ID
,      TRANSACTION_DATE
,      VALUATION_COST_TYPE_ID
,      VALUATION_COST_TYPE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      LOT_NUMBER
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_VALUE
,      TRANSACTION_VALUE_RAW
,      TRANSACTION_CURRENCY
,      TXN_SOURCE
,      SOURCE_DOCUMENT_ID
,      SOURCE_LINE_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      RESOURCES
,      LINE_TYPE
,      AR_TRX_TYPE_ID
,      ORDER_TYPE
,      ACCOUNTED_FLAG
,      ACTUAL_POSTING_DATE
,      ITEM_TYPE
,      FOB_POINT
,      ORGANIZATION
,      TRANSFER_TYPE
,      TRANSFER_PRICE_FLAG
,      TRANSACTION_TYPE
,      SHIPMENT_COSTED
,      INVOICED_FLAG
,      CURRENCY_CONVERSION_RATE
,      ITEM_REVISION
,      REASON_ID
FROM GMF.GMF_XLA_EXTRACT_HEADERS_GT;

Dependencies

[top of page]

GMF.GMF_XLA_EXTRACT_HEADERS_GT does not reference any database object

GMF.GMF_XLA_EXTRACT_HEADERS_GT is referenced by following:

SchemaAPPS
SynonymGMF_XLA_EXTRACT_HEADERS_GT