POR_CATALOGS_ALL_VL

Details

• Schema: FUSION

• Object owner: POR

• Object type: VIEW

Columns

Name
CATALOG_ID PRC_BU_ID CATALOG_TYPE BROWSING_CATEGORY_ID_LIST CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CATALOG_NAME CATALOG_DESCRIPTION KEYWORDS

Query

SQL_Statement

SELECT POR_CATALOGS_ALL_B.CATALOG_ID CATALOG_ID, POR_CATALOGS_ALL_B.PRC_BU_ID PRC_BU_ID, POR_CATALOGS_ALL_B.CATALOG_TYPE CATALOG_TYPE, POR_CATALOGS_ALL_B.BROWSING_CATEGORY_ID_LIST BROWSING_CATEGORY_ID_LIST, POR_CATALOGS_ALL_B.CREATED_BY CREATED_BY, POR_CATALOGS_ALL_B.CREATION_DATE CREATION_DATE, POR_CATALOGS_ALL_B.LAST_UPDATED_BY LAST_UPDATED_BY, POR_CATALOGS_ALL_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, POR_CATALOGS_ALL_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, POR_CATALOGS_ALL_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, POR_CATALOGS_ALL_TL.CATALOG_NAME CATALOG_NAME, POR_CATALOGS_ALL_TL.CATALOG_DESCRIPTION CATALOG_DESCRIPTION, POR_CATALOGS_ALL_TL.KEYWORDS KEYWORDS FROM POR_CATALOGS_ALL_B, POR_CATALOGS_ALL_TL WHERE POR_CATALOGS_ALL_B.CATALOG_ID=POR_CATALOGS_ALL_TL.CATALOG_ID AND POR_CATALOGS_ALL_TL.LANGUAGE=USERENV('LANG')