PO_AN_LGVW (SQL View)	Index Back
Purchasing Auto Num View Language View of PO_AN_VW

PO_AN_LGVW

(SQL View)

Purchasing Auto Num View

Language View of PO_AN_VW

SELECT DISTINCT a.SETID , a.BEG_SEQ , b.language_cd , b.DESCR FROM PS_AUTO_NUM_TBL a , PS_AUTO_NUM_LANG b WHERE a.setid=b.setid AND a.num_type=b.num_type AND a.beg_seq=b.beg_seq AND a.NUM_TYPE = 'PO'

Related Language Record for PO_AN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 BEG_SEQ Character(3) VARCHAR2(3) NOT NULL Beginning Sequence

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BEG_SEQ	Character(3)	VARCHAR2(3) NOT NULL	Beginning Sequence
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description