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

TABLE: GL.GL_ALLOC_FORMULAS

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


GL_ALLOC_FORMULAS stores information about MassAllocation and MassBudget formulas. Each row includes a formula's ID, name, and description. There is a one-to-many relationship between MassAllocation/MassBudget batches and MassAllocation/MassBudget formulas. This table corresponds to the Formula window of the Define MassAllocations and Define MassBudgets forms. You need one row for each MassAllocation or Massbudget formula.
VALIDATION_STATUS is 'N' when you first define, or have recently changed but not validated a MassAllocation or MassBudget formula, and 'V' after your formula has been successfully validated. If you submit a formula for validation, and it completes with errors, your VALIDATION_STATUS contains the value 'E'. RUN_SEQUENCE is not used.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_ALLOC_FORMULAS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnALLOCATION_FORMULA_ID
GL_ALLOC_FORMULAS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnALLOCATION_BATCH_ID
ColumnNAME
Columns
Name Datatype Length Mandatory Comments
ALLOCATION_FORMULA_ID NUMBER (15) Yes Mass allocation formula defining column
ALLOCATION_BATCH_ID NUMBER (15) Yes Mass allocation batch defining column
NAME VARCHAR2 (39) Yes Formula name
RUN_SEQUENCE NUMBER (6) Yes Not currently used
JE_CATEGORY_NAME VARCHAR2 (25) Yes Journal entry category
FULL_ALLOCATION_FLAG VARCHAR2 (1) Yes Full cost pool allocation flag
VALIDATION_STATUS VARCHAR2 (1) Yes Formula validation result
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
DESCRIPTION VARCHAR2 (240)
Formula description
CONVERSION_METHOD_CODE VARCHAR2 (2) Yes The conversion method for foreign currency MassAllocation formulas. The conversion method can be 'Converted Amount' or 'Calculated Amount'
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Type of currency exchange rate
Query Text

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


SELECT ALLOCATION_FORMULA_ID
,      ALLOCATION_BATCH_ID
,      NAME
,      RUN_SEQUENCE
,      JE_CATEGORY_NAME
,      FULL_ALLOCATION_FLAG
,      VALIDATION_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      CONVERSION_METHOD_CODE
,      CURRENCY_CONVERSION_TYPE
FROM GL.GL_ALLOC_FORMULAS;

Dependencies

[top of page]

GL.GL_ALLOC_FORMULAS does not reference any database object

GL.GL_ALLOC_FORMULAS is referenced by following:

SchemaGL
ViewGL_ALLOC_FORMULAS#