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 NameField TypeColumn TypeDescription
PTLT_PRODUCT_CODECharacter(4)VARCHAR2(4) NOT NULLUnique code for a product.
PTLT_PROD_SUITE_CDCharacter(10)VARCHAR2(10) NOT NULLUnique code for solutions
PTLT_PRODSUITECharacter(70)VARCHAR2(70) NOT NULLSolutions name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19