VIEW: APPS.HZ_LOCATIONS1_DFV

Source

View Text - Preformatted

SELECT ROWID, ADDRESS_STYLE, (DECODE (ADDRESS_STYLE, 'UAA', POSTAL_CODE, 'SE', POSTAL_CODE, 'SA', POSTAL_CODE, 'POSTAL_ADDR_US', POSTAL_CODE, 'POSTAL_ADDR_DEF', POSTAL_CODE, 'NE', POSTAL_CODE, 'JP', POSTAL_CODE, NULL)), (DECODE (ADDRESS_STYLE, 'SE', STATE, 'SA', STATE, 'POSTAL_ADDR_US', STATE, 'POSTAL_ADDR_DEF', STATE, 'JP', STATE, NULL)), (DECODE (ADDRESS_STYLE, 'SE', CITY, 'SA', CITY, 'POSTAL_ADDR_US', CITY, 'POSTAL_ADDR_DEF', CITY, 'NE', CITY, 'JP', CITY, NULL)), (DECODE (ADDRESS_STYLE, 'UAA', ADDRESS1, 'SE', ADDRESS1, 'SA', ADDRESS1, 'NE', ADDRESS1, 'JP', ADDRESS1, NULL)), (DECODE (ADDRESS_STYLE, 'UAA', ADDRESS2, 'SE', ADDRESS2, 'SA', ADDRESS2, 'NE', ADDRESS2, 'JP', ADDRESS2, NULL)), (DECODE (ADDRESS_STYLE, 'UAA', ADDRESS3, 'SE', ADDRESS3, 'SA', ADDRESS3, 'NE', ADDRESS3, 'JP', ADDRESS3, NULL)), ADDRESS_LINES_PHONETIC, STATE, (DECODE (ADDRESS_STYLE, 'POSTAL_ADDR_US', ADDRESS1, 'POSTAL_ADDR_DEF', ADDRESS1, NULL)), (DECODE (ADDRESS_STYLE, 'POSTAL_ADDR_US', ADDRESS2, 'POSTAL_ADDR_DEF', ADDRESS2, NULL)), (DECODE (ADDRESS_STYLE, 'POSTAL_ADDR_US', ADDRESS3, 'POSTAL_ADDR_DEF', ADDRESS3, NULL)), (DECODE (ADDRESS_STYLE, 'POSTAL_ADDR_US', ADDRESS4, 'POSTAL_ADDR_DEF', ADDRESS4, NULL)), (DECODE (ADDRESS_STYLE, 'UAA', STATE, 'POSTAL_ADDR_US', COUNTY, 'POSTAL_ADDR_DEF', COUNTY, NULL)), (DECODE (ADDRESS_STYLE, 'SA', PROVINCE, 'POSTAL_ADDR_DEF', PROVINCE, NULL)), COUNTY, CITY,  
 (DECODE (ADDRESS_STYLE,  
      'JP', ADDRESS_STYLE || '.' || POSTAL_CODE || '.' || STATE || '.' || CITY || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || ADDRESS_LINES_PHONETIC,  
      'NE', ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || STATE || '.' || POSTAL_CODE || '.' || CITY,  
      'POSTAL_ADDR_DEF', ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || ADDRESS4 || '.' || CITY || '.' || COUNTY || '.' || STATE || '.' || PROVINCE || '.' || POSTAL_CODE,  
      'POSTAL_ADDR_US', ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || ADDRESS4 || '.' || CITY || '.' || COUNTY || '.' || STATE || '.' || POSTAL_CODE,  
      'SA', ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || CITY || '.' || PROVINCE || '.' || STATE || '.' || COUNTY || '.' || POSTAL_CODE,  
      'SE', ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || POSTAL_CODE || '.' || CITY || '.' || STATE,  
      'UAA', ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || CITY || '.' || STATE || '.' || POSTAL_CODE, NULL)) 
 FROM HZ_LOCATIONS

View Text - HTML Formatted

