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

TABLE: BIS.EDW_GL_ACCT5_M

Object Details
Object Name: EDW_GL_ACCT5_M
Object Type: TABLE
Owner: BIS
FND Design Data: TableBIS.EDW_GL_ACCT5_M
TableFII.EDW_GL_ACCT5_M
Subobject Name:
Status: VALID


This is a denormalized star table for the GL Accounting Key Flexfield dimension. It contains records for lowest level of the GL Accounting Key Flexfield dimension and their parentage up to the top level, across all hierarchies.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_GL_ACCT5_M_U3 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnL1_PK
ColumnL1_PK_KEY
EDW_GL_ACCT5_M_U4 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnL1_PK_KEY
Columns
Name Datatype Length Mandatory Comments
H213_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H214_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H214_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H214_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H215_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H215_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H215_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H206_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H206_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H206_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H207_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H207_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H207_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H208_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H208_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H408_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H408_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H408_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H409_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H409_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H409_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H410_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H410_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H413_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H413_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H413_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H414_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H414_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H414_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H415_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H415_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H211_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H211_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H211_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H212_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H212_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H212_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H213_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H213_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H405_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H406_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H406_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H406_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H407_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H407_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H407_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H309_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H310_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H310_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H310_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H311_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H311_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H311_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H208_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H209_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H209_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H209_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H210_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H210_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H210_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H204_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H204_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H204_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H205_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H205_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H205_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H314_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H315_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H315_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H315_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H402_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H402_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H402_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H304_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H305_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H305_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H305_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H306_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H306_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H306_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H115_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H115_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H115_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H202_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H202_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H202_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H203_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H203_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H203_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H415_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
TYPE_DESCRIPTION VARCHAR2 (80)
GL Key Accounting Flexfield segment
TYPE_NAME VARCHAR2 (80)
GL Key Accounting Flexfield segment
ALL_DESCRIPTION VARCHAR2 (80)
GL Key Accounting Flexfield segment
ALL_NAME VARCHAR2 (80)
GL Key Accounting Flexfield segment
H114_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H114_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H114_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H312_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H312_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H312_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H313_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H313_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H313_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H314_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H314_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H307_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H307_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H307_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H308_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H308_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H308_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H309_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H309_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H403_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H403_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H403_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H404_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H404_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H404_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H405_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H405_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H410_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H411_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H411_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H411_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H412_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H412_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H412_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H302_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H302_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H302_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H303_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H303_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H303_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H304_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H304_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H104_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H104_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H104_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H105_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H105_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H105_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H106_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H106_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H106_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
L1_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
L1_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
L1_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H102_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H102_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H102_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H103_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H103_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H103_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H111_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H111_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H112_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H112_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H112_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H113_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H111_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H113_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H113_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H109_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H109_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H109_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H110_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H110_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H110_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H107_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H107_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H107_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
H108_TYPE VARCHAR2 (80)
GL Key Accounting Flexfield segment
H108_DESCRIPTION VARCHAR2 (240)
GL Key Accounting Flexfield segment
H108_NAME VARCHAR2 (240)
GL Key Accounting Flexfield segment
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
L1_PK VARCHAR2 (240)
Level 1 primary key
H102_PK VARCHAR2 (240)
Hierarchy 1, level 2 primary key
H103_PK VARCHAR2 (240)
Hierarchy 1, level 3 primary key
H104_PK VARCHAR2 (240)
Hierarchy 1, level 4 primary key
H105_PK VARCHAR2 (240)
Hierarchy 1, level 5 primary key
H106_PK VARCHAR2 (240)
Hierarchy 1, level 6 primary key
H107_PK VARCHAR2 (240)
Hierarchy 1, level 7 primary key
H108_PK VARCHAR2 (240)
Hierarchy 1, level 8 primary key
H109_PK VARCHAR2 (240)
Hierarchy 1, level 9 primary key
H110_PK VARCHAR2 (240)
Hierarchy 1, level 10 primary key
H111_PK VARCHAR2 (240)
Hierarchy 1, level 11 primary key
H112_PK VARCHAR2 (240)
Hierarchy 1, level 12 primary key
H113_PK VARCHAR2 (240)
Hierarchy 1, level 13 primary key
H114_PK VARCHAR2 (240)
Hierarchy 1, level 14 primary key
H115_PK VARCHAR2 (240)
Hierarchy 1, level 15 primary key
H202_PK VARCHAR2 (240)
Hierarchy 2, level 2 primary key
H203_PK VARCHAR2 (240)
Hierarchy 2, level 3 primary key
H204_PK VARCHAR2 (240)
Hierarchy 2, level 4 primary key
H205_PK VARCHAR2 (240)
Hierarchy 2, level 5 primary key
H206_PK VARCHAR2 (240)
Hierarchy 2, level 6 primary key
H207_PK VARCHAR2 (240)
Hierarchy 2, level 7 primary key
H208_PK VARCHAR2 (240)
Hierarchy 2, level 8 primary key
H209_PK VARCHAR2 (240)
Hierarchy 2, level 9 primary key
H210_PK VARCHAR2 (240)
Hierarchy 2, level 10 primary key
H211_PK VARCHAR2 (240)
Hierarchy 2, level 11 primary key
H212_PK VARCHAR2 (240)
Hierarchy 2, level 12 primary key
H213_PK VARCHAR2 (240)
Hierarchy 2, level 13 primary key
H214_PK VARCHAR2 (240)
Hierarchy 2, level 14 primary key
H215_PK VARCHAR2 (240)
Hierarchy 2, level 15 primary key
H302_PK VARCHAR2 (240)
Hierarchy 3, level 2 primary key
H303_PK VARCHAR2 (240)
Hierarchy 3, level 3 primary key
H304_PK VARCHAR2 (240)
Hierarchy 3, level 4 primary key
H305_PK VARCHAR2 (240)
Hierarchy 3, level 5 primary key
H306_PK VARCHAR2 (240)
Hierarchy 3, level 6 primary key
H307_PK VARCHAR2 (240)
Hierarchy 3, level 7 primary key
H308_PK VARCHAR2 (240)
Hierarchy 3, level 8 primary key
H309_PK VARCHAR2 (240)
Hierarchy 3, level 9 primary key
H310_PK VARCHAR2 (240)
Hierarchy 3, level 10 primary key
H311_PK VARCHAR2 (240)
Hierarchy 3, level 11 primary key
H312_PK VARCHAR2 (240)
Hierarchy 3, level 12 primary key
H313_PK VARCHAR2 (240)
Hierarchy 3, level 13 primary key
H314_PK VARCHAR2 (240)
Hierarchy 3, level 14 primary key
H315_PK VARCHAR2 (240)
Hierarchy 3, level 15 primary key
H402_PK VARCHAR2 (240)
Hierarchy 4, level 2 primary key
H403_PK VARCHAR2 (240)
Hierarchy 4, level 3 primary key
H404_PK VARCHAR2 (240)
Hierarchy 4, level 4 primary key
H405_PK VARCHAR2 (240)
Hierarchy 4, level 5 primary key
H406_PK VARCHAR2 (240)
Hierarchy 4, level 6 primary key
H407_PK VARCHAR2 (240)
Hierarchy 4, level 7 primary key
H408_PK VARCHAR2 (240)
Hierarchy 4, level 8 primary key
H409_PK VARCHAR2 (240)
Hierarchy 4, level 9 primary key
H410_PK VARCHAR2 (240)
Hierarchy 4, level 10 primary key
H411_PK VARCHAR2 (240)
Hierarchy 4, level 11 primary key
H412_PK VARCHAR2 (240)
Hierarchy 4, level 12 primary key
H413_PK VARCHAR2 (240)
Hierarchy 4, level 13 primary key
H414_PK VARCHAR2 (240)
Hierarchy 4, level 14 primary key
H415_PK VARCHAR2 (240)
Hierarchy 4, level 15 primary key
TYPE_PK VARCHAR2 (80)
Type level primary key
ALL_PK VARCHAR2 (80)
All level primary key
L1_PK_KEY NUMBER

