[Home] [Help] [Dependency Information]
Object Name: | RA_GROUP_BYS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.RA_GROUP_BYS |
Subobject Name: | |
Status: | VALID |
The RA_GROUP_BYS table holds a row for every column that each grouping rule uses to group invoice lines. For example, if you define a grouping rule that groups invoice lines by purchase order number and shipping date, two rows will exist in this table for each combination of transaction class, as defined in the RA_GROUPING_TRX_TYPES table, and grouping rule.
.
The primary keys for this table are GROUPING_TRX_TYPE_ID and COLUMN_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RA_GROUP_BYS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
GROUPING_TRX_TYPE_ID
COLUMN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUPING_TRX_TYPE_ID | NUMBER | (15) | Yes | Grouping transaction type identifier. Foreign key to the RA_GROUPING_TRX_TYPES table. |
COLUMN_ID | NUMBER | (15) | Yes | Grouping column identifier. Foreign key to the RA_GROUP_BY_COLUMNS table. |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
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 | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT GROUPING_TRX_TYPE_ID
, COLUMN_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_LOGIN
FROM AR.RA_GROUP_BYS;
AR.RA_GROUP_BYS does not reference any database object
AR.RA_GROUP_BYS is referenced by following:
|
|
|