SELECT ROWID AS REL_ID, SUBJECT_TYPE, OBJECT_TYPE, REL_TYPE_CODE, DELETED_FLAG, SEEDED_FLAG FROM CZ_TYPE_RELATIONSHIPS WHERE REL_TYPE_CODE IN ('SYS', 'JSY', 'CAP') AND DELETED_FLAG = '0'
View Text - HTML Formatted
SELECT ROWID AS REL_ID , SUBJECT_TYPE , OBJECT_TYPE , REL_TYPE_CODE , DELETED_FLAG , SEEDED_FLAG FROM CZ_TYPE_RELATIONSHIPS WHERE REL_TYPE_CODE IN ('SYS' , 'JSY' , 'CAP') AND DELETED_FLAG = '0'