FND_SETID_LOOKUP_TYPES
詳細
-
スキーマ: LOOKUPS
-
オブジェクト所有者: FND
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
LOOKUP_TYPE REFERENCE_GROUP_NAME MEANING DESCRIPTION CUSTOMIZATION_LEVEL CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN MODULE_ID CHANGE_SINCE_LAST_REFRESH |
問合せ
| SQL_Statement |
|---|
|
SELECT B.LOOKUP_TYPE, B.REFERENCE_GROUP_NAME, T.MEANING, T.DESCRIPTION, B.CUSTOMIZATION_LEVEL, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.MODULE_ID, B.CHANGE_SINCE_LAST_REFRESH FROM FND_LOOKUP_TYPES_TL T, FND_LOOKUP_TYPES B WHERE B.LOOKUP_TYPE = T.LOOKUP_TYPE AND T.LANGUAGE = USERENV('LANG') AND B.VIEW_APPLICATION_ID = 2 AND T.VIEW_APPLICATION_ID = 2 |