eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GMF.GMF_XLA_EXTRACT_HEADERS

Object Details

Object Name:	GMF_XLA_EXTRACT_HEADERS
Object Type:	TABLE
Owner:	GMF
FND Design Data:	GMF.GMF_XLA_EXTRACT_HEADERS
Subobject Name:
Status:	VALID

This table is the SLA Extract Headers table. The transactions for process inventory organizations are processed and all the necessary data for accounting are stored in this table. When the SLA accounting program is run data from this table is extracted for creation of journal entries in SLA.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMF_XLA_EXTRACT_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HEADER_ID
GMF_XLA_EXTRACT_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEGAL_ENTITY_ID LEDGER_ID VALUATION_COST_TYPE_ID TRANSACTION_ID EVENT_CLASS_CODE
GMF_XLA_EXTRACT_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEDGER_ID VALUATION_COST_TYPE_ID TRANSACTION_DATE TRANSACTION_SOURCE_TYPE_ID TRANSACTION_ACTION_ID TRANSACTION_TYPE_ID
GMF_XLA_EXTRACT_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
HEADER_ID	NUMBER		Yes	Header Identifier
REFERENCE_NO	NUMBER		Yes	Reference Number
EVENT_ID	NUMBER		Yes	SLA Event Identifier
ENTITY_CODE	VARCHAR2	(50)	Yes	Entity Code
EVENT_CLASS_CODE	VARCHAR2	(50)	Yes	Event Class Code
EVENT_TYPE_CODE	VARCHAR2	(50)	Yes	Event Type Code
LEGAL_ENTITY_ID	NUMBER		Yes	Legal Entity
LEDGER_ID	NUMBER		Yes	Ledger Identifier
XFER_LEGAL_ENTITY_ID	NUMBER			Transfer Legal Entity
XFER_LEDGER_ID	NUMBER			Transfer Ledger Idenifier
OPERATING_UNIT	NUMBER			Operating Unit
BASE_CURRENCY	VARCHAR2	(50)	Yes	Base Currency
TRANSACTION_ID	NUMBER		Yes	Transaction Identifier from MTL_MATERIAL_TRANSACTIONS table
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			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 Unit Of Measure
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 Unrounded
TRANSACTION_CURRENCY	VARCHAR2	(50)	Yes	Transaction Currency
TXN_SOURCE	VARCHAR2	(50)	Yes	Transaction Source
SOURCE_DOCUMENT_ID	NUMBER			Source Document Id
SOURCE_LINE_ID	NUMBER			Source Document Line Level Id
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
SHIPMENT_COSTED	VARCHAR2	(1)		Shipment Costed Flag
INVOICED_FLAG	VARCHAR2	(1)		Invoiced Flag
CURRENCY_CONVERSION_RATE	NUMBER			Currency Conversion Rate
ITEM_REVISION	VARCHAR2	(3)		Inventory Item Revision
REASON_ID	NUMBER			Transaction Reason Identifier
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column

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
,      SHIPMENT_COSTED
,      INVOICED_FLAG
,      CURRENCY_CONVERSION_RATE
,      ITEM_REVISION
,      REASON_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM GMF.GMF_XLA_EXTRACT_HEADERS;

Dependencies

[top of page]

GMF.GMF_XLA_EXTRACT_HEADERS does not reference any database object

GMF.GMF_XLA_EXTRACT_HEADERS is referenced by following:

APPS: GMF_XLA_EXTRACT_HEADERS