APP_DES_OBJ_VWL (SQL View)	Index Back
App Designer Objects This SQL view retrieves the DESCR that a user will see, as well as the OBJNAME which will be stored in PSAUTHITEM from PS_APP_DES_OBJECTS where the APP_DES_CATEGORY = 'Objects'. It will be the GRID record in the page where a user assigns access permissions to Objects within Application Designer.

APP_DES_OBJ_VWL

(SQL View)

App Designer Objects

This SQL view retrieves the DESCR that a user will see, as well as the OBJNAME which will be stored in PSAUTHITEM from PS_APP_DES_OBJECTS where the APP_DES_CATEGORY = 'Objects'. It will be the GRID record in the page where a user assigns access permissions to Objects within Application Designer.

SELECT OBJNAME , LANGUAGE_CD , DESCR FROM PS_APP_DES_OBJ_LNG WHERE APP_DES_CATEGORY = '1'

Related Language Record for APP_DES_OBJ_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OBJNAME Character(30) VARCHAR2(30) NOT NULL Object Name

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OBJNAME	Character(30)	VARCHAR2(30) NOT NULL	Object Name
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description