[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JE_GR_TRNOVR_RULE_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | JE |
| FND Design Data: |  JE.JE_GR_TRNOVR_RULE_LINES
|
| Subobject Name: | |
| Status: | VALID |
This table stores data for each exclusion rule line created. Each row includes the application ID, rule ID, rule line ID, lookup type, lookup code, excluded flag, description and other information. The primary key for this table is TRNOVR_ RULE_LINE_ID. Each rule line correspond to a lookup type and a lookup code. Each rule line associated with a rule name. The rule lines have exclude flags which specify whether the records fetched should be included or excluded from the listing the type of supplier/customer associated at the customer or supplier level, the type of invoice associated at the invoice level and based on the line type associated at transaction lines level.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JE_GR_TRNOVR_RULE_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 TRNOVR_RULE_LINE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRNOVR_RULE_LINE_ID | NUMBER | (15) | Yes | Unique identifier for each exclusion rule line created |
| APPLICATION_ID | NUMBER | (15) | Yes | Identifier which indicates the application to which the groups belong |
| TRNOVR_RULE_ID | NUMBER | (15) | Yes | Unique ID for each exclusion rule created |
| LOOKUP_TYPE | VARCHAR2 | (30) | Yes | Type of the turnover group |
| LOOKUP_CODE | VARCHAR2 | (30) | Yes | Group identifier of the parent group being included |
| EXCLUDE_FLAG | VARCHAR2 | (1) | Yes | Flag which indicates if the group is included or excluded |
| 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 | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT TRNOVR_RULE_LINE_ID
, APPLICATION_ID
, TRNOVR_RULE_ID
, LOOKUP_TYPE
, LOOKUP_CODE
, EXCLUDE_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM JE.JE_GR_TRNOVR_RULE_LINES;
JE.JE_GR_TRNOVR_RULE_LINES does not reference any database object
JE.JE_GR_TRNOVR_RULE_LINES is referenced by following:
APPS
JE_GR_TRNOVR_RULE_LINES
|
|
|
|