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

TABLE: GMF.GMF_XLA_EXTRACT_LINES

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


This table is the SLA Extract Lines 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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMF_XLA_EXTRACT_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
GMF_XLA_EXTRACT_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnEVENT_ID
GMF_XLA_EXTRACT_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER
Yes Line Identifier
HEADER_ID NUMBER
Yes Header Identifier
EVENT_ID NUMBER
Yes SLA Event Identifier
LEDGER_ID NUMBER
Yes Ledger Identifier
LINE_NUMBER NUMBER
Yes Line Number
JOURNAL_LINE_TYPE VARCHAR2 (50) Yes Journal Line Type
COST_CMPNTCLS_ID NUMBER

Cost Component Class Identifier
COST_ANALYSIS_CODE VARCHAR2 (50)
Cost Analysis Code
COMPONENT_COST NUMBER
Yes Component Cost
USAGE_IND NUMBER

Usage Indicator
COST_LEVEL NUMBER

Cost Level
AQUI_COST_ID NUMBER

Aquisition Cost Identifier
TRANS_AMOUNT_RAW NUMBER
Yes Transaction Amount Unrounded
BASE_AMOUNT_RAW NUMBER
Yes Base Amount Unrounded
TRANS_AMOUNT NUMBER
Yes Transaction Amount Rounder
BASE_AMOUNT NUMBER
Yes Base Amount Rounded
DR_CR_SIGN NUMBER
Yes Debit Credit Sign
SUBINVENTORY_CODE VARCHAR2 (100)
Sub-Inventory Code
XFER_SUBINVENTORY_CODE VARCHAR2 (100)
Transfer Sub-Inventory Code
TRANSACTION_ACCOUNT_ID NUMBER

Transaction Account Identifer
ENTERED_AMOUNT NUMBER

Entered Amount
ACCOUNTED_AMOUNT NUMBER

Accounted Amount
ORGANIZATION_ID NUMBER

Organization Identifier
LOCATOR_ID NUMBER

Locator Identifier
REFERENCE_NO NUMBER

Reference Number
LOT_NUMBER VARCHAR2 (80)
Lot Number
SUBINV_ORGANIZATION_ID NUMBER (15)
Identifier of Inv Organization that owns the sub-inventory
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 LINE_ID
,      HEADER_ID
,      EVENT_ID
,      LEDGER_ID
,      LINE_NUMBER
,      JOURNAL_LINE_TYPE
,      COST_CMPNTCLS_ID
,      COST_ANALYSIS_CODE
,      COMPONENT_COST
,      USAGE_IND
,      COST_LEVEL
,      AQUI_COST_ID
,      TRANS_AMOUNT_RAW
,      BASE_AMOUNT_RAW
,      TRANS_AMOUNT
,      BASE_AMOUNT
,      DR_CR_SIGN
,      SUBINVENTORY_CODE
,      XFER_SUBINVENTORY_CODE
,      TRANSACTION_ACCOUNT_ID
,      ENTERED_AMOUNT
,      ACCOUNTED_AMOUNT
,      ORGANIZATION_ID
,      LOCATOR_ID
,      REFERENCE_NO
,      LOT_NUMBER
,      SUBINV_ORGANIZATION_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_LINES;

Dependencies

[top of page]

GMF.GMF_XLA_EXTRACT_LINES does not reference any database object

GMF.GMF_XLA_EXTRACT_LINES is referenced by following:

SchemaGMF
ViewGMF_XLA_EXTRACT_LINES#