ODI METADATA QUERY TO GET THE LIST OF INTERFACES FOLDER WISE(ODI-10G)

--WORKS WITH ODI-10G
select
spj.project_name PROjECT_NAME,
SF.FOLDER_NAME FOLDERNAME,
sp.pop_name interface_name,
sst.lschema_name,
sst.table_name "source table",
stt.table_name "target table"
from snp_pop sp,snp_folder sf,snp_project spj,snp_source_tab sst,snp_table stt
where 1=1
and sf.i_folder=sp.i_folder
and sf.i_project=spj.i_project
and sst.i_pop=sp.i_pop
and stt.i_table=sp.i_table
--and spj.project_name='RISO_CRM_PROJECT'--PROJECT NAME
--AND sp.pop_name='RISO_SC_HEADER_DIM_INT'; --INTERFACE NAME
and stt.table_name=upper('riso_ra_cust_trx_all');--TARGET TABLE