SP_BURC06_CLSVW

(SQL View)
 Index Back

HR HelpDesk BU's

Security view used by call center to get all business units registered on support cases which exist on Business unit definition for call center and field service, filtering only those BU's fro the specific permission list.

SELECT DISTINCT D.OPRCLASS , A.BUSINESS_UNIT , C.DESCR FROM PS_BUS_UNIT_TBL_RC A , PS_BUS_UNIT_RC_DEF B , PS_BUS_UNIT_TBL_FS C ,PS_SEC_BU_CLS D WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PNLGRPNAME = 'RC_CASE' AND B.DISP_TMPL_FAM_CD = 'CRM_HHD' AND A.BU_STATUS = '1' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BUSINESS_UNIT = A.BUSINESS_UNIT

  • Related Language Record: SP_BURC06LCLSVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description