Siebel Repository Tables Query

To get the column information based on View and Applet from the Repository

SELECT A.NAME, C.APPLET_NAME, E.FIELD_NAME, G.COL_NAME, H.NAME
FROM
S_VIEW A, S_VIEW_WEB_TMPL B, S_VIEW_WTMPL_IT C,
S_APPLET D, S_CONTROL E,
S_BUSCOMP F, S_FIELD G,
S_TABLE H, S_COLUMN I
WHERE
A.ROW_ID = B.VIEW_ID
AND B.ROW_ID = C.VIEW_WEB_TMPL_ID
AND A.ROW_ID = ''
AND A.REPOSITORY_ID = ''
AND D.NAME = C.APPLET_NAME
AND D.REPOSITORY_ID = ''
AND D.NAME = ''
AND D.ROW_ID = E.APPLET_ID
AND E.FIELD_NAME IS NOT NULL
AND F.NAME = D.BUSCOMP_NAME
AND F.REPOSITORY_ID = ''
AND G.BUSCOMP_ID =F.ROW_ID
AND G.JOIN_NAME IS NULL
AND E.FIELD_NAME = G.NAME
AND F.TABLE_NAME =H.NAME
AND H.REPOSITORY_ID = ''
AND I.TBL_ID =H.ROW_ID
AND I.NAME =G.COL_NAME