VIEW: APPS.PO_VENDOR_SITES_ALL1_DFV

Source

View Text - Preformatted

SELECT ROWID, ADDRESS_STYLE, (DECODE (ADDRESS_STYLE, 'ES', ADDRESS_LINE1, NULL)), (DECODE (ADDRESS_STYLE, 'ES', ADDRESS_LINE2, NULL)), (DECODE (ADDRESS_STYLE, 'ES', ADDRESS_LINE3, NULL)), (DECODE (ADDRESS_STYLE, 'UAA', ZIP, 'SE', ZIP, 'SA', ZIP, 'NE', ZIP, 'KR', ZIP, 'JP', ZIP, 'ES', ZIP, NULL)), (DECODE (ADDRESS_STYLE, 'ES', CITY, NULL)), (DECODE (ADDRESS_STYLE, 'SA', PROVINCE, 'JP', STATE, 'ES', STATE, NULL)), (DECODE (ADDRESS_STYLE, 'SE', CITY, 'SA', CITY, 'NE', CITY, 'KR', 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)), (DECODE (ADDRESS_STYLE, 'JP', ADDRESS_LINES_ALT, NULL)), (DECODE (ADDRESS_STYLE, 'KR', ADDRESS_LINE1, NULL)), (DECODE (ADDRESS_STYLE, 'KR', ADDRESS_LINE2, NULL)), (DECODE (ADDRESS_STYLE, 'KR', ADDRESS_LINE3, NULL)), (DECODE (ADDRESS_STYLE, 'NE', STATE, NULL)), (DECODE (ADDRESS_STYLE, 'SE', STATE, 'SA', STATE, NULL)), (DECODE (ADDRESS_STYLE, 'SA', COUNTY, NULL)), (DECODE (ADDRESS_STYLE, 'UAA', CITY, NULL)), (DECODE (ADDRESS_STYLE, 'UAA', STATE, NULL)),  
 (DECODE (ADDRESS_STYLE,  
      'ES', ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || ZIP || '.' || CITY || '.' || STATE,  
      'JP', ADDRESS_STYLE || '.' || ZIP || '.' || STATE || '.' || CITY || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || ADDRESS_LINES_ALT,  
      'KR', ADDRESS_STYLE || '.' || ZIP || '.' || CITY || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3,  
      'NE', ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || STATE || '.' || ZIP || '.' || CITY,  
      'SA', ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || CITY || '.' || PROVINCE || '.' || STATE || '.' || COUNTY || '.' || ZIP,  
      'SE', ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || ZIP || '.' || CITY || '.' || STATE,  
      'UAA', ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || CITY || '.' || STATE || '.' || ZIP, NULL)) 
 FROM PO_VENDOR_SITES_ALL

View Text - HTML Formatted

SELECT ROWID
, ADDRESS_STYLE
, (DECODE (ADDRESS_STYLE
, 'ES'
, ADDRESS_LINE1
, NULL))
, (DECODE (ADDRESS_STYLE
, 'ES'
, ADDRESS_LINE2
, NULL))
, (DECODE (ADDRESS_STYLE
, 'ES'
, ADDRESS_LINE3
, NULL))
, (DECODE (ADDRESS_STYLE
, 'UAA'
, ZIP
, 'SE'
, ZIP
, 'SA'
, ZIP
, 'NE'
, ZIP
, 'KR'
, ZIP
, 'JP'
, ZIP
, 'ES'
, ZIP
, NULL))
, (DECODE (ADDRESS_STYLE
, 'ES'
, CITY
, NULL))
, (DECODE (ADDRESS_STYLE
, 'SA'
, PROVINCE
, 'JP'
, STATE
, 'ES'
, STATE
, NULL))
, (DECODE (ADDRESS_STYLE
, 'SE'
, CITY
, 'SA'
, CITY
, 'NE'
, CITY
, 'KR'
, 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))
, (DECODE (ADDRESS_STYLE
, 'JP'
, ADDRESS_LINES_ALT
, NULL))
, (DECODE (ADDRESS_STYLE
, 'KR'
, ADDRESS_LINE1
, NULL))
, (DECODE (ADDRESS_STYLE
, 'KR'
, ADDRESS_LINE2
, NULL))
, (DECODE (ADDRESS_STYLE
, 'KR'
, ADDRESS_LINE3
, NULL))
, (DECODE (ADDRESS_STYLE
, 'NE'
, STATE
, NULL))
, (DECODE (ADDRESS_STYLE
, 'SE'
, STATE
, 'SA'
, STATE
, NULL))
, (DECODE (ADDRESS_STYLE
, 'SA'
, COUNTY
, NULL))
, (DECODE (ADDRESS_STYLE
, 'UAA'
, CITY
, NULL))
, (DECODE (ADDRESS_STYLE
, 'UAA'
, STATE
, NULL))
, (DECODE (ADDRESS_STYLE
, 'ES'
, ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || ZIP || '.' || CITY || '.' || STATE
, 'JP'
, ADDRESS_STYLE || '.' || ZIP || '.' || STATE || '.' || CITY || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || ADDRESS_LINES_ALT
, 'KR'
, ADDRESS_STYLE || '.' || ZIP || '.' || CITY || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3
, 'NE'
, ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || STATE || '.' || ZIP || '.' || CITY
, 'SA'
, ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || CITY || '.' || PROVINCE || '.' || STATE || '.' || COUNTY || '.' || ZIP
, 'SE'
, ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || ZIP || '.' || CITY || '.' || STATE
, 'UAA'
, ADDRESS_STYLE || '.' || ADDRESS_LINE1 || '.' || ADDRESS_LINE2 || '.' || ADDRESS_LINE3 || '.' || CITY || '.' || STATE || '.' || ZIP
, NULL))
FROM PO_VENDOR_SITES_ALL