PTIASPINSTPRDVW

index back

Installed Products List


SELECT A.DBNAME , A.PTIASPPRDGRPCD , A.PTIASPPRDCD , A.PTIASPINSTALLTBL , B.PTIASPPRDID , B.PTIASPPRDNAME , 'N' FROM PS_PTIASPSRCINFO C , PS_PTIASPINSTPRD A , PS_PTIASPPRD B WHERE B.PTIASPPRDCD = A.PTIASPPRDCD AND B.PTIASPPRDGRPCD = A.PTIASPPRDGRPCD AND B.PTIASPLICGRP = C.PTIASPLICGRP AND B.PTIASPLOCALIZATN = C.PTIASPLOCALIZATN

PeopleSoft Field NameField TypeColumn TypeDescription
DBNAMECharacter(8)VARCHAR2(8) NOT NULLDatabase Name
PTIASPPRDGRPCDCharacter(12)VARCHAR2(12) NOT NULLProduct Group
PTIASPPRDCDCharacter(8)VARCHAR2(8) NOT NULLProduct
PTIASPINSTALLTBLCharacter(30)VARCHAR2(30) NOT NULLColumn name on PS_INSTALLATION
PTIASPPRDIDNumber(8,0)INTEGER NOT NULLProduct ID
PTIASPPRDNAMECharacter(240)VARCHAR2(240) NOT NULLProduct Name
PTIASPSELECTPRODCharacter(1)VARCHAR2(1) NOT NULLSelect by Product flag

Default: N

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19