LM_FND_SRFAC_VW

(SQL View)
 Index Back

Facility Search View

Use to search facilty location by City and State. If not present, the Country description is used.

SELECT FY.LM_FCLTY_ID , FY.LM_FCLTY , CASE WHEN FY.STATE <> ' ' AND FY.CITY <> ' ' THEN FY.CITY %Concat ', ' %Concat FY.STATE WHEN FY.STATE = ' ' AND FY.CITY <> ' ' THEN FY.CITY WHEN FY.STATE = ' ' AND FY.CITY = ' ' THEN CT.DESCR END FROM PS_LM_FCLTY_TBL FY , PS_COUNTRY_TBL CT WHERE FY.COUNTRY = CT.COUNTRY

  • Related Language Record: LM_FND_SRFC_LVW

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