[Home] [Help] [Dependency Information]
Object Name: | OKC_K_ACCESSES |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_K_ACCESSES |
Subobject Name: | |
Status: | VALID |
Defines the level of access (full or read only) granted to a resource or resource group for a particular contract.
In order for a user to see or modify a contract, that user must either have selected a responsibility that has been granted access to one or more subclasses of contracts, or be associated with a resource or resource group to which access has been granted. If none are true, then the user will not be able to see the contract.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_K_ACCESSES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKC_K_ACCESSES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CHR_ID
RESOURCE_ID GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Unique identifier of Contract access. Primary key column. | |
CHR_ID | NUMBER | Yes | Unique identifier of contract for which access level is defined. Refers to ID in OKC_K_HEADERS_B | |
GROUP_ID | NUMBER | Unique identifier of the group for which access level is defined. Refers to GROUP_ID in JTF_RS_GROUPS_B | ||
RESOURCE_ID | NUMBER | Unique identifier Resource. Refers to resource_id in JTF_RS_RESOURCE_EXTNS. | ||
ACCESS_LEVEL | VARCHAR2 | (3) | Yes | Specifies access to contract level. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CHR_ID
, GROUP_ID
, RESOURCE_ID
, ACCESS_LEVEL
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM OKC.OKC_K_ACCESSES;
OKC.OKC_K_ACCESSES does not reference any database object
OKC.OKC_K_ACCESSES is referenced by following:
|
|
|