ECC Assets, Mass Transactions, SQL1

Description
Columns: Record Type, Ecc Spec Id, Ecc Last Update Date, Request Num, Trans Num, Org Id, Book Code, Book Name, Trans Date, Major Category ...
Imported from ECC
select * from ((SELECT * FROM FA_ECC_F_MASS_TRANS_V where language in ('US') )
                                       PIVOT (max(TRANS_STATUS) as TRANS_STATUS,
                                              max(TRANSFER_TYPE) as TRANSFER_TYPE,
                                              max(CHANGE_TYPE) as CHANGE_TYPE
                                       for LANGUAGE in ('US' "US")))