ECC iProcurement, My Notifications
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: icx-my-notifs
Query Procedure: ICX_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: icx_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Dataset Key: icx-my-notifs
Query Procedure: ICX_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: icx_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run
ECC iProcurement, My Notifications and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( 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(NOTIF_TYPE) AS NOTIF_TYPE FOR LANGUAGE IN ('US' "US")) ) x where 2=2 |