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