Oracle: Select PARTITION name

Example of how to select data along with name of the partition that the data is stored in

--select the partition name that a column is stored in
select distinct
   '<TABLENAME>'     table_name,
   ao.subobject_name partition_name,
   mt.<COLUMN_NAME>  column_name
from
   all_objects ao,
   <TABLENAME> mt --my_table
where
   ao.data_object_id = DBMS_MVIEW.PMARKER(mt.rowid)