ZX E-Business Tax Missing Location Values - draft

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
BI Publisher
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

SQL 15 lines

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