SP_BUEXD_CLSVW

(SQL View)

SELECT d.oprclass , a.business_unit , b.descr FROM ps_bus_unit_tbl_in a , ps_bus_unit_tbl_fs b , PS_ORG_BU_TAX_APPL c ,ps_sec_bu_cls d WHERE a.business_unit=b.business_unit AND a.business_unit=c.business_unit AND a.business_unit=d.business_unit AND a.bu_status='1' AND c.org_bu_type='IN' AND c.exd_otc_appl='Y'

# 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

#	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