SELECT ROWID
, ADDRESS_STYLE
, (DECODE (ADDRESS_STYLE
, 'UAA'
, POSTAL_CODE
, 'SE'
, POSTAL_CODE
, 'SA'
, POSTAL_CODE
, 'POSTAL_ADDR_US'
, POSTAL_CODE
, 'POSTAL_ADDR_DEF'
, POSTAL_CODE
, 'NE'
, POSTAL_CODE
, 'JP'
, POSTAL_CODE
, NULL))
, (DECODE (ADDRESS_STYLE
, 'SE'
, STATE
, 'SA'
, STATE
, 'POSTAL_ADDR_US'
, STATE
, 'POSTAL_ADDR_DEF'
, STATE
, 'JP'
, STATE
, NULL))
, (DECODE (ADDRESS_STYLE
, 'SE'
, CITY
, 'SA'
, CITY
, 'POSTAL_ADDR_US'
, CITY
, 'POSTAL_ADDR_DEF'
, CITY
, 'NE'
, CITY
, 'JP'
, CITY
, NULL))
, (DECODE (ADDRESS_STYLE
, 'UAA'
, ADDRESS1
, 'SE'
, ADDRESS1
, 'SA'
, ADDRESS1
, 'NE'
, ADDRESS1
, 'JP'
, ADDRESS1
, NULL))
, (DECODE (ADDRESS_STYLE
, 'UAA'
, ADDRESS2
, 'SE'
, ADDRESS2
, 'SA'
, ADDRESS2
, 'NE'
, ADDRESS2
, 'JP'
, ADDRESS2
, NULL))
, (DECODE (ADDRESS_STYLE
, 'UAA'
, ADDRESS3
, 'SE'
, ADDRESS3
, 'SA'
, ADDRESS3
, 'NE'
, ADDRESS3
, 'JP'
, ADDRESS3
, NULL))
, ADDRESS_LINES_PHONETIC
, STATE
, (DECODE (ADDRESS_STYLE
, 'POSTAL_ADDR_US'
, ADDRESS1
, 'POSTAL_ADDR_DEF'
, ADDRESS1
, NULL))
, (DECODE (ADDRESS_STYLE
, 'POSTAL_ADDR_US'
, ADDRESS2
, 'POSTAL_ADDR_DEF'
, ADDRESS2
, NULL))
, (DECODE (ADDRESS_STYLE
, 'POSTAL_ADDR_US'
, ADDRESS3
, 'POSTAL_ADDR_DEF'
, ADDRESS3
, NULL))
, (DECODE (ADDRESS_STYLE
, 'POSTAL_ADDR_US'
, ADDRESS4
, 'POSTAL_ADDR_DEF'
, ADDRESS4
, NULL))
, (DECODE (ADDRESS_STYLE
, 'UAA'
, STATE
, 'POSTAL_ADDR_US'
, COUNTY
, 'POSTAL_ADDR_DEF'
, COUNTY
, NULL))
, (DECODE (ADDRESS_STYLE
, 'SA'
, PROVINCE
, 'POSTAL_ADDR_DEF'
, PROVINCE
, NULL))
, COUNTY
, CITY
, (DECODE (ADDRESS_STYLE
, 'JP'
, ADDRESS_STYLE || '.' || POSTAL_CODE || '.' || STATE || '.' || CITY || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || ADDRESS_LINES_PHONETIC
, 'NE'
, ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || STATE || '.' || POSTAL_CODE || '.' || CITY
, 'POSTAL_ADDR_DEF'
, ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || ADDRESS4 || '.' || CITY || '.' || COUNTY || '.' || STATE || '.' || PROVINCE || '.' || POSTAL_CODE
, 'POSTAL_ADDR_US'
, ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || ADDRESS4 || '.' || CITY || '.' || COUNTY || '.' || STATE || '.' || POSTAL_CODE
, 'SA'
, ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || CITY || '.' || PROVINCE || '.' || STATE || '.' || COUNTY || '.' || POSTAL_CODE
, 'SE'
, ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || POSTAL_CODE || '.' || CITY || '.' || STATE
, 'UAA'
, ADDRESS_STYLE || '.' || ADDRESS1 || '.' || ADDRESS2 || '.' || ADDRESS3 || '.' || CITY || '.' || STATE || '.' || POSTAL_CODE
, NULL))
FROM HZ_LOCATIONS