eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKL_FE_CRIT_CAT_DEF_V

Product:	OKL - Lease and Finance Management
Description:	Criteria Categories View
Implementation/DBA Data:	APPS.OKL_FE_CRIT_CAT_DEF_V

View Text

SELECT ECCB.CRIT_CAT_DEF_ID
, ECCB.OBJECT_VERSION_NUMBER
, ECCB.ECC_AC_FLAG
, ECCB.ORIG_CRIT_CAT_DEF_ID
, ECCB.CRIT_CAT_NAME
, ECCT.CRIT_CAT_DESC
, ECCT.SFWT_FLAG
, ECCB.VALUE_TYPE_CODE
, ECCB.DATA_TYPE_CODE
, ECCB.ENABLED_YN
, ECCB.SEEDED_YN
, ECCB.FUNCTION_ID
, ECCB.SOURCE_YN
, ECCB.SQL_STATEMENT
, ECCB.CREATED_BY
, ECCB.CREATION_DATE
, ECCB.LAST_UPDATED_BY
, ECCB.LAST_UPDATE_DATE
, ECCB.LAST_UPDATE_LOGIN
FROM OKL_FE_CRIT_CAT_DEF_TL ECCT
, OKL_FE_CRIT_CAT_DEF_B ECCB
WHERE ECCB.CRIT_CAT_DEF_ID=ECCT.CRIT_CAT_DEF_ID
AND ECCT.LANGUAGE=USERENV('LANG')

Columns

Name
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