PV_CAT_TREE_VW

(SQL View)
 Index Back

Category Tree View


SELECT DISTINCT a.SETID , a.TREE_NAME , a.TREE_NODE , a.TREE_NODE_NUM , b.CATEGORY_ID , b.CATEGORY_CD , a.PARENT_NODE_NUM , b.DESCR60 FROM PSTREENODE a , PS_ITM_CAT_TBL b , PSTREEDEFN c WHERE 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 CATEGORY_CD = b.CATEGORY_CD AND EFFDT <= %CurrentDateIn ) AND b.EFF_STATUS = 'A' 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.SETCNTRLVALUE = SETCNTRLVALUE AND a.TREE_NODE_NUM = TREE_NODE_NUM AND a.TREE_NODE = TREE_NODE AND a.TREE_BRANCH = TREE_BRANCH AND a.EFFDT <= %CurrentDateIn ) AND c.EFF_STATUS = 'A' AND C.TREE_STRCT_ID = 'ITEMS'

  • Related Language Record: PV_CAT_TREE_LV

    • # 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 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
    7 PARENT_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Parent Node Number
    8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description