LM_BU_TBL_LVW (SQL View)	Index Back
Business Unit Table View of active Business Units

LM_BU_TBL_LVW

(SQL View)

Business Unit Table

View of active Business Units

SELECT A.BUSINESS_UNIT , A.LANGUAGE_CD , A.LM_BUS_UNIT_DESCR FROM PS_LM_BU_TBL_LANG A , PS_LM_BUS_UNIT_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.LM_ACTIVE_INACTIVE = 'A'

Related Language Record for LM_BU_TBL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 LM_BUS_UNIT_DESCR Character(50) VARCHAR2(50) NOT NULL Business Unit Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	LM_BUS_UNIT_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Business Unit Description