CREATE OR REPLACE VIEW AB03B11V00 (ID011,ID001FASE,ID002TRAMITE,ID008TIPOPLAN,DESCES011,DESCEU011,ID007TPDOCDOKUSI,ID007STDOCDOKUSI,
ID007,DESCES007,DESCEU007,IDCODPADRE,ACTONOTIF007) AS
select ID_011,ID_001_FASE,ID_002_TRAMITE,ID_008_TIPO_PLAN,DESC_ES_011,DESC_EU_011,ID_007_TP_DOC_DOKUSI,ID_007_ST_DOC_DOKUSI,
ID_007,DESC_ES_007,DESC_EU_007,ID_COD_PADRE,ACTO_NOTIF_007
from ab03b11t00 t11
inner join ab03b07t00 t07 on t07.ID_007 = t11.ID_007_TP_DOC_DOKUSI
order by 4,2,3;
