PORTAL_NAMEPORTAL_OBJNAMEPTBR_CUSTAB_PVW(SQL View) |
Index Back |
|---|---|
Custom Tabs Collection Prompt |
| SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , A.PORTAL_LABEL FROM %Table(PSPRSMDEFN) A WHERE A.PORTAL_REFTYPE = 'F' AND A.PORTAL_PRNTOBJNAME = 'CO_NAVIGATION_COLLECTIONS' AND A.PORTAL_OBJNAME NOT IN ('PT_PTPP_PORTAL_ROOT') AND EXISTS ( SELECT 1 FROM %Table(PSPRSMDEFN) C WHERE C.PORTAL_NAME = A.PORTAL_NAME AND C.PORTAL_REFTYPE = 'C' AND C.PORTAL_PRNTOBJNAME = A.PORTAL_OBJNAME ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PORTAL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 2 | PORTAL_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Custom Tabs Collection Name |
| 3 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Label |