NVS_SCOPENODEVW(SQL View) |
Index Back |
---|---|
XX |
SELECT A.SETID ,A.TREE_NAME ,A.TREE_NODE ,A.EFFDT FROM PSTREENODE A ,PSTREEDEFN B WHERE B.SETID = A.SETID AND B.SETCNTRLVALUE = A.SETCNTRLVALUE AND B.TREE_NAME = A.TREE_NAME AND B.EFFDT = A.EFFDT AND ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PSTREENODE A_ED WHERE A.SETID = A_ED.SETID AND A.SETCNTRLVALUE = A_ED.SETCNTRLVALUE AND A.TREE_NAME = A_ED.TREE_NAME AND A_ED.EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS = 'A' ) |
# | 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 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |