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 Name Field Type Column Type Description
PTIASPPRDFMLY Character(5) VARCHAR2(5) NOT NULL Product Family
PTIASPPRDFMLYDESC Character(254) VARCHAR2(254) NOT NULL Description for Product Family
PTIASPSELECTPRDFML Character(1) VARCHAR2(1) NOT NULL Product Family flag

Default: N

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20