[Home] [Help] [Dependency Information]
Object Name: | GL_JE_INCLUSION_RULES |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_JE_INCLUSION_RULES |
Subobject Name: | |
Status: | VALID |
GL_JE_INCLUSION_RULES stores a set of journal sources and categories to be included/excluded for various kinds of processing.
This table will be used for multiple purposes and may be populated through multiple user interfaces. For example, it is used by the Daily Business Intelligence (DBI) to define sources and categories that will be extracted for reporting purposes for a given ledger.
INCLUDE_FLAG indicates if a particular source and category combination is to be included (Y) or excluded (N) for processing.
Rules defined in this table could be entered by user or system generated. System generated rules cannot be modified by the user. USER_UPDATABLE_FLAG indicates if a user can modify the rule or not.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_JE_INCLUSION_RULES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
JE_RULE_SET_ID
JE_SOURCE_NAME JE_CATEGORY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JE_RULE_SET_ID | NUMBER | (15) | Yes | Journal inclusion rule set identifier |
JE_SOURCE_NAME | VARCHAR2 | (25) | Yes | Journal entry source |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Yes | Journal entry category |
USER_UPDATABLE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether this is a user updatable rule or not |
INCLUDE_FLAG | VARCHAR2 | (1) | Yes | Indicate whether this journal source/category will be included or excluded for processing |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT JE_RULE_SET_ID
, JE_SOURCE_NAME
, JE_CATEGORY_NAME
, USER_UPDATABLE_FLAG
, INCLUDE_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM GL.GL_JE_INCLUSION_RULES;
GL.GL_JE_INCLUSION_RULES does not reference any database object
GL.GL_JE_INCLUSION_RULES is referenced by following:
|
|
|