PTIASPPRDFMLYVW

index back

List of Product Famly

This view gives a list of product families for the licence group
SELECT DISTINCT PTIASPPRDFMLY , PTIASPPRDFMLYDESC , 'N' FROM PS_PTIASPPRDFMLY A , PS_PTIASPSRCINFO B WHERE 1=1 AND A.PTIASPLICGRP = B.PTIASPLICGRP

PeopleSoft Field NameField TypeColumn TypeDescription
PTIASPPRDFMLYCharacter(5)VARCHAR2(5) NOT NULLProduct Family
PTIASPPRDFMLYDESCCharacter(254)VARCHAR2(254) NOT NULLDescription for Product Family
PTIASPSELECTPRDFMLCharacter(1)VARCHAR2(1) NOT NULLProduct Family flag

Default: N

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