PK_ISCR_VW

(SQL View)
 Index Back

Packaging - Product Licensing

Created for IScript Licensing project 07/26/2001 ESHI

SELECT DISTINCT %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_OBJECTNAME Character(18) VARCHAR2(18) NOT NULL Object Name
2 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier