[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_GTA_RULE_DFFS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.AR_GTA_RULE_DFFS_ALL
|
| Subobject Name: | |
| Status: | VALID |
The AR_GTA_RULE_DFFS_ALL table stores information about DFFs(Descriptive FlexField) that defined for the header of AR transactions, DFFs� value and corresponding filter condition flag , these information are associated with transfer rules. There is a one-to-many relationship between the transfer rule in the table �AR_GTA_RULE_HEADERS_ALL� and records in table �AR_GTA_RULE_DFFS_ALL�. Each row in this table includes a condition rule, alternative value of which is �I�/�E�. , context code that is one of structure name defined for DFF in the header level of AR transactions, Column that is one attribute column name setup in the DFF context and value of a DFF attribute column. Each row also contains the associated transfer rule header ID. After submitted with a transfer rule parameter, GTA transfer program will use condition rules, context codes, attribute column name and column value that associate with that transfer rule to construct transferring filter condition of AR transactions if any.
The primary key of this table is RULE_LINE_ID.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AR_GTA_RULE_DFFS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 RULE_LINE_ID
|
| AR_GTA_RULE_DFFS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
RULE_HEADER_ID
CONTEXT_CODE
ATTRIBUTE_COLUMN
ATTRIBUTE_VALUE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RULE_LINE_ID | NUMBER | Yes | Rule line identifier | |
| RULE_HEADER_ID | NUMBER | (15) | Yes | Rule header identifier |
| ORG_ID | NUMBER | Yes | Organization identifier | |
| CONDITION_RULE | VARCHAR2 | (1) | Yes | Condition type, �I� for �Include�, �E� for �Exclude� |
| CONTEXT_CODE | VARCHAR2 | (30) | Yes | Descriptive flexfield structure name |
| ATTRIBUTE_COLUMN | VARCHAR2 | (30) | Yes | DFF Column name |
| ATTRIBUTE_VALUE | VARCHAR2 | (150) | Yes | Value of the DFF column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (22) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID) |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created | |
| CREATED_BY | NUMBER | (22) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID) |
| LAST_UPDATE_LOGIN | NUMBER | 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 RULE_LINE_ID
, RULE_HEADER_ID
, ORG_ID
, CONDITION_RULE
, CONTEXT_CODE
, ATTRIBUTE_COLUMN
, ATTRIBUTE_VALUE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM AR.AR_GTA_RULE_DFFS_ALL;
AR.AR_GTA_RULE_DFFS_ALL does not reference any database object
AR.AR_GTA_RULE_DFFS_ALL is referenced by following:
AR
AR_GTA_RULE_DFFS_ALL#
|
|
|
|