CSO_CONTENT_TEXT_CAT

Details

Schema: FUSION
Object owner: CSO
Object type: VIEW

Columns

Name
CONTENT_TEXT_ID CATEGORY_ID

Name

CONTENT_TEXT_ID

CATEGORY_ID

Query

SQL_Statement
SELECT CONTENT_TEXT_ID, CATEGORY_ID FROM CSO_CONTENT_TEXT_CAT UNION SELECT ctc.CONTENT_TEXT_ID, t.EXTERNAL_ID as CATEGORY_ID from CSO_CONTENT_TEXT_CATEGORY ctc, CSO_TAG t WHERE t.RECORD_ID = ctc.TAG_ID AND t.EXTERNAL_TYPE = 'CATEGORY'

SQL_Statement

SELECT CONTENT_TEXT_ID, CATEGORY_ID FROM CSO_CONTENT_TEXT_CAT

UNION

SELECT ctc.CONTENT_TEXT_ID, t.EXTERNAL_ID as CATEGORY_ID from CSO_CONTENT_TEXT_CATEGORY ctc, CSO_TAG t WHERE t.RECORD_ID = ctc.TAG_ID AND t.EXTERNAL_TYPE = 'CATEGORY'