POS_MGR_VW_LNG (SQL View)	Index Back
Position Manager Preferences Position Manager Preferences

POS_MGR_VW_LNG

(SQL View)

Position Manager Preferences

SELECT a.setid , a.pos_calc_pref , b.language_cd , b.descr60 FROM PS_POS_MGR_PREF a , PS_POS_MGR_PREF_lg b WHERE (PRIVATE_PREF_CB<>'Y' OR a.OPRID=%OperatorId) AND a.setid=b.setid AND a.pos_calc_pref=b.pos_calc_pref

Related Language Record for POS_MGR_PREF_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_NOMETA_VW

2 POS_CALC_PREF Character(15) VARCHAR2(15) NOT NULL A hyperlink that allows the user to set up run time options.

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

4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_NOMETA_VW
2	POS_CALC_PREF	Character(15)	VARCHAR2(15) NOT NULL	A hyperlink that allows the user to set up run time options.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description