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 Name Field Type Column Type Description
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
PTIASPPRDGRPCD Character(12) VARCHAR2(12) NOT NULL Product Group
PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product
PTIASPINSTALLTBL Character(30) VARCHAR2(30) NOT NULL Column name on PS_INSTALLATION
PTIASPPRDID Number(8,0) INTEGER NOT NULL Product ID
PTIASPPRDNAME Character(240) VARCHAR2(240) NOT NULL Product Name
PTIASPSELECTPROD Character(1) VARCHAR2(1) NOT NULL Select by Product flag

Default: N

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