PV_CATSRCHTR_VW

(SQL View)
 Index Back

Catalog Search View


SELECT A.SETID , A.TREE_NAME , B.TREE_NODE_NUM , B.TREE_NODE , B.PARENT_NODE_NUM , B.PARENT_NODE_NAME , %Substring(J.DESCR60, 1, 30) , J.CATEGORY_ID , J.DESCR60 FROM PSTREEDEFN A , PSTREENODE B , PS_ITM_CAT_TBL J , PS_INSTALLATION_PO P WHERE A.SETID = B.SETID AND A.SETCNTRLVALUE = B.SETCNTRLVALUE AND A.TREE_NAME = B.TREE_NAME AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSTREEDEFN C WHERE A.SETID = C.SETID AND A.SETCNTRLVALUE = C.SETCNTRLVALUE AND A.TREE_NAME = C.TREE_NAME AND C.EFFDT <= %CurrentDateIn) AND A.EFFDT = B.EFFDT AND A.TREE_STRCT_ID = 'ITEMS' AND A.EFF_STATUS = 'A' AND A.SETID = J.SETID AND B.TREE_NODE = J.CATEGORY_CD AND J.CATEGORY_TYPE = P.CATEGORY_TYPE AND J.EFFDT = ( SELECT MAX(J2.EFFDT) FROM PS_ITM_CAT_TBL J2 WHERE J.SETID = J2.SETID AND J.CATEGORY_TYPE = J2.CATEGORY_TYPE AND J.CATEGORY_CD = J2.CATEGORY_CD AND J.CATEGORY_ID = J2.CATEGORY_ID AND J2.EFFDT <= %CurrentDateIn)

  • Related Language Record: PV_CATSRCTR_LVW

    • # 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_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
    4 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    5 PARENT_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Parent Node Number
    6 PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    9 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description