System generated unique identifer for GL Key Accounting Flexfield name.
Query Text

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


SELECT H213_NAME
,      H214_TYPE
,      H214_DESCRIPTION
,      H214_NAME
,      H215_TYPE
,      H215_DESCRIPTION
,      H215_NAME
,      H206_TYPE
,      H206_DESCRIPTION
,      H206_NAME
,      H207_TYPE
,      H207_DESCRIPTION
,      H207_NAME
,      H208_TYPE
,      H208_DESCRIPTION
,      H408_TYPE
,      H408_DESCRIPTION
,      H408_NAME
,      H409_TYPE
,      H409_DESCRIPTION
,      H409_NAME
,      H410_TYPE
,      H410_DESCRIPTION
,      H413_TYPE
,      H413_DESCRIPTION
,      H413_NAME
,      H414_TYPE
,      H414_DESCRIPTION
,      H414_NAME
,      H415_TYPE
,      H415_DESCRIPTION
,      H211_TYPE
,      H211_DESCRIPTION
,      H211_NAME
,      H212_TYPE
,      H212_DESCRIPTION
,      H212_NAME
,      H213_TYPE
,      H213_DESCRIPTION
,      H405_NAME
,      H406_TYPE
,      H406_DESCRIPTION
,      H406_NAME
,      H407_TYPE
,      H407_DESCRIPTION
,      H407_NAME
,      H309_NAME
,      H310_TYPE
,      H310_DESCRIPTION
,      H310_NAME
,      H311_TYPE
,      H311_DESCRIPTION
,      H311_NAME
,      H208_NAME
,      H209_TYPE
,      H209_DESCRIPTION
,      H209_NAME
,      H210_TYPE
,      H210_DESCRIPTION
,      H210_NAME
,      H204_TYPE
,      H204_DESCRIPTION
,      H204_NAME
,      H205_TYPE
,      H205_DESCRIPTION
,      H205_NAME
,      H314_NAME
,      H315_TYPE
,      H315_DESCRIPTION
,      H315_NAME
,      H402_TYPE
,      H402_DESCRIPTION
,      H402_NAME
,      H304_NAME
,      H305_TYPE
,      H305_DESCRIPTION
,      H305_NAME
,      H306_TYPE
,      H306_DESCRIPTION
,      H306_NAME
,      H115_TYPE
,      H115_DESCRIPTION
,      H115_NAME
,      H202_TYPE
,      H202_DESCRIPTION
,      H202_NAME
,      H203_TYPE
,      H203_DESCRIPTION
,      H203_NAME
,      H415_NAME
,      TYPE_DESCRIPTION
,      TYPE_NAME
,      ALL_DESCRIPTION
,      ALL_NAME
,      H114_TYPE
,      H114_DESCRIPTION
,      H114_NAME
,      H312_TYPE
,      H312_DESCRIPTION
,      H312_NAME
,      H313_TYPE
,      H313_DESCRIPTION
,      H313_NAME
,      H314_TYPE
,      H314_DESCRIPTION
,      H307_TYPE
,      H307_DESCRIPTION
,      H307_NAME
,      H308_TYPE
,      H308_DESCRIPTION
,      H308_NAME
,      H309_TYPE
,      H309_DESCRIPTION
,      H403_TYPE
,      H403_DESCRIPTION
,      H403_NAME
,      H404_TYPE
,      H404_DESCRIPTION
,      H404_NAME
,      H405_TYPE
,      H405_DESCRIPTION
,      H410_NAME
,      H411_TYPE
,      H411_DESCRIPTION
,      H411_NAME
,      H412_TYPE
,      H412_DESCRIPTION
,      H412_NAME
,      H302_TYPE
,      H302_DESCRIPTION
,      H302_NAME
,      H303_TYPE
,      H303_DESCRIPTION
,      H303_NAME
,      H304_TYPE
,      H304_DESCRIPTION
,      H104_TYPE
,      H104_DESCRIPTION
,      H104_NAME
,      H105_TYPE
,      H105_DESCRIPTION
,      H105_NAME
,      H106_TYPE
,      H106_DESCRIPTION
,      H106_NAME
,      L1_TYPE
,      L1_DESCRIPTION
,      L1_NAME
,      H102_TYPE
,      H102_DESCRIPTION
,      H102_NAME
,      H103_TYPE
,      H103_DESCRIPTION
,      H103_NAME
,      H111_DESCRIPTION
,      H111_NAME
,      H112_TYPE
,      H112_DESCRIPTION
,      H112_NAME
,      H113_TYPE
,      H111_TYPE
,      H113_DESCRIPTION
,      H113_NAME
,      H109_TYPE
,      H109_DESCRIPTION
,      H109_NAME
,      H110_TYPE
,      H110_DESCRIPTION
,      H110_NAME
,      H107_TYPE
,      H107_DESCRIPTION
,      H107_NAME
,      H108_TYPE
,      H108_DESCRIPTION
,      H108_NAME
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      L1_PK
,      H102_PK
,      H103_PK
,      H104_PK
,      H105_PK
,      H106_PK
,      H107_PK
,      H108_PK
,      H109_PK
,      H110_PK
,      H111_PK
,      H112_PK
,      H113_PK
,      H114_PK
,      H115_PK
,      H202_PK
,      H203_PK
,      H204_PK
,      H205_PK
,      H206_PK
,      H207_PK
,      H208_PK
,      H209_PK
,      H210_PK
,      H211_PK
,      H212_PK
,      H213_PK
,      H214_PK
,      H215_PK
,      H302_PK
,      H303_PK
,      H304_PK
,      H305_PK
,      H306_PK
,      H307_PK
,      H308_PK
,      H309_PK
,      H310_PK
,      H311_PK
,      H312_PK
,      H313_PK
,      H314_PK
,      H315_PK
,      H402_PK
,      H403_PK
,      H404_PK
,      H405_PK
,      H406_PK
,      H407_PK
,      H408_PK
,      H409_PK
,      H410_PK
,      H411_PK
,      H412_PK
,      H413_PK
,      H414_PK
,      H415_PK
,      TYPE_PK
,      ALL_PK
,      L1_PK_KEY
FROM BIS.EDW_GL_ACCT5_M;

Dependencies

[top of page]

BIS.EDW_GL_ACCT5_M does not reference any database object

BIS.EDW_GL_ACCT5_M is referenced by following:

SchemaAPPS
SynonymEDW_GL_ACCT5_M