[Home] [Help] [Dependency Information]
Object Name: | AMS_ACT_ACCESS_DENORM |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_ACT_ACCESS_DENORM |
Subobject Name: | |
Status: | VALID |
This table stores the object access information denormalized to resource Level. Any resource assigned to an object will be inserted realtime into this table. Teams are update through concurrent programs. Two concurrent programs AMS: Refresh JTF access denorm and AMS: Refresh AMS access denorm will be provided. The first program will refresh the denorm for all the changes in groups, group relations and group members done through Resource Manager. The second program will handle the changes in AMS_ACT_ACCESS table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_ACT_ACCESS_DENORM_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OBJECT_ID
RESOURCE_ID OBJECT_TYPE |
AMS_ACT_ACCESS_DENORM_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ACCESS_DENORM_ID |
AMS_ACT_ACCESS_DENORM_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RESOURCE_ID |
AMS_ACT_ACCESS_DENORM_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_DENORM_ID | NUMBER | Yes | Unique Identifier | |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | Unique activity type used across systems. |
OBJECT_ID | NUMBER | Yes | Unique activity code used across systems. e.g. Campaigns, events .. | |
RESOURCE_ID | NUMBER | Yes | Identifies the resource who has the access. | |
EDIT_METRICS_YN | VARCHAR2 | (1) | Flag to indicate if the resource has the previlige to edit the metrics of corresponding Objects | |
SOURCE_CODE | VARCHAR2 | (30) | Source Code for the associated Object Type | |
ACCESS_TYPE | VARCHAR2 | (1) | Reserved for future use. | |
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
CREATED_BY | NUMBER | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_DENORM_ID
, OBJECT_TYPE
, OBJECT_ID
, RESOURCE_ID
, EDIT_METRICS_YN
, SOURCE_CODE
, ACCESS_TYPE
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATED_BY
FROM AMS.AMS_ACT_ACCESS_DENORM;
AMS.AMS_ACT_ACCESS_DENORM does not reference any database object
AMS.AMS_ACT_ACCESS_DENORM is referenced by following:
|
|
|