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

TABLE: JL.JL_ZZ_GL_AXI_TMP

Object Details
Object Name: JL_ZZ_GL_AXI_TMP
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_ZZ_GL_AXI_TMP
Subobject Name:
Status: VALID


JL_ZZ_GL_AXI_TMP stores information used to issue the inflation adjustment report. The Inflation Adjustment process inserts data into this table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_ZZ_GL_AXI_TMP_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnPERIOD_FROM
ColumnCODE_COMBINATION_ID
ColumnAXI_RUN_ID
Columns
Name Datatype Length Mandatory Comments
CODE_COMBINATION_ID NUMBER (15) Yes Accounting flexfield combination defining column
AXI_RUN_ID NUMBER (15) Yes Adjustment process execution identifier
GROUP_ID NUMBER (15)
Journal import group identifier
PERIOD_FROM VARCHAR2 (15)
Inflation adjusted from period
PERIOD_TO VARCHAR2 (15)
Inflation adjusted to period
YTD_BALANCE NUMBER

Year to date balance
PTD_BALANCE NUMBER

Period to date balance
ADJUSTMENT_AMOUNT NUMBER

Adjustment resulting from the Inflation Adjustment process
FV_FLAG VARCHAR2 (1)
Flags is 'Y' if the adjustment process found an Inflation adjustment date (Fecha Valor), else it stores 'N'
Query Text

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


SELECT CODE_COMBINATION_ID
,      AXI_RUN_ID
,      GROUP_ID
,      PERIOD_FROM
,      PERIOD_TO
,      YTD_BALANCE
,      PTD_BALANCE
,      ADJUSTMENT_AMOUNT
,      FV_FLAG
FROM JL.JL_ZZ_GL_AXI_TMP;

Dependencies

[top of page]

JL.JL_ZZ_GL_AXI_TMP does not reference any database object

JL.JL_ZZ_GL_AXI_TMP is referenced by following:

SchemaAPPS
SynonymJL_ZZ_GL_AXI_TMP