VIEW: APPS.PN_ADDRESSES_ALL_DFV

Source

View Text - Preformatted

SELECT ROWID, ADDRESS_STYLE, (DECODE (ADDRESS_STYLE, 'UAA', ZIP_CODE, 'SE', ZIP_CODE, 'SA', ZIP_CODE, 'NE', ZIP_CODE, 'JP', ZIP_CODE, NULL)), (DECODE (ADDRESS_STYLE, 'SE', STATE, 'SA', STATE, 'JP', STATE, NULL)), (DECODE (ADDRESS_STYLE, 'SE', CITY, 'SA', CITY, 'NE', CITY, 'JP', CITY, NULL)), (DECODE (ADDRESS_STYLE, 'UAA', ADDRESS_LINE1, 'SE', ADDRESS_LINE1, 'SA', ADDRESS_LINE1, 'NE', ADDRESS_LINE1, 'JP', ADDRESS_LINE1, NULL)), (DECODE (ADDRESS_STYLE, 'UAA', ADDRESS_LINE2, 'SE', ADDRESS_LINE2, 'SA', ADDRESS_LINE2, 'NE', ADDRESS_LINE2, 'JP', ADDRESS_LINE2, NULL)), (DECODE (ADDRESS_STYLE, 'UAA', ADDRESS_LINE3, 'SE', ADDRESS_LINE3, 'SA', ADDRESS_LINE3, 'NE', ADDRESS_LINE3, 'JP', ADDRESS_LINE3, NULL)), ADDR_ATTRIBUTE15, STATE, PROVINCE, COUNTY, CITY, COUNTY,  
 (DECODE (ADDRESS_STYLE,  
      'JP', ADDRESS_STYLE || '.' || ZIP_CODE || '.' || STATE || '.' || CITY || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || ADDR_ATTRIBUTE15,  
      'NE', ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || STATE || '.' || ZIP_CODE || '.' || CITY,  
      'SA', ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || CITY || '.' || PROVINCE || '.' || STATE || '.' || COUNTY || '.' || ZIP_CODE,  
      'SE', ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || ZIP_CODE || '.' || CITY || '.' || STATE,  
      'UAA', ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || CITY || '.' || COUNTY || '.' || ZIP_CODE, NULL)) 
 FROM PN_ADDRESSES_ALL

View Text - HTML Formatted

SELECT ROWID
, ADDRESS_STYLE
, (DECODE (ADDRESS_STYLE
, 'UAA'
, ZIP_CODE
, 'SE'
, ZIP_CODE
, 'SA'
, ZIP_CODE
, 'NE'
, ZIP_CODE
, 'JP'
, ZIP_CODE
, NULL))
, (DECODE (ADDRESS_STYLE
, 'SE'
, STATE
, 'SA'
, STATE
, 'JP'
, STATE
, NULL))
, (DECODE (ADDRESS_STYLE
, 'SE'
, CITY
, 'SA'
, CITY
, 'NE'
, CITY
, 'JP'
, CITY
, NULL))
, (DECODE (ADDRESS_STYLE
, 'UAA'
, ADDRESS_LINE1
, 'SE'
, ADDRESS_LINE1
, 'SA'
, ADDRESS_LINE1
, 'NE'
, ADDRESS_LINE1
, 'JP'
, ADDRESS_LINE1
, NULL))
, (DECODE (ADDRESS_STYLE
, 'UAA'
, ADDRESS_LINE2
, 'SE'
, ADDRESS_LINE2
, 'SA'
, ADDRESS_LINE2
, 'NE'
, ADDRESS_LINE2
, 'JP'
, ADDRESS_LINE2
, NULL))
, (DECODE (ADDRESS_STYLE
, 'UAA'
, ADDRESS_LINE3
, 'SE'
, ADDRESS_LINE3
, 'SA'
, ADDRESS_LINE3
, 'NE'
, ADDRESS_LINE3
, 'JP'
, ADDRESS_LINE3
, NULL))
, ADDR_ATTRIBUTE15
, STATE
, PROVINCE
, COUNTY
, CITY
, COUNTY
, (DECODE (ADDRESS_STYLE
, 'JP'
, ADDRESS_STYLE || '.' || ZIP_CODE || '.' || STATE || '.' || CITY || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || ADDR_ATTRIBUTE15
, 'NE'
, ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || STATE || '.' || ZIP_CODE || '.' || CITY
, 'SA'
, ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || CITY || '.' || PROVINCE || '.' || STATE || '.' || COUNTY || '.' || ZIP_CODE
, 'SE'
, ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || ZIP_CODE || '.' || CITY || '.' || STATE
, 'UAA'
, ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || CITY || '.' || COUNTY || '.' || ZIP_CODE
, NULL))
FROM PN_ADDRESSES_ALL