Manual práctico de contratación y compra pública verde : modelos y ejemplos para su implantación por la Administración pública vasca.

Erakunde egilea: Euskadi Sociedad Pública de Gestión Ambiental.
Formatua: eBooka
Hizkuntza: Gaztelania
Euskara
Argitaratua: Vitoria-Gasteiz : IHOBE, Ingurumen Jarduketarako Sozietate Publikoa = IHOBE, Sociedad Pública de Gestión Ambiental, 2008
Lan-arloen araberako bilaketa: Ingurumena
Herri-administrazioaren araubide juridikoa
Gaiak:
Etiketak: Erantsi etiketa bat
Etiketarik gabe, Izan zaitez lehena erregistro honi etiketa jartzen!
Azala QR Kodea
Gorde:
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.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 = '4207' 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 = '4207' ) 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 = '4207' 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 = '4207' ) 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 = '4207' 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 = '4207' ) ORDER BY SEQ_NBR_863 DESC) WHERE ROWNUM <= 4

Funtsak

Gasteiz-Aretoa

8558 351.712:502.2 EUS man
Eskuragarri