PTLT_PRODUCT_CODEPTLT_PROD_SUITE_CDPTLT_PRS_PR_VW(SQL View) |
Index Back |
|---|---|
Solutions/Product rollup viewThis 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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTLT_PRODUCT_CODE |
Character(4) | VARCHAR2(4) NOT NULL | Unique code for a product. |
| 2 | PTLT_PROD_SUITE_CD |
Character(10) | VARCHAR2(10) NOT NULL | Unique code for solutions |
| 3 | PTLT_PRODSUITE | Character(70) | VARCHAR2(70) NOT NULL | Solutions name |