Please feel free to comment if there are any errors in the blog. Iam creating this blog for my reference and also to share my understanding of peoplesoft.
Search This Blog
Thursday, March 31, 2016
SQL to find the Bundle applied on the current version.
SELECT A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG FROM PS_MAINTENANCE_LOG A WHERE upper(A.DESCRLONG) like '%BUNDLE%' ORDER BY 2 DESC;