ZX E-Business Tax Missing Location Values - draft

Description
Categories: BI Publisher, Financials
Application: E-Business Tax
Source: E-Business Tax Missing Location Values Report (XML) - Not Supported: Reserved For Future Use
Short Name: ZXLOCREP_XML
DB package: ZX_ZXLOCREP_XMLP_PKG
SELECT geography_type,
       geography_element10||decode(geography_element10, null, null, '.') ||
       geography_element9||decode(geography_element9, null, null, '.') ||
       geography_element8||decode(geography_element8, null, null, '.') ||
       geography_element7||decode(geography_element7, null, null, '.') ||
       geography_element6||decode(geography_element6, null, null, '.') ||
       geography_element5||decode(geography_element5, null, null, '.') ||
       geography_element4||decode(geography_element4, null, null, '.') ||
       geography_element3||decode(geography_element3, null, null, '.') ||
       geography_element2||decode(geography_element2, null, null, '.') ||
       geography_element1 geography_hierarchy
FROM hz_geographies
WHERE  geography_name like 'NO%VALUE'
ORDER BY geography_type