RS_CW_LOC_VW

(SQL View)
 Index Back

Create Resources

LOCATION List.

SELECT DISTINCT A.LOCATION , A.DESCR , 'N' FROM %Table(LOCATION_TBL) A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM %Table(LOCATION_TBL) B WHERE B.EFFDT <= %CurrentDateIn AND B.LOCATION = A.LOCATION AND B.EFF_STATUS = 'A') AND A.EFF_STATUS = 'A'

  • Related Language Record: RS_CW_LOC_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 RS_CW_SELECTED Character(1) VARCHAR2(1) NOT NULL VARCHAR2(1) NOT NULL

    Y/N Table Edit