EM_BUNM_AP_NOVW (SQL View)	Index Back
Security View for AP BUs Returns the AP business unit name

EM_BUNM_AP_NOVW

(SQL View)

Security View for AP BUs

Returns the AP business unit name

SELECT b.descrshort , a.business_unit FROM PS_BUS_UNIT_TBL_AP a , ps_bus_unit_tbl_fs b WHERE a.business_unit = b.business_unit

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit