Folder SQL

This shows the SQL code behind the Folder.

SELECT
1 SEQ,
OBJ.OBJ_OBJECT_SQL1 ||
OBJ.OBJ_OBJECT_SQL2 ||
OBJ.OBJ_OBJECT_SQL3 SQL_CODE
FROM
EUL5_OBJS OBJ
WHERE 1=1
and OBJ.OBJ_TYPE like '%' /*value*/
AND OBJ_OBJECT_SQL1 IS NOT NULL
and obj.obj_id = 101322
UNION
SELECT
SEG.SEG_SEQUENCE SEQ,
SEG.SEG_CHUNK1 ||
SEG.SEG_CHUNK2 ||
SEG.SEG_CHUNK3 ||
SEG.SEG_CHUNK4 SQL_CODE
FROM
EUL5_SEGMENTS SEG,
EUL5_OBJS OBJ
WHERE 1=1
and OBJ.OBJ_TYPE like '%' /*value*/
AND OBJ_OBJECT_SQL1 IS NULL
AND SEG.SEG_OBJ_ID = OBJ.OBJ_ID
AND SEG.SEG_SEG_TYPE = 1
and obj.obj_id= 101322
ORDER BY 1