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

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Ecc Last Update Date, Wip Entity Id, Wip Entity Name, Organization Id, Pr Number, PO Number, Pr Description, Po Description, Supplier Purchase ...
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
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