RBF_APP_VW (SQL View)	Index Back
View on RO Line View based on Order Capture Line.

RBF_APP_VW

(SQL View)

View on RO Line

View based on Order Capture Line.

SELECT A.CAPTURE_ID , A.CAPTURE_TYPE_CD , B.CONFIG_CODE FROM PS_RO_HEADER A , PS_RO_LINE B WHERE A.CAPTURE_ID = B.CAPTURE_ID

# 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 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
QUO=Quote
SO=Order

3 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

#	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	CAPTURE_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Capture Type QUO=Quote SO=Order
3	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator