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
Dataset Key: fa-masstrans
Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |