HZ_CLASS_CATEGORY_CODES_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: HZ
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
CLASS_CATEGORY CLASS_CODE VIEW_APPLICATION_ID MEANING DESCRIPTION START_DATE_ACTIVE END_DATE_ACTIVE LAST_UPDATED_BY |
問合せ
| SQL_Statement |
|---|
|
SELECT CC.CLASS_CATEGORY, LV.LOOKUP_CODE AS CLASS_CODE, LV.VIEW_APPLICATION_ID, LV.MEANING, LV.DESCRIPTION, LV.START_DATE_ACTIVE, LV.END_DATE_ACTIVE, LV.LAST_UPDATED_BY FROM HZ_CLASS_CATEGORIES CC, FND_LOOKUP_VALUES LV WHERE CC.CLASS_CATEGORY = LV.LOOKUP_TYPE AND CC.LKUP_TYPE_OWNER_ID = LV.VIEW_APPLICATION_ID AND LV.LANGUAGE = userenv('LANG') AND LV.ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN trunc(nvl(LV.START_DATE_ACTIVE, SYSDATE)) AND trunc(nvl(LV.END_DATE_ACTIVE, TO_DATE('4712-12-31','YYYY-MM-DD'))) AND LV.SET_ID = 0 AND CC.STATUS_FLAG = 'A' |