[Home] [Help]
View: RG_XBRL_MAP_V
Product: | RG - Application Report Generator |
Description: | |
Implementation/DBA Data: |
APPS.RG_XBRL_MAP_V
|
View Text
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'
Columns
Name |
SOURCE_TAX_ALIAS |
SOURCE_TAX_URL |
SOURCE_TAXONOMY_ID |
ELEMENT_LABEL |
ELEMENT_NAME |
ELEMENT_ID |
MAP_TAXONOMY_ID |