CAT_TREE_RQS_VW

(SQL View)
 Index Back

Category working scroll view


SELECT DISTINCT a.setid , a.tree_node , d.requestor_id , a.tree_name , b.descr60 FROM PSTREENODE a , ps_itm_cat_tbl b , pstreedefn c , ps_requestor_cat d WHERE a.setid = b.setid AND a.tree_node = b.category_cd AND C.TREE_STRCT_ID ='ITEMS' AND b.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITM_CAT_TBL WHERE SETID = b.SETID 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 a.setid = b.setid AND c.eff_status = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
3 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
4 CATALOG_ID Character(18) VARCHAR2(18) NOT NULL Catalog ID
5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description