[Home] [Help]
[Dependency Information]
Object Name: | OKL_FE_CRIT_CAT_DEF_B |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This table contains the definition of a criteria category. It stores data for both eligibility criteria categories and adjustment categories.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_FE_CRIT_CAT_DEF_B_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() |
OKL_FE_CRIT_CAT_DEF_B_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
OKL_FE_CRIT_CAT_DEF_B_N2 | NORMAL | NONUNIQUE |
![]() |
![]() |
OKL_FE_CRIT_CAT_DEF_B_N3 | NORMAL | NONUNIQUE |
![]() |
![]() |
OKL_FE_CRIT_CAT_DEF_B_N4 | NORMAL | NONUNIQUE |
![]() |
![]() |
OKL_FE_CRIT_CAT_DEF_B_N5 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CRIT_CAT_DEF_ID | NUMBER | Yes | Eligibility Criteria Category Identifier | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version number tracks row updates |
ECC_AC_FLAG | VARCHAR2 | (3) | Yes | "ECC" for Eligibility Criteria Category and "AC" Adjustment Category |
CRIT_CAT_NAME | VARCHAR2 | (240) | Yes | Eligibility Criteria Category Name |
ORIG_CRIT_CAT_DEF_ID | NUMBER | It points to the ECC_ID if this category is duplicated from the existing category. | ||
VALUE_TYPE_CODE | VARCHAR2 | (30) | Yes | Lookup Type "OKL_ECC_VALUE_TYPE" |
DATA_TYPE_CODE | VARCHAR2 | (30) | Yes | Lookup Type "OKL_ECC_DATA_TYPE" |
ENABLED_YN | VARCHAR2 | (3) | Yes | Lookup Type "OKL_YES_NO" |
SEEDED_YN | VARCHAR2 | (3) | Yes | Lookup Type "OKL_YES_NO" |
FUNCTION_ID | NUMBER | Yes | Function Identifier | |
SOURCE_YN | VARCHAR2 | (3) | Yes | Lookup Type "OKL_YES_NO" |
SQL_STATEMENT | VARCHAR2 | (1995) | This sql will return the value set that the category can take. | |
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 | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT CRIT_CAT_DEF_ID
, OBJECT_VERSION_NUMBER
, ECC_AC_FLAG
, CRIT_CAT_NAME
, ORIG_CRIT_CAT_DEF_ID
, VALUE_TYPE_CODE
, DATA_TYPE_CODE
, ENABLED_YN
, SEEDED_YN
, FUNCTION_ID
, SOURCE_YN
, SQL_STATEMENT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM OKL.OKL_FE_CRIT_CAT_DEF_B;
OKL.OKL_FE_CRIT_CAT_DEF_B does not reference any database object
OKL.OKL_FE_CRIT_CAT_DEF_B is referenced by following:
|
|
|