Bind :1 = OPRID that made the code changes.
Bind :2 = Project Name that is being promoted.
SELECT * FROMPSPCMPROG A WHERE LASTUPDOPRID = ':1' AND LASTUPDDTTM > (sysdate - 19) AND NOT EXISTS ( SELECT 'X' FROM PSPROJECTITEM X WHERE X.PROJECTNAME = ':2' AND X.OBJECTID1 = A.OBJECTID1 AND X.OBJECTVALUE1 = A.OBJECTVALUE1 AND X.OBJECTID2 = A.OBJECTID2 AND X.OBJECTVALUE2 = A.OBJECTVALUE2 AND X.OBJECTID3 = A.OBJECTID3 AND X.OBJECTVALUE3 = A.OBJECTVALUE3 AND X.OBJECTID4 = A.OBJECTID4 AND X.OBJECTVALUE4 = A.OBJECTVALUE4);
No comments:
Post a Comment