ECC Assets, Assets, SQL1

Description
Columns: 'Fa Row Id', 'Fa Context Value', 'Fa Insurance Company', 'Fa Insurance Renewal Date', 'Fa Building Size', 'Fa Area', 'Fa License Plate', 'Fa License Renewal Date', 'Fa Number Of Axles', 'Fa Cargo Size' ...
Imported from ECC
select * from ((SELECT dfv.*, trx_v.* FROM FA_ECC_F_ASSET_V trx_v  , (select 'FA_ROW_ID','FA_CONTEXT_VALUE','FA_INSURANCE_COMPANY','FA_INSURANCE_RENEWAL_DATE','FA_BUILDING_SIZE','FA_AREA','FA_LICENSE_PLATE','FA_LICENSE_RENEWAL_DATE','FA_NUMBER_OF_AXLES','FA_CARGO_SIZE','FA_CONCATENATED_SEGMENTS' from dual where 1=2  union select ROWIDTOCHAR(ROW_ID),CONTEXT_VALUE,INSURANCE_COMPANY,to_char(INSURANCE_RENEWAL_DATE, 'yyyy-mm-dd') ,to_char(BUILDING_SIZE),to_char(AREA),LICENSE_PLATE,to_char(LICENSE_RENEWAL_DATE, 'yyyy-mm-dd') ,NUMBER_OF_AXLES,to_char(CARGO_SIZE),CONCATENATED_SEGMENTS from FA_ADDITIONS_B_DFV) dfv WHERE trx_v.language in ('US')  AND trx_v.fa_rowid = dfv."'FA_ROW_ID'"(+) )
                                       PIVOT (max(CURRENCY) as CURRENCY,
                                              max(ASSET_DESCRIPTION) as ASSET_DESCRIPTION,
                                              max(PARENT_DESCRIPTION) as PARENT_DESCRIPTION,
                                              max(PROPERTY_TYPE) as PROPERTY_TYPE,
                                              max(TRANSACTION_TYPE) as TRANSACTION_TYPE,
                                              max(ASSET_TYPE) as ASSET_TYPE,
                                              MAX(YEAR_AGING_BUCKET) AS YEAR_AGING_BUCKET,
                                              MAX(MONTH_AGING_BUCKET) AS MONTH_AGING_BUCKET
                                       for LANGUAGE in ('US' "US")))