RS_ALLORGTR_VWL

(SQL View)
 Index Back

SELECT DISTINCT L.SETID , L.LANGUAGE_CD , L.DESCR , F.DESCR FROM PSTREEDEFN A , %Table(SET_CNTRL_TREE) B , PSTREESTRCT C , %Table(INSTALLATION_RS) D , %Table(SETID_LANG) L , PSTREEDEFNLANG F WHERE A.SETID = B.SETID AND A.TREE_NAME = B.TREE_NAME AND A.TREE_NAME = D.TREE_NAME AND A.TREE_STRCT_ID = C.TREE_STRCT_ID AND (C.NODE_RECNAME = D.ORG_RECNAME OR C.DTL_RECNAME = D.ORG_RECNAME) AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN E WHERE E.SETID = A.SETID AND E.TREE_NAME = A.TREE_NAME AND E.SETCNTRLVALUE = A.SETCNTRLVALUE AND E.EFFDT <= %CurrentDateIn AND E.EFF_STATUS = 'A') AND A.SETID = L.SETID AND F.SETID = A.SETID AND F.SETCNTRLVALUE = A.SETCNTRLVALUE AND F.TREE_NAME = A.TREE_NAME AND F.EFFDT = A.EFFDT

  • Related Language Record for RS_ALLORGTRE_ST RS_ALLORGTRE_VW RS_ALLORGTRE_WM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TREE_NAME_SETID Character(5) VARCHAR2(5) NOT NULL TableSet
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr