There are more than 20 times that my staged result got cleared from front end by some other people (I’m not telling who they are).
One good part is, if the data are not flushed in database, we can still see the result.
FROM PS_GP_PKG_ELEMENTS ELE, PS_GP_PINTYPE_VW PINTYPE, PSXLATITEM XLAT
WHERE ELE.GP_PKG_ID = '<PACKAGE_NAME>'
AND XLAT.fieldname = 'GP_PKG_FAIL_REASON'
AND ELE.PIN_TYPE = PINTYPE.PIN_TYPE
AND ELE.GP_PKG_FAIL_REASON = XLAT.FIELDVALUE;
from PS_GP_PKG_ELEMENTS ELE
where ELE.GP_PKG_ID = '<PACKAGE_NAME>';