ECC Assets, Mass Transactions

Description
Categories: Enterprise Command Center
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 Enterprise Command Center
Dataset Key: fa-masstrans
Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
select
x.*
from
(
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")))
) x
where
2=2