Product: | OKL - Lease and Finance Management |
---|---|
Description: | Criteria Categories View |
Implementation/DBA Data: | APPS.OKL_FE_CRIT_CAT_DEF_V |
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')