ECC Contract Lifecycle Management, Requisitions, SQL13

select
x.*
from
(
SELECT gt.char1 ecc_spec_id, prl.requisition_line_id ,
                                       CASE WHEN EXT.FSC_PSC_DISP IS NULL THEN 'NA'
                                        ELSE ext.FSC_PSC_DISP
                                        END FSC_PSC FROM PO_SESSION_GT gt,
                                       ECC_REQ_LINE_FED_CUST_DESG_AGV EXT , po_requisition_lines_all prl
                                       WHERE
                                       prl.requisition_line_id = ext.requisition_line_id (+)
                                       and prl.requisition_line_id = gt.index_num2
                                       AND gt.KEY =3218981
) x
where
2=2