ECC Enterprise Asset Management, Work Orders (Maintenance), SQL2

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: eam-wo
Query Procedure: EAM_ECC_WO_UTIL_PVT.GET_ECC_WO_DATA_LOAD_INFO
Security Procedure: eam_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 EAM_ECC_WO_PO_PR_CONCAT  PIVOT (max(PO_ITEM_DESCRIPTION) as PO_ITEM_DESCRIPTION for
					LANGUAGE in ('US' "US"))
) x
where
2=2