OPRIDSETIDTD_TREE_ID_PRODTD_TREE_EFFDT_PRODPRODUCT_IDTD_PROD_OPRVW2(SQL View) |
Index Back |
|---|---|
Product Tree Secure View |
| SELECT DISTINCT A.OPRID , %Substring(F.SETCNTRLVALUE , 1, 5) , A.TD_TREE_ID , A.EFFDT , D.PRODUCT_ID , D.DESCR FROM PS_TD_TREE_NODE_VW A , PS_PROD_ITEM D , PS_SET_CNTRL_REC F WHERE A.SETID = F.SETID AND F.RECNAME = 'PROD_ITEM' AND A.SETID = D.SETID AND A.PRODUCT_ID = D.PRODUCT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | TD_TREE_ID_PROD |
Character(8) | VARCHAR2(8) NOT NULL | Product Tree ID |
| 4 | TD_TREE_EFFDT_PROD |
Date(10) | DATE | Product Effdt |
| 5 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |