ECSF_SEARCH_INDEX_OBJECT_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ECSF
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID NAME SEI_ID IS_ID BO_NAME VERSION TITLE BODY APPLICATION LAST_CRAWL_TIME IS_DEPLOYED IS_ACTIVE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MODULE_ID DEPLOYED_DATE BODY_FULL KEYWORDS DEF_ACTION_TITLE ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 DISPLAY_NAME |
問合せ
| SQL_Statement |
|---|
|
SELECT B.ID, B.NAME, B.SEI_ID, B.IS_ID, B.BO_NAME, B.VERSION, B.TITLE, B.BODY, B.APPLICATION, B.LAST_CRAWL_TIME, B.IS_DEPLOYED, B.IS_ACTIVE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.MODULE_ID, B.DEPLOYED_DATE, B.BODY_FULL, B.KEYWORDS, B.DEF_ACTION_TITLE, B.ATTRIBUTE_CHAR1, B.ATTRIBUTE_CHAR2, B.ATTRIBUTE_CHAR3, B.ATTRIBUTE_CHAR4, B.ATTRIBUTE_CHAR5, B.ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5, B.ATTRIBUTE_TIMESTAMP1, B.ATTRIBUTE_TIMESTAMP2, B.ATTRIBUTE_TIMESTAMP3, B.ATTRIBUTE_TIMESTAMP4, B.ATTRIBUTE_TIMESTAMP5, B.ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5, T.DISPLAY_NAME FROM ECSF_SEARCH_INDEX_OBJECT B, ECSF_SEARCH_INDEX_OBJECT_TL T WHERE B.ID = T.ID(+) AND T.LANGUAGE(+) = USERENV('LANG') |