Verifica iDocs e suas tabelas intermediárias

/***************************************************************/ 
/* Verifica iDocs e tabelas intermediárias                     */
/***************************************************************/ 
    SELECT  IDOC.IDOC_CODE
          , IDOC.COMMENTS
          , IDOC.ENABLED  "iDoc Hab" -- Campo Habilitado da tela
          , APP.ENABLED   "Grupo Hab"-- Botão Grupos da tela, campo Habilitado
          , APPL.APPL_SYNCHRO
          , APPL.DESCRICAO
          , GP.CODIGO
          , GP.DESCRICAO
    FROM    SAP_ITF_IDOC              IDOC
          , SAP_ITF_IDOC_APPLSYN      APP
          , SAP_ITF_APPL_SYNCHRO      APPL
          , SAP_ITF_IDOC_GRUPO_ONLINE GP
    WHERE IDOC.IDOC_CODE = 'YFIILFAKNA'
      AND APP.IDOC_ID = IDOC.ID
      AND APPL.ID = APP.APPLSYN_ID
      AND GP.ID = APP.IDOCGRP_ID
UNION
    SELECT IDOC.IDOC_CODE
          --, IDOC.COMMENTS
          --, IDOC.ENABLED  -- Campo Habilitado da tela
          , 'SELECT * FROM ' || TB.TABLE_NAME || '_' || APPL.APPL_SYNCHRO || ';'
          , TB.ENABLED
          , '', '', '', '', ''
    FROM    SAP_ITF_IDOC              IDOC
          , SAP_ITF_IDOC_TABLES       TB
          , SAP_ITF_IDOC_APPLSYN      APP
          , SAP_ITF_APPL_SYNCHRO      APPL     
    WHERE IDOC.IDOC_CODE = 'YFIILFAKNA' AND
          TB.IDOC_ID       = IDOC.ID
          AND APP.IDOC_ID  = IDOC.ID
          AND APPL.ID      = APP.APPLSYN_ID
          AND TB.ENABLED   = 'S' -- Tabela Habilitada
          AND IDOC.ENABLED = 'S' -- iDoc Habilitado       
/***************************************************************/