SETIDPrompt Table: SP_SETID_NONVW
BO_NAME_DISPLAYBO_NAME_3RF_IPRD_CSIT_VW(SQL View) |
Index Back |
|---|---|
Installed Product Site ViewThis is a prompt view for installed products by Site, with or without customer. |
| SELECT DISTINCT A.SETID , D.BO_NAME_DISPLAY , B.BO_NAME FROM PS_RF_INST_PROD A , PS_BO_NAME D , PS_BO_NAME B , PS_RD_SITE C WHERE A.BO_ID_CUST = D.BO_ID(+) AND D.PRIMARY_IND(+) = 'Y' AND C.SETID = ( SELECT R.SETID FROM PS_SET_CNTRL_REC R WHERE R.RECNAME = 'RD_SITE' AND A.SETID = R.SETCNTRLVALUE) AND C.SITE_ID = A.SITE_ID AND B.BO_ID = C.BO_ID AND B.PRIMARY_IND = 'Y' AND A.INST_PROD_TYPE IN ('002', '003', '004') |
| # | 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.
Prompt Table: SP_SETID_NONVW |
| 2 | BO_NAME_DISPLAY |
Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 3 | BO_NAME_3 |
Character(50) | VARCHAR2(50) NOT NULL | BO Name 3 |