Select procedure/Macro with the latest compiled date/timestamp 1

[DFW1999]

I need to know how I can select all the procedure/Macro objects from the teradata with the timestamp when these objects were last compiled/created.
In this way I can see which are the latest objects with version and time.

Thanks

 

[dnoeth]

select
databasename
,tablename
,tablekind
,createtimestamp
,lastaltertimestamp
from dbc.tables
where tablekind in ('P','M');

Dieter