ECC iProcurement, My Requisitions

select
x.*
from
(
SELECT * FROM  ( select ECC_SPEC_ID,
                                            REQ_HEADER_ID,
                                            REQUISITION_NUMBER,
                                            PREPARER_ID,
                                            DESCRIPTION,
                                            REQ_TOTAL,
                                            AUTH_STATUS,
                                            ECC_LAST_UPDATE_DATE,
                                            LANGUAGE,
                                            creation_date,
                                            CHANGE,
                                            copy,
                                            exp_rcv,
					    ORG_ID
                                            from icx_my_reqs_v WHERE LANGUAGE in ( 'US') ) PIVOT(
              MAX(DESCRIPTION) AS DESCRIPTION,
              MAX(REQUISITION_NUMBER) AS REQUISITION_NUMBER,
              MAX(AUTH_STATUS) AS AUTH_STATUS
              FOR LANGUAGE IN ('US' "US"))
) x
where
2=2