RD_DIALOG_LNGVW (SQL View)	Index Back
Dialog Rel Lang View This returns the dialog names in the related language.

RD_DIALOG_LNGVW

(SQL View)

Dialog Rel Lang View

This returns the dialog names in the related language.

SELECT A.SETID , B.DIALOG_ID , B.LANGUAGE_CD , B.RY_DIALOG_NAME FROM PS_RD_DIALOG_VW A , PS_RYEDIALOG_LNG B WHERE A.DIALOG_ID = B.DIALOG_ID

Related Language Record for RD_DIALOG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.

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

4 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	RY_DIALOG_NAME	Character(254)	VARCHAR2(254) NOT NULL	Field is used to capture a Dialog Name.