TREE_NODERSF_ACC_NODE_VW(SQL View) |
Index Back |
|---|---|
Territory Tree Node View |
| SELECT DISTINCT B.TREE_NODE FROM PSTREEDEFN A , PSTREENODE B , PS_RSF_TR_NEW_TREE C WHERE A.EFF_STATUS = 'A' AND A.TREE_NAME = B.TREE_NAME AND A.TREE_NAME = C.TREE_NAME AND A.EFFDT = B.EFFDT AND A.TREE_STRCT_ID = 'TERRITORY_TREE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |