SETIDBO_NAME_DISPLAYRF_IPRD_CNAM_VW(SQL View) |
Index Back |
|---|---|
Prompt for all Customer NamesPrompt for customer names associated to installed products |
| SELECT DISTINCT A.SETID , B.BO_NAME_DISPLAY FROM PS_RF_INST_PROD A , PS_BO_NAME B WHERE A.BO_ID_CUST = B.BO_ID AND B.PRIMARY_IND = 'Y' AND A.INST_PROD_TYPE IN ('002', '003', '004') AND A.SETID = ( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE R.RECNAME = 'RD_COMPANY' AND A.SETID = R.SETCNTRLVALUE) |
| # | 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_NAME_DISPLAY |
Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |