ECC Property Manager, Lease Expenses

select
x.*
from
(
SELECT * FROM
(
SELECT
ACCOUNTING_METHOD,
AMOUNT,
ECC_SPEC_ID,
pn_ecc_util_pvt.get_lookup_values('PN_YES_NO', EXEMPT_YN, language) EXEMPT_YN,
EXPENSE_PURPOSE,
ITEM_CATEGORY,
LANGUAGE,
LEASE_CLASS,
LEASE_ID,
LEASE_NUM,
LIFE_MONTHS,
ORG_ID,
PAYMENT_TERM_ID,
PERIOD_START_DATE,
PRIMARY_REGIME,
REGIME_CODE,
STREAM_DATE,
STREAM_TYPE_CODE,
TRANSACTED_FLAG,
to_char(stream_date,'YYYY-MM') rep_period,
to_char(stream_date,'YYYY-MM') month,
PROCESSING_STATUS_FLAG
from  PN_ECC_LEASE_EXPENSE_V where language in ('US')
) PIVOT (MAX(ACCOUNTING_METHOD) AS ACCOUNTING_METHOD,
         MAX(EXEMPT_YN) AS EXEMPT_YN,
         MAX(EXPENSE_PURPOSE) AS EXPENSE_PURPOSE,
         MAX(LEASE_CLASS) AS LEASE_CLASS
FOR LANGUAGE in  ('US' "US"))
) x
where
2=2