Contratos de las administraciones públicas : (texto refundido y reglamento)

Erakunde egilea: España.
Beste egile batzuk: Soler Cantalapiedra, María Teresa.
Formatua: Liburua
Hizkuntza: Gaztelania
Argitaratua: Madrid : Civitas, 2004
Edizioa: 6a edición
Saila: Biblioteca de Legislación Serie Menor ; 134.
Lan-arloen araberako bilaketa: Herri-administrazioaren araubide juridikoa
Gaiak:
Aurkibidea
Etiketak: Erantsi etiketa bat
Etiketarik gabe, Izan zaitez lehena erregistro honi etiketa jartzen!
Azala QR Kodea
Gorde:
Aurrebista
Aurrebista
Aurrebista
  • Aurkibidea
  • SELECT DISTINCT TEXTO, CPY_ID_NBR FROM (SELECT CLEAN_STR('' || ' ' || ENUM_1ST_LVL || ' ' || ENUM_2ND_LVL || ' ' || ENUM_3RD_LVL || ' ' || ENUM_4TH_LVL || ' ' || ENUM_5TH_LVL || ' ' || ENUM_6TH_LVL || ' ('|| chrnlgy_1st_lvl || NVL2(chrnlgy_2nd_lvl ,CONCAT(' ',chrnlgy_2nd_lvl ), '')|| NVL2(chrnlgy_3rd_lvl ,CONCAT(' ',chrnlgy_3rd_lvl ), '')|| NVL2(chrnlgy_4th_lvl ,CONCAT(' ',chrnlgy_4th_lvl ), '') || ')') AS TEXTO, CPY_ID.CPY_ID_NBR AS CPY_ID_NBR FROM SRL_ENUM_AND_CHNLGY, CPY_ID WHERE SRL_ENUM_AND_CHNLGY.CPY_ID_NBR = CPY_ID.CPY_ID_NBR AND CPY_ID.loan_prd_cde <> '7' AND CPY_ID.BIB_ITM_NBR = '332' AND SRL_ITM_STUS_CDE = 'r' AND seq_nbr_863 NOT IN (SELECT seq_nbr_866 FROM SRL_TXT_HLDNG_STMNT_FLDS WHERE BIB_ITM_NBR = '332' ) ORDER BY SEQ_NBR_863 DESC) UNION SELECT * FROM (SELECT CLEAN_STR('' || ' ' || ENUM_1ST_LVL || ' ' || ENUM_2ND_LVL || ' ' || ENUM_3RD_LVL || ' ' || ENUM_4TH_LVL || ' ' || ENUM_5TH_LVL || ' ' || ENUM_6TH_LVL || ' ('|| chrnlgy_1st_lvl || NVL2(chrnlgy_2nd_lvl ,CONCAT(' ',chrnlgy_2nd_lvl ), '')|| NVL2(chrnlgy_3rd_lvl ,CONCAT(' ',chrnlgy_3rd_lvl ), '')|| NVL2(chrnlgy_4th_lvl ,CONCAT(' ',chrnlgy_4th_lvl ), '') || ')') AS TEXTO, CPY_ID_NBR AS CPY_ID_NBR FROM SRL_ENUM_AND_CHNLGY WHERE BIB_ITM_NBR = '332' AND SRL_ITM_STUS_CDE = 'r' AND NO_EXPCTD = '0' AND seq_nbr_863 NOT IN (SELECT seq_nbr_866 FROM SRL_TXT_HLDNG_STMNT_FLDS WHERE BIB_ITM_NBR = '332' ) ORDER BY SEQ_NBR_863 DESC) UNION SELECT * FROM (SELECT CLEAN_STR(ENUM_1ST_LVL || ' ' || ENUM_2ND_LVL || ' ' || ENUM_3RD_LVL || ' ' || ENUM_4TH_LVL || ' ' || ENUM_5TH_LVL || ' ' || ENUM_6TH_LVL || ' ('|| chrnlgy_1st_lvl || NVL2(chrnlgy_2nd_lvl ,CONCAT(' ',chrnlgy_2nd_lvl ), '')|| NVL2(chrnlgy_3rd_lvl ,CONCAT(' ',chrnlgy_3rd_lvl ), '')|| NVL2(chrnlgy_4th_lvl ,CONCAT(' ',chrnlgy_4th_lvl ), '') || ')') AS TEXTO, CPY_ID_NBR AS CPY_ID_NBR FROM SRL_ENUM_AND_CHNLGY WHERE BIB_ITM_NBR = '332' AND SRL_ITM_STUS_CDE = 'r' AND NO_EXPCTD = '1' AND seq_nbr_863 NOT IN (SELECT seq_nbr_866 FROM SRL_TXT_HLDNG_STMNT_FLDS WHERE BIB_ITM_NBR = '332' ) ORDER BY SEQ_NBR_863 DESC) WHERE ROWNUM <= 4

    Funtsak

    Gasteiz-Gordailua

    428 351.712 ESP con
    Eskuragarri