1 2 3 4 5 6 7
|
INSERT INTO MVT_AD(ID_MVT, IDAGENT, TRAITEMENT, MODIFICATION, DATE_MVT, ETAT_MVT, NOMUSE, NOMPAT, PRENOM, DN, ID_AD, TELEPHONENUMBER, FACSIMILETELEPHONENUMBER, UID_CREATOR)
SELECT SEQ_MVT_AD.nextval, M.IDAGENT, 'TRT_NDS', 'M', sysdate, '1', m.NOMUSE, m.NOMPAT, m.PRENOM, AD.DN, AD.SAMACCOUNTNAME, nds.TELEPHONENUMBER, nds.FACSIMILETELEPHONENUMBER, 'MVT_NDS'
FROM INT_NDS_AJOUT nds, META_INDEX M, INT_AD AD
WHERE M.COMPTE_ACTIF=1 AND M.COMPTE_NDS='O' AND M.COMPTE_EXCHANGE='O'
AND nds.uidnds=M.ID_NDS
AND M.ID_AD=ad.samaccountname |
Partager