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

TABLE: JL.JL_CO_GL_CONC_CTRL

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


This table contains one row for each execution of the Third Party Balances concurrent program. A record is created at the beginning of the process with Status equal to NULL. When the program is completed, the status will be updated to 'P'. If there is an Oracle error the status will be updated to 'E'. When a concurrent request is reversed, the status will be updated to 'R' and the reversed concurrent ID field populated with the appropriate concurrent ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_CO_GL_CONC_CTRL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_ID NUMBER (15) Yes Process request ID
SET_OF_BOOKS_ID NUMBER (15) Yes GL Set of Books ID
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
REVERSED_PROCESS_ID NUMBER (15)
Reversing process request ID
PERIOD_NAME VARCHAR2 (15)
Accounting Period
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
STATUS VARCHAR2 (2)
Process request Status : Null - Error, 'U' - Updated, 'R' - Reversed
BALANCE_CALCULATED VARCHAR2 (1)
Calculated Balance
Query Text

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


SELECT PROCESS_ID
,      SET_OF_BOOKS_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      REVERSED_PROCESS_ID
,      PERIOD_NAME
,      LAST_UPDATE_LOGIN
,      STATUS
,      BALANCE_CALCULATED
FROM JL.JL_CO_GL_CONC_CTRL;

Dependencies

[top of page]

JL.JL_CO_GL_CONC_CTRL does not reference any database object

JL.JL_CO_GL_CONC_CTRL is referenced by following:

SchemaJL
ViewJL_CO_GL_CONC_CTRL#