PK_PANEL_VW(SQL View) |
Index Back |
---|---|
Packaging - Product Licensing |
SELECT DISTINCT %Substring(pnlname,1,18) , objectownerid FROM PSPNLDEFN A WHERE NOT EXISTS ( SELECT 'x' FROM psprojectitem WHERE objectvalue1 = A.pnlname AND objecttype = 5 AND projectname ='PPLTOOLS') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PK_OBJECTNAME | Character(18) | VARCHAR2(18) NOT NULL | Object Name |
2 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |