POR_BROWSE_CATEGORIES_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: POR
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
CATEGORY_ID CATEGORY_NAME CATEGORY_DESCRIPTION IMAGE_URL TYPE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
問合せ
| SQL_Statement |
|---|
|
SELECT POR_BROWSE_CATEGORIES_B.CATEGORY_ID, POR_BROWSE_CATEGORIES_TL.CATEGORY_NAME, POR_BROWSE_CATEGORIES_TL.CATEGORY_DESCRIPTION, POR_BROWSE_CATEGORIES_B.IMAGE_URL, POR_BROWSE_CATEGORIES_B.TYPE, POR_BROWSE_CATEGORIES_B.OBJECT_VERSION_NUMBER, POR_BROWSE_CATEGORIES_B.CREATED_BY, POR_BROWSE_CATEGORIES_B.CREATION_DATE, POR_BROWSE_CATEGORIES_B.LAST_UPDATED_BY, POR_BROWSE_CATEGORIES_B.LAST_UPDATE_DATE, POR_BROWSE_CATEGORIES_B.LAST_UPDATE_LOGIN FROM POR_BROWSE_CATEGORIES_B, POR_BROWSE_CATEGORIES_TL WHERE POR_BROWSE_CATEGORIES_B.CATEGORY_ID = POR_BROWSE_CATEGORIES_TL.CATEGORY_ID AND POR_BROWSE_CATEGORIES_TL.LANGUAGE = USERENV('LANG') |