Sometimes you want to create a view in PeopleSoft which is based on another view.
Example:
View 1 (named PS_LOCKED_USR_VW) is defined as follows:
SELECT OPRID FROM PSOPRDEFN WHERE ACCTLOCK = 1;
View 2 (named PS_GET_LOCKED_NAME_VW) is defined as follows:
SELECT A.NAME FROM PS_PERSON_NAME A, PS_LOCKED_USR_VW B WHERE A.EMPLID = B.EMPLID;
When creating views using the createvw.dms script (or the REPLACE_VIEW […]
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
« Feb | ||||||
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
31 |