LM_FND_FCLTY_VW (SQL View)	Index Back
Facility Search View Use to search facilty location by City and State

LM_FND_FCLTY_VW

(SQL View)

Facility Search View

Use to search facilty location by City and State

SELECT COUNTRY , LM_FCLTY_ID , CASE WHEN (STATE = ' ' AND CITY = ' ') THEN ' ' WHEN (STATE = ' ') THEN CITY WHEN (CITY = ' ') THEN STATE ELSE CITY %Concat ', ' %Concat STATE END , LM_FCLTY FROM PS_LM_FCLTY_TBL

Related Language Record: LM_FND_FCLT_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

2 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID

3 LM_LOC_NAME Character(50) VARCHAR2(50) NOT NULL Region

4 LM_FCLTY Character(50) VARCHAR2(50) NOT NULL Facility Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
2	LM_FCLTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Facility ID
3	LM_LOC_NAME	Character(50)	VARCHAR2(50) NOT NULL	Region
4	LM_FCLTY	Character(50)	VARCHAR2(50) NOT NULL	Facility Description