ECC Property Manager, Projection Data Set, SQL1

Description
Columns: Amount, Ecc Spec Id, Lease Id, Lease Type, Org Id, Payment Term Id, Proj Date, Rep Period, Regime Code, Year ...
Imported from ECC
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"))