PK_OBJID_VW

(SQL View)
 Index Back

Packaging - Product Licensing


SELECT DISTINCT 'PAGE' ,%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') UNION SELECT 'AE' ,AE_APPLID , OBJECTOWNERID FROM PSAEAPPLDEFN A WHERE NOT EXISTS( SELECT 'X' FROM PSPROJECTITEM WHERE OBJECTVALUE1 = A.AE_APPLID AND OBJECTTYPE=33 AND PROJECTNAME = 'PPLTOOLS') UNION SELECT DISTINCT 'ISCR' , %Substring(A.OBJECTVALUE1,1,18) , B.OBJECTOWNERID FROM PSPCMPROG A , PSRECDEFN B WHERE A.OBJECTVALUE1 LIKE 'WEBLIB%' AND A.OBJECTVALUE1 = B.RECNAME AND NOT EXISTS ( SELECT 'X' FROM PSPROJECTITEM C WHERE C.OBJECTVALUE1 = A.OBJECTVALUE1 AND OBJECTTYPE = 0 AND PROJECTNAME ='PPLTOOLS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PK_OBJECTTYPE Character(4) VARCHAR2(4) NOT NULL Added XLAT value for IScript 7/26/2001 ESHI
AE=App Engine
ISCR=IScript
PAGE=Page
2 PK_OBJECTNAME Character(18) VARCHAR2(18) NOT NULL Object Name
3 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier