SP_RCVRHHD_OPVW(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_OPR O WHERE A.BUSINESS_UNIT = O.BUSINESS_UNIT 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='CRM_HHD' |
# | 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 |