[Home] [Help] [Dependency Information]
Object Name: | JE_GR_TRNOVR_RULES |
---|---|
Object Type: | TABLE |
Owner: | JE |
FND Design Data: | JE.JE_GR_TRNOVR_RULES |
Subobject Name: | |
Status: | VALID |
This table stores data for each exclusion rule created. Each row includes the application ID, rule name, rule ID, enabled flag, description and other information. The primary key for this table is TRNOVR_RULE_ID. The rule rame is also unique. Each rule will have a list of customer/supplier type codes, invoice/transaction type codes and invoice/transaction line type codes. The rule ID will be passed as a parameter in selecting the records to be listed in the report.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JE_GR_TRNOVR_RULES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRNOVR_RULE_ID |
JE_GR_TRNOVR_RULES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRNOVR_RULE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRNOVR_RULE_ID | NUMBER | (15) | Yes | Unique identifier for each exclusion rule created |
APPLICATION_ID | NUMBER | (15) | Yes | Identifier which indicates the application to which the groups belong |
TRNOVR_RULE_NAME | VARCHAR2 | (100) | Yes | Exclusion name |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | 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 | |
ENABLED_FLAG | VARCHAR2 | (1) | Flag which indicates if the Inclusion/Exclusion Rule is enabled | |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ATTRIBUTE_CATEGORY | 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 | |
LEGAL_ENTITY_ID | NUMBER | (15) | Legal entity identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TRNOVR_RULE_ID
, APPLICATION_ID
, TRNOVR_RULE_NAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ENABLED_FLAG
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LEGAL_ENTITY_ID
FROM JE.JE_GR_TRNOVR_RULES;
JE.JE_GR_TRNOVR_RULES does not reference any database object
JE.JE_GR_TRNOVR_RULES is referenced by following:
|
|
|