[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKC_RG_ROLE_DEFS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKC.OKC_RG_ROLE_DEFS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
DEFINITION
A business function generally describes
both a subject and object and the action of one in regard to the other
both the subject and the object can be thought of as playing a role
"doer" and "doee"
but we have already used ROLE and so we use MODE
It is necessary to indicate whether the mode is considered active or passive
eg. in a sentence "the boy hit the ball"
the subject is "the boy" the object is "the ball"
EXAMPLE
"vendor bills customer"
this explicitly identifies the active owner of the financial transaction "invoice"
MISCELLANEOUS
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | The address of the row in the database | |
| ID | NUMBER | Yes | 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. |
| SRD_ID | NUMBER | Yes | Foreign key to OKC_SUBCLASS_RG_DEFS. | |
| SRE_ID | NUMBER | Yes | Foreign key to OKC_SUBCLASS_ROLES. | |
| OPTIONAL_YN | VARCHAR2 | (3) | Yes/No field. | |
| SUBJECT_OBJECT_FLAG | VARCHAR2 | (3) | Yes | Indicates whether the mode is considered active or passive. |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
| ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
| 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. | |
| ACCESS_LEVEL | VARCHAR2 | (1) | Indicates the protection level for the record |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SRD_ID
, SRE_ID
, OPTIONAL_YN
, SUBJECT_OBJECT_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ACCESS_LEVEL
FROM APPS.OKC_RG_ROLE_DEFS_V;
APPS
OKC_RG_ROLE_DEFS
APPS
OKC_RG_PARTIES_BLK_HV
OKC_RG_PARTIES_BLK_V
OKC_RG_PARTIES_LOV_V
OKC_RRD_PVT
- show dependent code
OKC_RRD_PVT
- show dependent code
OKC_RULE_PUB
- show dependent code
OKC_SUBCLASS_PVT
- show dependent code
|
|
|
|