RO_CAPTREL_VW (SQL View)	Index Back
Association View This view is used to get the association

RO_CAPTREL_VW

(SQL View)

Association View

This view is used to get the association

SELECT H.CAPTURE_ID , H.DESCR50 , H.REVISION_NUMBER , S.DESCR50 FROM PS_RO_HEADER H , PS_RO_DEFN_HDSTAT S WHERE H.STATUS_CODE=S.STATUS_CODE AND S.SETID=( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE H.BUSINESS_UNIT=R.SETCNTRLVALUE AND R.RECNAME='RO_DEFN_HDSTAT')

Related Language Record: RO_CAPTREL_VW_L

# 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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

3 REVISION_NUMBER Number(3,0) SMALLINT NOT NULL Revision

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	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
3	REVISION_NUMBER	Number(3,0)	SMALLINT NOT NULL	Revision
4	STATUS_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Field used to show the status description. Field used as edit box.