ECC iProcurement, My Notifications, SQL1

Description
Columns: Ecc Spec Id, Notification Id, Recipient Role, Sent Date, Us From User, Us Subject, Us Notif Type ...
Imported from ECC
SELECT * FROM  ( select ECC_SPEC_ID ,
                                      NOTIFICATION_ID,
                                      FROM_USER ,
                                      SUBJECT,
                                      RECIPIENT_ROLE ,
                                      NOTIF_TYPE ,
                                      LANGUAGE,
                                      SENT_DATE from icx_my_notifs_v WHERE LANGUAGE in ( 'US') ) PIVOT(
              MAX(FROM_USER) AS FROM_USER,
              MAX(SUBJECT) AS SUBJECT,
              MAX(NOTIF_TYPE) AS NOTIF_TYPE
              FOR LANGUAGE IN ('US' "US"))