We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
UPDATE CM_CO$DLQCS TMP SET MASTER_SA_ID = ( SELECT SA_ID FROM ( SELECT SA.SA_ID FROM CI_SA SA , CI_SA_TYPE SA_TYPE WHERE SA.ACCT_ID = TMP.ACCT_ID AND SA.SA_TYPE_CD = SA_TYPE.SA_TYPE_CD AND SA_TYPE.SUB_SA_SW = 'N' AND SA_TYPE.SVC_TYPE_CD = 'E' AND SA.SA_STATUS_FLG < 40 ORDER BY SA.START_DT DESC ) WHERE ROWNUM = 1 );
Join the community of 500,000 technology professionals and ask your questions.