tbs_datafile_name

select distinct(name) from v$tablespace;
/
prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
prompt APPS_TS_MEDIA
prompt APPS_TS_ARCHIVE
prompt APPS_TS_INTERFACE
prompt USERS
prompt APPS_TS_SUMMARY
prompt APPS_TS_QUEUES
prompt APPS_TS_SEED
prompt APPS_TS_TX_DATA
prompt APPS_UNDOTS1
prompt SYSTEM
prompt SYSAUX
prompt APPS_TS_NOLOGGING
prompt TJTG
prompt CTXD
prompt OLAP
prompt ODM
prompt APPS_RO_DATA
prompt PORTAL
prompt cOWAPUB
prompt APPS_TS_TOOLS
prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SELECT d.NAME, t.NAME
 FROM v$datafile d, v$tablespace t
WHERE d.ts# = t.ts# AND t.NAME ='&input_tbs_name';