[Home] [Help]
[Dependency Information]
Object Name: | AP_AUD_RULE_ASSIGNMENTS_ALL |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
AP_AUD_RULE_ASSIGNMENTS_ALL is an audit-specific table that contains rule set assignments for organizations. The data in this table is used to determine which audit rule to use, when deciding whether an expense report should be audited and whether to place the employee on the audit list.
The primary key for this table is RULE_ASSIGNMENT_ID.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_AUD_RULE_ASSIGNMENTS_ALL_U1 | NORMAL | UNIQUE |
![]() |
![]() |
AP_AUD_RULE_ASSIGNMENTS_ALL_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
AP_AUD_RULE_ASSIGNMENTS_ALL_N2 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ASSIGNMENT_ID | NUMBER | (15) | Yes | Rule set assignment unique identifier. |
RULE_SET_ID | NUMBER | (15) | Yes | Rule set identifier. |
ORG_ID | NUMBER | (15) | Yes | Organization identifier |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
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). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
START_DATE | DATE | Date that the audit rule becomes active for the organization. | ||
END_DATE | DATE | Date that the audit rule is no longer active for the organization. |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ASSIGNMENT_ID
, RULE_SET_ID
, ORG_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, START_DATE
, END_DATE
FROM AP.AP_AUD_RULE_ASSIGNMENTS_ALL;
AP.AP_AUD_RULE_ASSIGNMENTS_ALL does not reference any database object
AP.AP_AUD_RULE_ASSIGNMENTS_ALL is referenced by following:
|
|
|