[Home] [Help]
View: AS_INTEREST_CATEGORY_SETS_V
View Text
SELECT INTCAT.ROWID
, INTCAT.CATEGORY_SET_ID
, INTCAT.LAST_UPDATE_DATE
, INTCAT.LAST_UPDATED_BY
, INTCAT.CREATION_DATE
, INTCAT.CREATED_BY
, INTCAT.LAST_UPDATE_LOGIN
, INTCAT.INTEREST_TYPE_ID
, INTTYPE.INTEREST_TYPE
, MTLSET.CATEGORY_SET_NAME
, MTLSET.DESCRIPTION
, INTCAT.ENABLED_FLAG
FROM AS_INTEREST_CATEGORY_SETS INTCAT
, MTL_CATEGORY_SETS_VL MTLSET
, AS_INTEREST_TYPES_VL INTTYPE
WHERE INTCAT.CATEGORY_SET_ID = MTLSET.CATEGORY_SET_ID
AND INTCAT.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID
Columns
Name |
ROW_ID |
CATEGORY_SET_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
INTEREST_TYPE_ID |
INTEREST_TYPE |
CATEGORY_SET_NAME |
DESCRIPTION |
ENABLED_FLAG |