[Home] [Help] [Dependency Information]
Object Name: | OKL_ACC_GEN_RULES_ALL |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_ACC_GEN_RULES_ALL |
Subobject Name: | |
Status: | VALID |
Account generator rules header. A row is created in this table every time account generator rule is defined for an accounting line type. The combination of accounting line type and operating unit is unique in this table. This table is stripped by operating unit.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_ACC_GEN_RULES_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | AE_LINE_TYPE |
OKL_ACC_GEN_RULES_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
OKL_ACC_GEN_RULES_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SET_OF_BOOKS_ID |
OKL_ACC_GEN_RULES_ALL_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
SET_OF_BOOKS_ID | NUMBER | Yes | Accounting books defining column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
AE_LINE_TYPE | VARCHAR2 | (30) | Yes | Accounting event line type |
ORG_ID | NUMBER | Operating unit identifier | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, SET_OF_BOOKS_ID
, OBJECT_VERSION_NUMBER
, AE_LINE_TYPE
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_ACC_GEN_RULES_ALL;
OKL.OKL_ACC_GEN_RULES_ALL does not reference any database object
OKL.OKL_ACC_GEN_RULES_ALL is referenced by following:
|
|
|