PV_CAT_TREE_LV1

(SQL View)
 Index Back

Category Tree RL View


SELECT DISTINCT a.SETID , a.TREE_NAME , a.TREE_NODE , a.TREE_NODE_NUM , b.CATEGORY_ID , d.RANGE_FROM ,d.RANGE_TO , b.DESCR60 , b.LANGUAGE_CD FROM PSTREENODE a , PSTREELEAF d , PS_ITM_CAT_TBL_LNG b , PSTREEDEFN c WHERE a.SETID = d.SETID AND a.SETCNTRLVALUE = d.SETCNTRLVALUE AND a.TREE_NAME = d.TREE_NAME AND a.TREE_NODE_NUM = d.TREE_NODE_NUM AND a.TREE_BRANCH = d.TREE_BRANCH AND d.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREELEAF WHERE d.SETID = SETID AND d.SETCNTRLVALUE = SETCNTRLVALUE AND d.TREE_NAME = TREE_NAME AND d.TREE_NODE_NUM = TREE_NODE_NUM AND d.TREE_BRANCH = TREE_BRANCH AND d.EFFDT <= %CurrentDateIn) AND d.RANGE_FROM <> ' ' AND d.DYNAMIC_RANGE = 'N' AND a.SETID = b.SETID AND a.TREE_NODE = b.CATEGORY_CD AND b.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITM_CAT_TBL WHERE SETID = b.SETID AND CATEGORY_TYPE = b.CATEGORY_TYPE AND CATEGORY_ID = b.CATEGORY_ID AND EFFDT <= %CurrentDateIn) AND a.SETID = c.SETID AND a.TREE_NAME = c.TREE_NAME AND a.SETCNTRLVALUE = c.SETCNTRLVALUE AND a.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREENODE WHERE a.SETID = SETID AND a.TREE_NAME = TREE_NAME AND a.EFFDT <= %CurrentDateIn) AND c.EFF_STATUS = 'A'

  • Related Language Record for PV_CAT_TREE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    3 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    4 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
    5 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    6 RANGE_FROM Character(30) VARCHAR2(30) NOT NULL Lower boundary for detail value that contains a range of values
    7 RANGE_TO Character(30) VARCHAR2(30) NOT NULL Upper boundary for detail value that contains a range of values
    8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code