RB_SLLSTOPLV_VW(SQL View) |
Index Back |
|---|---|
Installed sells prod and topsInstalled products with sells relation and its top levels |
| SELECT C.SETID , C.REL_INST_PROD_ID , TOPS.setid , TOPS.inst_prod_id , TOPS.installed_date FROM PS_RF_INST_PROD A , PS_RF_INST_LINK C , ps_rb_insgrpof_vw TOPS WHERE A.TOPLVL_INSTPROD_ID = TOPS.toplvl_instprod_id AND A.INST_PROD_ID = C.INST_PROD_ID AND C.PROD_REL_TYPE = 'SLLS' |
| # | 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 | SETID_SOURCE | Character(5) | VARCHAR2(5) NOT NULL | MOC SETID Field |
| 4 | INST_PROD_ID_2 | Character(20) | VARCHAR2(20) NOT NULL | Clone of Installed product ID used in work record |
| 5 | INSTALLED_DATE | Date(10) | DATE | Field used for storing Installed Date of Installed product |