CN_LOOKUP_TYPES
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CN
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
VIEW_APPLICATION_ID LOOKUP_TYPE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN MEANING DESCRIPTION |
問合せ
| SQL_Statement |
|---|
|
SELECT B.VIEW_APPLICATION_ID, B.LOOKUP_TYPE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, T.MEANING, T.DESCRIPTION FROM FND_LOOKUP_TYPES_TL T, FND_LOOKUP_TYPES B WHERE B.LOOKUP_TYPE = T.LOOKUP_TYPE AND T.LANGUAGE = userenv('LANG') AND (b.lookup_type like 'CN%' OR b.lookup_type like 'ORA_CN%')AND B.VIEW_APPLICATION_ID=0 AND b.view_application_id = t.view_application_id |