ECC iProcurement, My Notifications

➜ Back to Library
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
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
Download
 
Related Blitz Reports
HXT Time Entry Detail ASO Quote Data Template OKC Contract Header Preview Data Definition ECC Procurement, Requisitions AP Prepayment Balance Report - Functional Currency (CZech) AP Prepayment Balance Report - Entered Currency (CZech) AP Prepayment Balance AP Advances in Selected Currency ECC iProcurement, iProcurement Top Categories, SQL2
Blitz Report™

Blitz Report™ provides multiple benefits: