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

TABLE: GMF.GMF_XLA_EXTRACT_LINES_GT

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

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

Temporary Table Details

GMF.GMF_XLA_EXTRACT_LINES_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
LINE_ID NUMBER
Yes Line Identifier
HEADER_ID NUMBER
Yes Header Identifier
REFERENCE_NO NUMBER
Yes Reference Number
EVENT_ID NUMBER

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
Yes Cost Component Class Identifier
COST_ANALYSIS_CODE VARCHAR2 (50)
Cost Analysis Code
COMPONENT_COST NUMBER
Yes Component Cost
USAGE_IND NUMBER
Yes 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
ORGANIZATION_ID NUMBER

Organization Identifier
SUBINVENTORY_CODE VARCHAR2 (100)
Sub-Inventory Code
XFER_SUBINVENTORY_CODE VARCHAR2 (100)
Transfer Sub-Inventory Code
LOCATOR_ID NUMBER

Locator Identifier
TRANSACTION_ACCOUNT_ID NUMBER

Transaction Account Identifer
ENTERED_AMOUNT NUMBER

Entered Amount
ACCOUNTED_AMOUNT NUMBER

Accounted Amount
LOT_NUMBER VARCHAR2 (80)
Lot Number
Query Text

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


SELECT LINE_ID
,      HEADER_ID
,      REFERENCE_NO
,      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
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      XFER_SUBINVENTORY_CODE
,      LOCATOR_ID
,      TRANSACTION_ACCOUNT_ID
,      ENTERED_AMOUNT
,      ACCOUNTED_AMOUNT
,      LOT_NUMBER
FROM GMF.GMF_XLA_EXTRACT_LINES_GT;

Dependencies

[top of page]

GMF.GMF_XLA_EXTRACT_LINES_GT does not reference any database object

GMF.GMF_XLA_EXTRACT_LINES_GT is referenced by following:

SchemaAPPS
SynonymGMF_XLA_EXTRACT_LINES_GT