RO_Q_IPRD_VW_LN (SQL View)	Index Back
Related orders view This is a view that shows related orders.

RO_Q_IPRD_VW_LN

(SQL View)

Related orders view

This is a view that shows related orders.

SELECT iprod.SETID ,iprod.INST_PROD_ID , hdr.CAPTURE_ID ,hdr.LANGUAGE_CD , hdr.DESCR50 FROM PS_RO_HEADER_LANG hdr , PS_RO_LINE line , PS_RF_INST_PROD iprod WHERE hdr.CAPTURE_ID = line.CAPTURE_ID AND line.INST_PROD_ID=iprod.INST_PROD_ID AND line.STATUS_CODE IN (1000,2000) AND line.INST_PROD_ID <> ' '

Related Language Record for RO_QUED_IPRD_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50