ECC Property Manager, Projection Data Set

select
x.*
from
(
SELECT * FROM
(SELECT
ACCOUNTING_METHOD,
AMOUNT,
ECC_SPEC_ID,
LANGUAGE,
LEASE_ID,
LEASE_TYPE,
ORG_ID,
PAYMENT_TERM_ID,
PROJ_DATE,
TO_CHAR(PROJ_DATE,'YYYY-MM') REP_PERIOD,
REGIME_CODE,
STREAM_TYPE_CODE,
YEAR,
PROCESSING_STATUS_FLAG
FROM
PN_ECC_PROJECTION_V where language in ('US')
) PIVOT (MAX(ACCOUNTING_METHOD) AS ACCOUNTING_METHOD,
         MAX(STREAM_TYPE_CODE) AS STREAM_TYPE_CODE
FOR LANGUAGE in  ('US' "US"))
) x
where
2=2