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

TABLE: GL.GL_ALLOC_FORMULA_LINES

Object Details
Object Name: GL_ALLOC_FORMULA_LINES
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_ALLOC_FORMULA_LINES
Subobject Name:
Status: VALID


GL_ALLOC_FORMULA_LINES stores information about MassAllocation and MassBudget formula lines. This table corresponds to the Formula window of the Define MassAllocations and Define MassBudgets forms. There are four or five lines associated with each MassBudget formula, and there are five lines associated with each MassAllocation formula. Each row includes the allocation formula ID, line number, and other information about the line. Line numbers 1, 2, 3, 4, and 5 correspond to rows A, B, C, T, and O, respectively, on the Define MassAllocations and Define MassBudgets forms. Segment values are stored in the SEGMENT columns appropriate to the chart of accounts structure. Segment types (C, L, or S) are stored as a concatenated string in the SEGMENT_TYPES_KEY column. LINE_TYPE is 'E' for lines 1, 2, and 3, 'T' for line 4, and 'O' for line 5. OPERATOR is always 'E' and is not used. SEGMENT_BREAK_KEY is not used.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_ALLOC_FORMULA_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnALLOCATION_FORMULA_ID
ColumnLINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
ALLOCATION_FORMULA_ID NUMBER (15) Yes Mass allocation formula defining column
LINE_NUMBER NUMBER (15) Yes Formula line number (1,2,3,4 or 5)
LINE_TYPE VARCHAR2 (1) Yes Formula line type (Entered, Target, or Offset)
OPERATOR VARCHAR2 (3) Yes Not currently used (Always "E")
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
AMOUNT NUMBER

Formula line amount
RELATIVE_PERIOD VARCHAR2 (25)
Relative position of the accounting period whose balance is to be used in the allocation formula
PERIOD_NAME VARCHAR2 (15)
Accounting period
CURRENCY_CODE VARCHAR2 (15)
Currency
TRANSACTION_CURRENCY_11I VARCHAR2 (1)
Obsolete
ACTUAL_FLAG VARCHAR2 (1)
Balance type (Actual, Budget, or Encumbrance)
BUDGET_VERSION_ID NUMBER (15)
Budget version defining column
ENCUMBRANCE_TYPE_ID NUMBER (15)
Encumbrance type defining column
AMOUNT_TYPE VARCHAR2 (15)
Amount type
SEGMENT_TYPES_KEY VARCHAR2 (60)
Concatenated string of segment types (C, L, or S)
SEGMENT_BREAK_KEY VARCHAR2 (60)
Not currently used
SEGMENT1 VARCHAR2 (25)
Key flexfield segment
SEGMENT2 VARCHAR2 (25)
Key flexfield segment
SEGMENT3 VARCHAR2 (25)
Key flexfield segment
SEGMENT4 VARCHAR2 (25)
Key flexfield segment
SEGMENT5 VARCHAR2 (25)
Key flexfield segment
SEGMENT6 VARCHAR2 (25)
Key flexfield segment
SEGMENT7 VARCHAR2 (25)
Key flexfield segment
SEGMENT8 VARCHAR2 (25)
Key flexfield segment
SEGMENT9 VARCHAR2 (25)
Key flexfield segment
SEGMENT10 VARCHAR2 (25)
Key flexfield segment
SEGMENT11 VARCHAR2 (25)
Key flexfield segment
SEGMENT12 VARCHAR2 (25)
Key flexfield segment
SEGMENT13 VARCHAR2 (25)
Key flexfield segment
SEGMENT14 VARCHAR2 (25)
Key flexfield segment
SEGMENT15 VARCHAR2 (25)
Key flexfield segment
SEGMENT16 VARCHAR2 (25)
Key flexfield segment
SEGMENT17 VARCHAR2 (25)
Key flexfield segment
SEGMENT18 VARCHAR2 (25)
Key flexfield segment
SEGMENT19 VARCHAR2 (25)
Key flexfield segment
SEGMENT20 VARCHAR2 (25)
Key flexfield segment
SEGMENT21 VARCHAR2 (25)
Key flexfield segment
SEGMENT22 VARCHAR2 (25)
Key flexfield segment
SEGMENT23 VARCHAR2 (25)
Key flexfield segment
SEGMENT24 VARCHAR2 (25)
Key flexfield segment
SEGMENT25 VARCHAR2 (25)
Key flexfield segment
SEGMENT26 VARCHAR2 (25)
Key flexfield segment
SEGMENT27 VARCHAR2 (25)
Key flexfield segment
SEGMENT28 VARCHAR2 (25)
Key flexfield segment
SEGMENT29 VARCHAR2 (25)
Key flexfield segment
SEGMENT30 VARCHAR2 (25)
Key flexfield segment
CURRENCY_TYPE VARCHAR2 (1)
Currency type: Entered, Total, Statistical
TRANSACTION_CURRENCY VARCHAR2 (30) Yes Transaction currency
ENTERED_CURRENCY VARCHAR2 (15)
Entered currency
LEDGER_CURRENCY VARCHAR2 (15)
Ledger currency
LEDGER_ID NUMBER (15)
Ledger defining column
LEDGER_ACTION_CODE VARCHAR2 (1)
Ledger action type:(Constant, Summary, or Looping)
Query Text

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


SELECT ALLOCATION_FORMULA_ID
,      LINE_NUMBER
,      LINE_TYPE
,      OPERATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      AMOUNT
,      RELATIVE_PERIOD
,      PERIOD_NAME
,      CURRENCY_CODE
,      TRANSACTION_CURRENCY_11I
,      ACTUAL_FLAG
,      BUDGET_VERSION_ID
,      ENCUMBRANCE_TYPE_ID
,      AMOUNT_TYPE
,      SEGMENT_TYPES_KEY
,      SEGMENT_BREAK_KEY
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      CURRENCY_TYPE
,      TRANSACTION_CURRENCY
,      ENTERED_CURRENCY
,      LEDGER_CURRENCY
,      LEDGER_ID
,      LEDGER_ACTION_CODE
FROM GL.GL_ALLOC_FORMULA_LINES;

Dependencies

[top of page]

GL.GL_ALLOC_FORMULA_LINES does not reference any database object

GL.GL_ALLOC_FORMULA_LINES is referenced by following:

SchemaGL
ViewGL_ALLOC_FORMULA_LINES#