query that fetch failed transaction

Summary:

SELECT *
FROM (
SELECT DISTINCT
HTCE.TRANSACTION_ID,
HTCE.PROCESS_CATEGORY,
HTCE.OBJECaT_NAME,
HTCE.CREATED_BY,
papf.PERSON_NUMBER,
ppnf.FULL_NAME,
TO_CHAR(HTCE.CREATION_DATE,'YYYY/MM/DD') AS CREATION_DATE,
TO_CHAR(HTCE.CHANGE_EFFECTIVE_DATE,'YYYY/MM/DD') AS CHANGE_EFFECTIVE_DATE,
HTCE.STATUS_CATEGORY
FROM HRC_TXN_CONSOLE_ENTRY HTCE,
FUSION.FND_CONSOLE_TRANSACTION_INFO FCTI,
FUSION.FND_CONSOLE_ISSUE FCI,
FUSION.HRC_TXN_HEADER TXNH,
PER_ALL_PEOPLE_F papf,
PER_PERSON_NAMES_F ppnf
WHERE FCTI.TRANSACTION_ID = HTCE.TRANSACTION_ID
AND FCI.CONSOLE_TRANSACTION_ID = FCTI.CONSOLE_TRANSACTION_ID

  -- Correct join to get person