CREATE DBPROC SP_S_TRANSFER_RESPONSABLE
(IN COD_EMPRESA VARCHAR(4),
IN ANNO VARCHAR(4),
IN MES VARCHAR(2))
AS
select ACF_TRANSFERENCIA_RESPONSABLE.*,
MAE_AREAS.DES_AREAS AS DES_RES_ORI,
MAE_AREAS1.DES_AREAS AS DES_RES_DES,
MAE_AUXILIAR.DES_AUXILIAR AS DES_PER_ORI,
MAE_AUXILIAR1.DES_AUXILIAR AS DES_PER_DES,
ACF_ACTIVO_FIJO.DES_LARGA_ACT,ACF_ACTIVO_FIJO.COD_SUCURSAL
FROM TEST.ACF_TRANSFERENCIA_RESPONSABLE,TEST.MAE_AREAS,
TEST.MAE_AREAS AS MAE_AREAS1,
TEST.MAE_AUXILIAR, TEST.MAE_AUXILIAR AS MAE_AUXILIAR1, ACF_ACTIVO_FIJO
WHERE ACF_TRANSFERENCIA_RESPONSABLE.COD_EMPRESA *=
MAE_AREAS.COD_EMPRESA AND
ACF_TRANSFERENCIA_RESPONSABLE.NUM_VER_AREAS *=
MAE_AREAS.NUM_VER_AREAS
AND
ACF_TRANSFERENCIA_RESPONSABLE.COD_RESPONSABLE_ORI *=
MAE_AREAS.COD_AREAS AND
ACF_TRANSFERENCIA_RESPONSABLE.COD_EMPRESA *=
MAE_AREAS1.COD_EMPRESA
AND
ACF_TRANSFERENCIA_RESPONSABLE.NUM_VER_AREAS *=
MAE_AREAS1.NUM_VER_AREAS AND
ACF_TRANSFERENCIA_RESPONSABLE.COD_RESPONSABLE_DES *=
MAE_AREAS1.COD_AREAS AND
ACF_TRANSFERENCIA_RESPONSABLE.COD_EMPRESA *=
MAE_AUXILIAR.COD_EMPRESA
AND
ACF_TRANSFERENCIA_RESPONSABLE.COD_PERSONAL_ORI *=
MAE_AUXILIAR.COD_AUXILIAR AND
ACF_TRANSFERENCIA_RESPONSABLE.COD_EMPRESA *=
MAE_AUXILIAR1.COD_EMPRESA
AND
ACF_TRANSFERENCIA_RESPONSABLE.COD_PERSONAL_DES *=
MAE_AUXILIAR1.COD_AUXILIAR AND
ACF_TRANSFERENCIA_RESPONSABLE.COD_EMPRESA *=
ACF_ACTIVO_FIJO.COD_EMPRESA AND
ACF_TRANSFERENCIA_RESPONSABLE.COD_ACT_FIJO *=
ACF_ACTIVO_FIJO.COD_ACT_FIJO AND
ACF_TRANSFERENCIA_RESPONSABLE.COD_EMPRESA =COD_EMPRESA AND
ACF_TRANSFERENCIA_RESPONSABLE.NUM_MES_TRANSFERENCIA =MES AND
ACF_TRANSFERENCIA_RESPONSABLE.ANO_TRANSFERENCIA= ANNO
ORDER BY ACF_TRANSFERENCIA_RESPONSABLE.NUM_TRANSFERENCIA
Wanted to know if SAPDB supports these characters or for which can to
replace
Thanks
