PTIASPPKGDUPVW

index back

Duplicate Package View

This view displays the package names which include non-applied BUG in the creating package.
SELECT DISTINCT A.PTIASPPKGNAME , A.PTIASPPKGGUID , A.USERID , B.LASTUPDDTTM FROM PS_PTIASPPKGBUGS A , PS_PTIASPPKGS B WHERE A.PTIASPPKGGUID = B.PTIASPPKGGUID

PeopleSoft Field NameField TypeColumn TypeDescription
PTIASPPKGGUIDCharacter(36)VARCHAR2(36) NOT NULLUnique Identifier
PTIASPPKGNAMECharacter(30)VARCHAR2(30) NOT NULLPackage Name
USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19