SELECT TAX.TAXONOMY_ALIAS, TAX.TAXONOMY_URL, TAX.TAXONOMY_ID, NVL(ELM.ELEMENT_LABEL,ELM.ELEMENT_NAME), ELM.ELEMENT_NAME, MAP.ELEMENT_ID, MAP.TAXONOMY_ID FROM RG_XBRL_TAXONOMIES TAX, RG_XBRL_ELEMENTS ELM, RG_XBRL_MAP_ELEMENTS MAP WHERE MAP.ELEMENT_ID = ELM.ELEMENT_ID AND ELM.TAXONOMY_ID = TAX.TAXONOMY_ID AND MAP.ENABLED_FLAG = 'Y'
SELECT TAX.TAXONOMY_ALIAS
, TAX.TAXONOMY_URL
, TAX.TAXONOMY_ID
, NVL(ELM.ELEMENT_LABEL
, ELM.ELEMENT_NAME)
, ELM.ELEMENT_NAME
, MAP.ELEMENT_ID
, MAP.TAXONOMY_ID
FROM RG_XBRL_TAXONOMIES TAX
, RG_XBRL_ELEMENTS ELM
, RG_XBRL_MAP_ELEMENTS MAP
WHERE MAP.ELEMENT_ID = ELM.ELEMENT_ID
AND ELM.TAXONOMY_ID = TAX.TAXONOMY_ID
AND MAP.ENABLED_FLAG = 'Y'
|
|
|