RC_INSTPROD_VW9

(SQL View)
Index Back

Installed product prompt/SS

the user selects Serial ID, but that is defining the installed product for the case.

SELECT A.SETID , A.BO_ID_CUST , A.PRODUCT_ID , A.INST_PROD_ID , A.SERIAL_ID FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID AND B.INST_PROD_STATUS <> 'UNI'

# 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 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
4 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
5 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product