[Home] [Help] [Dependency Information]
Object Name: | OKC_CLASS_OPERATIONS |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_CLASS_OPERATIONS |
Subobject Name: | |
Status: | VALID |
Development seeded data with operations available for classes. Operation instances are created only based on the data in this table. For example, RENEWAL operation allowed for class CORPORATE and RENCON (Renewal Consolidation) allowed for class SERVICE.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_CLASS_OPERATIONS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ID |
OKC_CLASS_OPERATIONS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
OPN_CODE
CLS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Surrogate key used for primary unique identifiers | |
OPN_CODE | VARCHAR2 | (30) | Yes | Operation Code associated with the Class. Foreign Key to FND_LOOKUP_VALUES for Operaion Code |
CLS_CODE | VARCHAR2 | (30) | Yes | Class for which operation is defined. |
SEARCH_FUNCTION_ID | NUMBER | Foreign key to FND_FORM_FUNCTIONS for form to be used for serach | ||
DETAIL_FUNCTION_ID | NUMBER | Foreign key to FND_FORM_FUNCTIONS for form to be used for detailed request | ||
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 | ||
PDF_ID | NUMBER | Process associated with the class for this operation. Foreign key to OKC_PROCESS_DEFS_B | ||
QA_PDF_ID | NUMBER | Process definition id. Foreign key from okc_process_defns_b | ||
GRID_DATASOURCE_NAME | VARCHAR2 | (30) | The Name of the Grid that will be displayed on the Contracts tab of the Ebusiness Center form. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OPN_CODE
, CLS_CODE
, SEARCH_FUNCTION_ID
, DETAIL_FUNCTION_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, PDF_ID
, QA_PDF_ID
, GRID_DATASOURCE_NAME
FROM OKC.OKC_CLASS_OPERATIONS;
OKC.OKC_CLASS_OPERATIONS does not reference any database object
OKC.OKC_CLASS_OPERATIONS is referenced by following:
|
|
|