PTIASPMAXSTEPVW

index back

Max Step Versions

This view derives the maximum step versions for all steps being applied for a group of BUGS
SELECT PKG.PTIASPPKGGUID ,PKG.DBNAME ,PKG.PTIASPPKGNAME ,TMPLTSTEP.PTIACPCHPTRID ,TMPLTSTEP.PTIACPTASKID ,TMPLTSTEP.PTIACPSTEPID ,MAX(TMPLTSTEP.PTIACPSTEPRANK) ,MAX(TMPLTSTEP.PTIACPTMPLTDTTM) FROM PS_PTIASPPKGS PKG , PS_PTIASPPKGCALC CALC , PS_PTIASPRPTHEAD RPT , PS_PTIACPTMPLTDEFN TMPLT , PS_PTIACPTMPLTSTEP TMPLTSTEP WHERE 1=1 AND PKG.PTIASPPKGGUID = CALC.PTIASPPKGGUID AND CALC.PTIASPRPTNO = RPT.PTIASPRPTNO AND CALC.PTIASPRPTNOAPLD <> 'Y' AND (CALC.PTIASPTLSIMPCTFLG = ' ' OR CALC.PTIASPTLSIMPCTFLG = 'N') AND CALC.PTIASPRPTNO = TMPLT.PTIASPRPTNO AND TMPLT.PTIACPTMPLT = TMPLTSTEP.PTIACPTMPLT GROUP BY PKG.PTIASPPKGGUID, PKG.DBNAME, PKG.PTIASPPKGNAME ,TMPLTSTEP.PTIACPCHPTRID ,TMPLTSTEP.PTIACPTASKID ,TMPLTSTEP.PTIACPSTEPID

PeopleSoft Field NameField TypeColumn TypeDescription
PTIASPPKGGUIDCharacter(36)VARCHAR2(36) NOT NULLUnique Identifier
DBNAMECharacter(8)VARCHAR2(8) NOT NULLDatabase Name
PTIASPPKGNAMECharacter(30)VARCHAR2(30) NOT NULLPackage Name
PTIACPCHPTRIDCharacter(10)VARCHAR2(10) NOT NULLChapter ID
PTIACPTASKIDCharacter(10)VARCHAR2(10) NOT NULLTask ID
PTIACPSTEPIDCharacter(10)VARCHAR2(10) NOT NULLStep ID
PTIACPSTEPRANKNumber(5,0)INTEGER NOT NULLStep Version
PTIASPRPTFIXDTDateTime(26)TIMESTAMPDate this Bug was Fixed
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19