Data Archive
- Data Archive 6.5.1
- All Products
select a1.CLASSID, a1.MENUNAME, a1.BARNAME, a1.BARITEMNAME, a1.PNLITEMNAME, 1 DISPLAYONLY, a1.AUTHORIZEDACTIONS from &&ACCESSID..PSAUTHITEM a1 WHERE a1.BARITEMNAME NOT IN ('PROCESSMONITOR','QUERY_MANAGER', 'PO_INQUIRY') -- This Allows the user to click on buttons in PO Inquiry and a1.BARNAME NOT IN ('REPORT') union select a2.CLASSID, a2.MENUNAME, a2.BARNAME, a2.BARITEMNAME, a2.PNLITEMNAME, 0 DISPLAYONLY, a2.AUTHORIZEDACTIONS from &&ACCESSID..PSAUTHITEM a2 WHERE a2.BARITEMNAME IN ('PROCESSMONITOR','QUERY_MANAGER', 'PO_INQUIRY') -- This Allows the user to click on buttons in PO Inquiry and a2.BARNAME NOT IN ('REPORT')