1
SELECT trl.ad_language,
2
t.ad_tab_id,
3
t.ad_window_id,
4
t.ad_table_id,
5
trl.name,
6
trl.description,
7
trl.help,
8
t.seqno,
9
t.issinglerow,
10
t.hastree,
11
t.isinfotab,
12
tbl.replicationtype,
13
tbl.tablename,
14
tbl.accesslevel,
15
tbl.issecurityenabled,
16
tbl.isdeleteable,
17
COALESCE(t.ishighvolume, tbl.ishighvolume) AS ishighvolume,
18
tbl.isview,
19
'N'::character(1) AS hasassociation,
20
t.istranslationtab,
21
t.isreadonly,
22
t.ad_image_id,
23
t.tablevel,
24
t.whereclause,
25
t.orderbyclause,
26
trl.commitwarning,
27
t.readonlylogic,
28
t.displaylogic,
29
t.ad_column_id,
30
t.ad_process_id,
31
t.issorttab,
32
t.isinsertrecord,
33
t.isadvancedtab,
34
t.ad_columnsortorder_id,
35
t.ad_columnsortyesno_id,
36
t.included_tab_id,
37
t.parent_column_id,
38
t.ad_tab_uu,
39
tbl.ad_table_uu,
40
t.treedisplayedon,
41
t.maxqueryrecords,
42
t.isallowadvancedlookup,
43
t.islookuponlyselection,
44
t.ad_tabtype,
45
t.entitytype,
46
t.cof_alwaysinsert
47
FROM ((ad_tab t
48
JOIN ad_table tbl ON ((t.ad_table_id = tbl.ad_table_id)))
49
JOIN ad_tab_trl trl ON ((t.ad_tab_id = trl.ad_tab_id)))
50
WHERE ((t.isactive = 'Y'::bpchar) AND (tbl.isactive = 'Y'::bpchar));