PTIASPLOGTGTVW

index back

Target Apply Log View

This view is used to show applied bugs along with their subject & product information.
SELECT LOGTGT.DBNAME ,LOGTGT.PTIASPRPTNO ,LOGTGT.PTIASPPKGAPPLYDT ,LOGTGT.PTIAIMGAPPLFRM ,HEAD.PTIASPRPTSUBJECT ,PRD.PTIASPPRDCD FROM PS_PTIASPLOGTGT LOGTGT JOIN PS_PTIASPRPTHEAD HEAD ON LOGTGT.PTIASPRPTNO=HEAD.PTIASPRPTNO LEFT JOIN PS_PTIASPPRD PRD ON HEAD.PTIASPPRDID=PRD.PTIASPPRDID WHERE LOGTGT.PTIASPRPTNO>1000 AND LOGTGT.PTIASPRPTNO<600000000

PeopleSoft Field Name Field Type Column Type Description
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
PTIASPPKGAPPLYDT Date(10) DATE Apply Date
PTIAIMGAPPLFRM Signed Number(6,0) DECIMAL(5) NOT NULL Numeric value for the image number that the bug was applied from
PTIASPRPTSUBJECT Character(240) VARCHAR2(240) NOT NULL Bug Subject
PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20