DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_FE_CRIT_CAT_DEF_V

Object Details
Object Name: OKL_FE_CRIT_CAT_DEF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_FE_CRIT_CAT_DEF_V
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


MLS view over base tables - OKL_FE_CRIT_CAT_DEF_B and OKL_FE_CRIT_CAT_DEF_TL


[View Source]

Columns
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
ORIG_CRIT_CAT_DEF_ID NUMBER

It points to the ECC_ID if this category is duplicated from the existing category.
CRIT_CAT_NAME VARCHAR2 (240) Yes Eligibility Criteria Category Name
CRIT_CAT_DESC VARCHAR2 (1995)
Eligibility Criteria Category Description
SFWT_FLAG VARCHAR2 (3) Yes Column used by the translation program
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CRIT_CAT_DEF_ID
,      OBJECT_VERSION_NUMBER
,      ECC_AC_FLAG
,      ORIG_CRIT_CAT_DEF_ID
,      CRIT_CAT_NAME
,      CRIT_CAT_DESC
,      SFWT_FLAG
,      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
FROM APPS.OKL_FE_CRIT_CAT_DEF_V;

Dependencies

[top of page]

APPS.OKL_FE_CRIT_CAT_DEF_V references the following:

SchemaAPPS
SynonymOKL_FE_CRIT_CAT_DEF_B
SynonymOKL_FE_CRIT_CAT_DEF_TL
APPS.OKL_FE_CRIT_CAT_DEF_V is referenced by following:

SchemaAPPS
Package BodyOKL_ECC_DEF_PVT - show dependent code
PL/SQL PackageOKL_ECC_PVT - show dependent code
Package BodyOKL_ECC_PVT - show dependent code
Package BodyOKL_ECC_VALUES_PVT - show dependent code
Package BodyOKL_ECL_PVT - show dependent code
Package BodyOKL_ECO_PVT - show dependent code
Package BodyOKL_EC_EVALUATE_PVT - show dependent code
Package BodyOKL_FE_ADJ_MATRIX_PVT - show dependent code
Package BodyOKL_FE_STD_RATE_TMPL_PVT - show dependent code
Package BodyOKL_PA_DATA_INTEGRITY - show dependent code