SP_RCVRHHD_OPVW

(SQL View)
Index Back

Call Center Business Units

View 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