SELECT "OBJ_NUM","PARTOBJ","TS_NAME","TS_NUM" FROM ku$_tts_tabview
UNION ALL
SELECT "OBJ_NUM","PARTOBJ","TS_NAME","TS_NUM" FROM ku$_tts_tabpartview
UNION ALL
SELECT "OBJ_NUM","PARTOBJ","TS_NAME","TS_NUM" FROM ku$_tts_tabsubpartview
UNION ALL
SELECT "OBJ_NUM","PARTOBJ","TS_NAME","TS_NUM" FROM ku$_tts_partlobview
UNION ALL
SELECT "OBJ_NUM","PARTOBJ","TS_NAME","TS_NUM" FROM ku$_tts_subpartlobview
SELECT "OBJ_NUM"
, "PARTOBJ"
, "TS_NAME"
, "TS_NUM"
FROM KU$_TTS_TABVIEW
UNION ALL
SELECT "OBJ_NUM"
, "PARTOBJ"
, "TS_NAME"
, "TS_NUM"
FROM KU$_TTS_TABPARTVIEW
UNION ALL
SELECT "OBJ_NUM"
, "PARTOBJ"
, "TS_NAME"
, "TS_NUM"
FROM KU$_TTS_TABSUBPARTVIEW
UNION ALL
SELECT "OBJ_NUM"
, "PARTOBJ"
, "TS_NAME"
, "TS_NUM"
FROM KU$_TTS_PARTLOBVIEW
UNION ALL
SELECT "OBJ_NUM"
, "PARTOBJ"
, "TS_NAME"
, "TS_NUM"
FROM KU$_TTS_SUBPARTLOBVIEW
|
|
|