SP_BURC06_OPRVW (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, filtered by operator or user id.

SP_BURC06_OPRVW

(SQL View)

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, filtered by operator or user id.

SELECT DISTINCT D.OPRID , 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_OPR 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_BURC06LOPRVW

# 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

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description