[Home] [Help] [Dependency Information]
Object Name: | OKC_K_ACCESSES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_K_ACCESSES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Access security is the intersection between the Contract Header and User or Security Group. It defines the access level (Full or Read Only) allowed to that user/group for that contract.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | The address of the row in the database | |
ID | NUMBER | Yes | Unique identifier of Contract access. Primary key column. | |
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. |
GROUP_ID | NUMBER | Unique identifier of the group for which access level is defined. Refers to GROUP_ID in JTF_RS_GROUPS_B | ||
CHR_ID | NUMBER | Yes | Unique identifier of contract for which access level is defined. Refers to ID in OKC_K_HEADERS_B | |
RESOURCE_ID | NUMBER | Unique identifier Resource. Refers to resource_id in JTF_RS_RESOURCE_EXTNS. | ||
ACCESS_LEVEL | VARCHAR2 | (3) | Yes | Specifies access level to contract. |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, GROUP_ID
, CHR_ID
, RESOURCE_ID
, ACCESS_LEVEL
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKC_K_ACCESSES_V;
|
|
|