PK_AE_VW (SQL View)	Index Back
Packaging - Product Licensing

PK_AE_VW

(SQL View)

Packaging - Product Licensing

SELECT AE_APPLID , OBJECTOWNERID FROM PSAEAPPLDEFN A WHERE NOT EXISTS( SELECT 'X' FROM PSPROJECTITEM WHERE OBJECTVALUE1 = A.AE_APPLID AND OBJECTTYPE=33 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

#	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