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