Query Results

To fetch selected candidates for the most recent Oracle Text batch run, use the following ER Schema:

SELECT * FROM FCC_MR_SELECTED_CANDIDATES

WHERE N_RUN_SKEY IN (

SELECT MAX(N_RUN_SKEY) AS N_RUN_SKEY

FROM FCC_M_PIPELINE_BATCH_RUN

);