PTLT_PRS_PR_VW

 index back

Solutions/Product rollup view

This view allows the page to show cross sections of where else a product is used (the "Product used in" Grid)
SELECT A.PTLT_PRODUCT_CODE , A.PTLT_PROD_SUITE_CD , B.PTLT_PRODSUITE FROM %Table(PTLT_ASSGN_PROD) A , %Table(PTLT_PROD_SUITE) B WHERE A.PTLT_PROD_SUITE_CD = B.PTLT_PROD_SUITE_CD

PeopleSoft Field Name Field Type Column Type Description
PTLT_PRODUCT_CODE Character(4) VARCHAR2(4) NOT NULL Unique code for a product.
PTLT_PROD_SUITE_CD Character(10) VARCHAR2(10) NOT NULL Unique code for solutions
PTLT_PRODSUITE Character(70) VARCHAR2(70) NOT NULL Solutions name
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20