RO_CAPTREL_VW_L (SQL View)	Index Back
Association View Language view that is used to get the association

RO_CAPTREL_VW_L

(SQL View)

Association View

Language view that is used to get the association

SELECT HD.CAPTURE_ID , SL.LANGUAGE_CD , HD.DESCR50 , SL.DESCR50 FROM %Table(RO_DEFNHDST_LNG) SL , %Table(RO_HEADER) HD WHERE SL.STATUS_CODE=HD.STATUS_CODE AND SL.SETID=( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE HD.BUSINESS_UNIT=R.SETCNTRLVALUE AND R.RECNAME='RO_DEFN_HDSTAT')

Related Language Record for RO_CAPTREL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

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

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

4 STATUS_DESCR Character(50) VARCHAR2(50) NOT NULL Field used to show the status description. Field used as edit box.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
4	STATUS_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Field used to show the status description. Field used as edit box.