OBJECTVALUE1WHERE_REC_VW(SQL View) |
Index Back |
|---|---|
Where Used Cross Ref Work |
| SELECT A.OBJECTVALUE1 FROM PSPROJECTITEM A , PSPROJECTITEM B WHERE A.PROJECTNAME = 'CC_SAONLY' AND B.PROJECTNAME = 'HR_OBJECTS' AND B.OBJECTTYPE = A.OBJECTTYPE AND B.OBJECTID1 = A.OBJECTID1 AND B.OBJECTVALUE1 = A.OBJECTVALUE1 AND A.OBJECTTYPE = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OBJECTVALUE1 |
Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 |