ECC Assets, Mass Transactions

Description
Categories: Enterprise Command Center
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
Run ECC Assets, Mass Transactions and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™