SETIDINST_PROD_IDRBT_IPVOICE_VW4(SQL View) |
Index Back |
|---|---|
Installed ProductsInstalled products used by Lost and Stolen |
| SELECT A.SETID ,A.INST_PROD_ID ,D.DESCR ,B.INST_PROD_STATUS , A.PARENT_INST_PRODID FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B , PS_RBT_PROD_ITEM C , PS_PROD_ITEM D WHERE A.SETID=B.SETID AND A.INST_PROD_ID=B.INST_PROD_ID AND A.SETID=C.SETID AND A.PRODUCT_ID=C.PRODUCT_ID AND A.SETID=D.SETID AND A.PRODUCT_ID=D.PRODUCT_ID |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | INST_PROD_STATUS | Character(4) | VARCHAR2(4) NOT NULL | Status of an installed product. |
| 5 | PARENT_INST_PRODID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to store the installed product ID of the parent installed product |