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


TABLE: GL.GL_BC_DUAL2

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


GL_BC_DUAL2 contains one row that the Funds Checker locks in row share mode when it needs to summarize detail transactions for those summary templates whose checking level is absolute or advisory. The Add/Delete Summary Templates program also contains logic to summarize accepted detail transactions by the template it is creating, if the template is absolute or advisory then it will lock GL_BC_DUAL2 in exclusive mode. The purpose for these locks is to prevent both programs from summarizing detail transactions and also to avoid the case where neither does the summarization.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DUMMY VARCHAR2 (2)
Single column for locking
Query Text

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


SELECT DUMMY
FROM GL.GL_BC_DUAL2;

Dependencies

[top of page]

GL.GL_BC_DUAL2 does not reference any database object

GL.GL_BC_DUAL2 is referenced by following:

SchemaGL
ViewGL_BC_DUAL2#