-- modifique un grupo de roles (empiezan por ZMM_RELE%) y quiero saber
-- si se me olvido meter alguno en la orden de trasnporte
-- I modified a group of roles (begin with ZMM_RELE%) and I want to
-- know if I forgot to put some in the transport
select AGR_NAME, CREATE_USR, CREATE_DAT, CREATE_TIM,
CHANGE_USR, CHANGE_DAT, CHANGE_TIM
from d02.AGR_DEFINE -- roles
where MANDT = '200'
and AGR_NAME like 'ZMM_RELE%'
and AGR_NAME not in (
-- objetos de un task dentro de un transporte
select OBJ_NAME
from d02.E071
where TRKORR = 'D02K912278'
and OBJECT = 'ACGR' -- solo los objetos "roles"
)
order by 1
Suscribirse a
Entradas [Atom]