How to find tables that have a PPI

In teradata we use lot of data dictionary tables (dbc)  to find definition/details about anything related to data.

How to find the tables which have PPI(partitioned primary index) ?
We make use of DBC.indices view to find any details regrading index.

Query :

SEL * FROM dbc.indices

WHERE indextype = 'Q'          ---- 'Q' means Partitioned Primary Index

AND databasename = 'DATABASENAME' ;

Infact , DBC.Indices can be used to find out various types of index associated with tables in a given database.