BUSINESS_UNITSP_RCVRHD_CSVW(SQL View) |
Index Back |
|---|---|
Call Center Business UnitsView used as prompt view for Case business unit look-up when security should not be applied. |
| SELECT DISTINCT O.OPRID , A.BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_RC A , PS_BUS_UNIT_TBL_FS B , PS_BUS_UNIT_RC_DEF C , PS_BUS_UNIT_RC_RDT D , PS_SEC_BU_CLS F , PSOPRDEFN O WHERE A.BUSINESS_UNIT = F.BUSINESS_UNIT AND F.OPRCLASS = O.ROWSECCLASS AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.DISP_TMPL_FAM_CD = D.DISP_TMPL_FAM_CD AND C.DISP_TMPL_FAM_CD='RC_HELPDESK' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |