RBW_PRD_SRCH_VW (SQL View)	Index Back
Product Search view for POI This is Product view used as prompt table for product in the Product of Interest Configurable Search. SetID and Descr are the keys (instead of SetID and ProductID) as the Configurable Search requires searching by Descr.

RBW_PRD_SRCH_VW

(SQL View)

Product Search view for POI

This is Product view used as prompt table for product in the Product of Interest Configurable Search. SetID and Descr are the keys (instead of SetID and ProductID) as the Configurable Search requires searching by Descr.

SELECT SETID ,DESCR ,PRODUCT_ID FROM PS_PROD_ITEM

Related Language Record: RBW_PRD_VW_LNG

# 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.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

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

3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID