Reg:I want to get Interface table columns

Hi OracleSupport,

I want to get Interface table columns  which are mapped to base tables by using sql query.I have tried below but it is not working.Pleaes could you correct .

select

column1,

column 2                 ----I am expecting the Basetable coumnname along with IF table mapping columns..

from S_EIM_ATTR_MAP t1,

S_TABLE t2,

S_COLUMN t3,

where

t2.ROW_ID=t3.TBL_ID --FOR GETTING TABLE HOLDING COLUMNS

and

t3.ROW_ID=T1.BTAB_ATTB_COL_ID --BASETABLE columns from IF table.

and

t3.ROW_ID=t1.IFTAB_DATA_COL_ID ; --NAMES I NEED FROM S_COLUMN TABLE (