DBA Data[Home] [Help] [Dependency Information]

TABLE: AR.AR_GTA_RULE_TRX_TYPES_ALL

Object Details
Object Name: AR_GTA_RULE_TRX_TYPES_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_GTA_RULE_TRX_TYPES_ALL
Subobject Name:
Status: VALID


The AR_GTA_RULE_TRX_TYPES_ALL table stores filter condition with transaction types for transfer rules , there is a one-to-many relationship between transfer rules stored in the table �AR_GTA_RULE_HEADERS_ALL and records in table �AR_GTA_RULE_TRX_TYPES_ALL.
Each row in this table contains a condition rule, alternative value of which is �I� or �E�, and a transaction type id that is the identifier of a transaction type defined in AR. Each row also stores the associated transfer rule header ID and description for the filter condition. After submitted with a transfer rule parameter, GTA transfer program will use condition rules and transaction type ids that associate with that transfer rule to construct transferring filter condition of AR transactions by transaction type if any.
The primary key in this table is RULE_LINE_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_GTA_RULE_TRX_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_LINE_ID
AR_GTA_RULE_TRX_TYPES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_HEADER_ID
ColumnCUST_TRX_TYPE_ID
Columns
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�
CUST_TRX_TYPE_ID NUMBER
Yes Transaction type identifier
DESCRIPTION VARCHAR2 (240)
Description
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)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RULE_LINE_ID
,      RULE_HEADER_ID
,      ORG_ID
,      CONDITION_RULE
,      CUST_TRX_TYPE_ID
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM AR.AR_GTA_RULE_TRX_TYPES_ALL;

Dependencies

[top of page]

AR.AR_GTA_RULE_TRX_TYPES_ALL does not reference any database object

AR.AR_GTA_RULE_TRX_TYPES_ALL is referenced by following:

SchemaAR
ViewAR_GTA_RULE_TRX_TYPES_ALL#