I have a sql query that returns this information.
SELECT
SUBSTR(DSE_FOLDERS.COMPLETE_PATH, 6) AS FOLDER,
OH.OH_NAME AS PROCESS_FLOW,
JPP_OTYPE AS OBJECT_TYPE,
JPP_OBJECT AS JOB_NAME,
'(Row:'||JPP_ROW||' Column:'||JPP_COL||')' AS JOB_POSITION
FROM
OFS
JOIN
OH
ON
OH.OH_IDNR = OFS.OFS_OH_IDNR_O
JOIN
(
SELECT
OH_IDNR AS OBJECT_ID,
OH_NAME AS OBJECT_NAME,
SUBSTR(OH_NAME, INSTR(OH_NAME, 'k\')+2, LENGTH(OH_NAME) ) "TRIMMED_NAME",
CONNECT_BY_ROOT SUBSTR(OH_NAME, INSTR(OH_NAME, 'k\')+2, LENGTH(OH_NAME) ) "Up",
LEVEL-1 "Pathlen",
SYS_CONNECT_BY_PATH(SUBSTR(OH_NAME, INSTR(OH_NAME, 'k\')+2, LENGTH(OH_NAME) ),'/') "COMPLETE_PATH"
FROM
OH
START WITH OH_IDNR = 1072001
CONNECT BY PRIOR OH_IDNR = SUBSTR(OH_NAME, 0, INSTR(OH_NAME, 'k\')-1)
) DSE_FOLDERS
ON
OFS.OFS_OH_IDNR_F = DSE_FOLDERS.OBJECT_ID
JOIN
JPP
ON
JPP.JPP_OH_IDNR = OH.OH_IDNR
LEFT JOIN
OH JOB_NM
ON
JOB_NM.OH_NAME = JPP.JPP_OBJECT
JOIN
(SELECT DISTINCT AH_OH_IDNR FROM AH_V WHERE AH_ACTIVETIME > CURRENT_DATE - 30) ACTIVE
ON
ACTIVE.AH_OH_IDNR = OH.OH_IDNR
WHERE
OFS.OFS_LEVEL = 0
AND
OH.OH_OTYPE = 'JOBP'
AND
COALESCE(JPP.JPP_OTYPE,'<EMPTY>') NOT IN ('<START>','<END>','<FE>','<IF>')
AND
JOB_NM.OH_IDNR IS NULL
AND
(
OH.OH_NAME NOT LIKE '%DEPRECATED%'
OR
OH.OH_NAME NOT LIKE 'XX%'
OR
DSE_FOLDERS.COMPLETE_PATH NOT LIKE '%DEPRECATED%'
OR
DSE_FOLDERS.COMPLETE_PATH NOT LIKE '%TO_DELETE%'
)
ORDER BY SUBSTR(DSE_FOLDERS.COMPLETE_PATH, 6), OH.OH_NAME