CAT_NODE_VW

(SQL View)
 Index Back

CATEGORY_CD prompt table

R-BSLOSS-Y33R3 04/05/2002 mj: - Added record Set Control Field = BUSINESS_UNIT - Inserted CAT_NODE_VW into record group FS_18

SELECT DISTINCT B.SETID , B.TREE_NODE , C.DESCR60 FROM PSTREEDEFN A , PSTREENODE B , PS_ITM_CAT_TBL C WHERE A.SETID = B.SETID AND A.SETCNTRLVALUE = B.SETCNTRLVALUE AND A.TREE_NAME = B.TREE_NAME AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PSTREEDEFN A1 WHERE A1.SETID = A.SETID AND A1.SETCNTRLVALUE = A.SETCNTRLVALUE AND A1.TREE_NAME = A.TREE_NAME AND A1.EFF_STATUS = 'A' AND A1.EFFDT <= %CurrentDateIn) AND B.SETID = C.SETID AND B.TREE_NODE = C.CATEGORY_CD AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_ITM_CAT_TBL C1 WHERE C1.SETID = C.SETID AND C1.CATEGORY_CD = C.CATEGORY_CD AND C1.EFF_STATUS = 'A' AND C1.EFFDT <= %CurrentDateIn)

# 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 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description