POR_BROWSE_CATEGORIES_VL

Details

• Schema: FUSION

• Object owner: POR

• Object type: VIEW

Columns

Name
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

Query

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')