VIEW: SYS.KU$_QTRANS_VIEW

Source

View Text - Preformatted

select '1','0',
          t.transformation_id,
          u.name, t.name,
          (select value (f) from ku$_schemaobj_view f where f.oid=t.from_toid),
          (select value (o) from ku$_schemaobj_view o where o.oid=t.to_toid),
          at.attribute_number,
          TO_CLOB(replace(at.sql_expression, '''', ''''''))
  from sys.user$ u , transformations$ t, attribute_transformations$ at
  where  u.name = t.owner and t.transformation_id = at.transformation_id

View Text - HTML Formatted

SELECT '1'
, '0'
, T.TRANSFORMATION_ID
, U.NAME
, T.NAME
, (SELECT VALUE (F)
FROM KU$_SCHEMAOBJ_VIEW F
WHERE F.OID=T.FROM_TOID)
, (SELECT VALUE (O)
FROM KU$_SCHEMAOBJ_VIEW O
WHERE O.OID=T.TO_TOID)
, AT.ATTRIBUTE_NUMBER
, TO_CLOB(REPLACE(AT.SQL_EXPRESSION
, ''''
, ''''''))
FROM SYS.USER$ U
, TRANSFORMATIONS$ T
, ATTRIBUTE_TRANSFORMATIONS$ AT
WHERE U.NAME = T.OWNER
AND T.TRANSFORMATION_ID = AT.TRANSFORMATION_ID