What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery?

Queries SYS.TS_PITR_CHECK for the tablespaces in the recovery set, as shown in Example 20-1. If the query returns rows, then RMAN does not proceed with the TSPITR.
SELECT *
FROM SYS.TS_PITR_CHECK
WHERE (
TS1_NAME IN (‘USERS’,’TOOLS’)
AND TS2_NAME NOT IN (‘USERS’,’TOOLS’)
)
OR (
TS1_NAME NOT IN (‘USERS’,’TOOLS’)
AND TS2_NAME IN (‘USERS’,’TOOLS’)
);