Berdintasuna harremanetan = La relación es cosa de dos

Erakunde egilea: Euskadi Ararteko Consejo de la Infancia y la Adolescencia.
Formatua: Ezezaguna
Hizkuntza: Euskara
Gaztelania
Argitaratua: [Vitoria-Gasteiz] : Ararteko, 2016
Lan-arloen araberako bilaketa: Emakumeen berdintasuna
Haurrak eta nerabeak
Herri defendatzailea
Gaiak:
Ikusi agiria webean
Etiketak: Erantsi etiketa bat
Etiketarik gabe, Izan zaitez lehena erregistro honi etiketa jartzen!
Azala QR Kodea
Gorde:
  • Ikusi agiria webean
  • 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 = '21438' 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 = '21438' ) 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 = '21438' 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 = '21438' ) 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 = '21438' 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 = '21438' ) ORDER BY SEQ_NBR_863 DESC) WHERE ROWNUM <= 4