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

TABLE: GL.GL_IMP_COA_NORM_HIER_INTERFACE

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


Interface table to capture data for the import Child Ranges for Parent Chart of Account Segment Values.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_IMP_COA_NORM_HIER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVALUE_SET_NAME
ColumnPARENT_FLEX_VALUE
ColumnRANGE_ATTRIBUTE
ColumnCHILD_FLEX_VALUE_LOW
ColumnCHILD_FLEX_VALUE_HIGH
Columns
Name Datatype Length Mandatory Comments
BATCH_NUMBER VARCHAR2 (40) Yes Identifier to identify the set of records to be processed
NORM_HIER_INT_ID NUMBER (15) Yes Sequence generated unique identifier for the Child Ranges
VALUE_SET_NAME VARCHAR2 (60) Yes Value set name to which segment value need to be added or updated
PARENT_FLEX_VALUE VARCHAR2 (60) Yes Parent segment value for which child ranges are being defined
RANGE_ATTRIBUTE VARCHAR2 (1) Yes Range attribute for the range. Valid values are 'P' for parent range and 'C' for child range.
CHILD_FLEX_VALUE_LOW VARCHAR2 (60) Yes The low value of the range of child values
CHILD_FLEX_VALUE_HIGH VARCHAR2 (60) Yes The high value of the range of child values
STATUS VARCHAR2 (1) Yes Processing status for interface line. Initially populate with value 'N'.
Query Text

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


SELECT BATCH_NUMBER
,      NORM_HIER_INT_ID
,      VALUE_SET_NAME
,      PARENT_FLEX_VALUE
,      RANGE_ATTRIBUTE
,      CHILD_FLEX_VALUE_LOW
,      CHILD_FLEX_VALUE_HIGH
,      STATUS
FROM GL.GL_IMP_COA_NORM_HIER_INTERFACE;

Dependencies

[top of page]

GL.GL_IMP_COA_NORM_HIER_INTERFACE does not reference any database object

GL.GL_IMP_COA_NORM_HIER_INTERFACE is referenced by following:

SchemaGL
ViewGL_IMP_COA_NORM_HIER_INTERFAC#