VIEW: APPS.PQH_ACCOMMODATIONS_F_DFV

Source

View Text - Preformatted

SELECT ROWID, STYLE, (DECODE (STYLE, 'FR_GLB', ADDRESS_LINE_1, 'FR', ADDRESS_LINE_1, NULL)), (DECODE (STYLE, 'FR_GLB', ADDRESS_LINE_2, 'FR', ADDRESS_LINE_2, NULL)), (DECODE (STYLE, 'FR_GLB', ADDRESS_LINE_3, 'FR', ADDRESS_LINE_3, NULL)), REGION_2, REGION_3, (DECODE (STYLE, 'FR_GLB', POSTAL_CODE, 'FR', POSTAL_CODE, NULL)), (DECODE (STYLE, 'FR_GLB', TOWN_OR_CITY, 'FR', TOWN_OR_CITY, NULL)), (DECODE (STYLE, 'FR_GLB', REGION_1, 'FR', REGION_1, NULL)), (DECODE (STYLE, 'FR_GLB', COUNTRY, 'FR', COUNTRY, NULL)), (DECODE (STYLE, 'FR_GLB', TELEPHONE_NUMBER_1, 'FR', TELEPHONE_NUMBER_1, NULL)), (DECODE (STYLE, 'FR_GLB', TELEPHONE_NUMBER_2, 'FR', TELEPHONE_NUMBER_2, NULL)), (DECODE (STYLE, 'FR_GLB', TELEPHONE_NUMBER_3, 'FR', TELEPHONE_NUMBER_3, NULL)), REGION_3,  
 (DECODE (STYLE,  
      'FR', STYLE || '.' || ADDRESS_LINE_1 || '.' || ADDRESS_LINE_2 || '.' || ADDRESS_LINE_3 || '.' || REGION_2 || '.' || REGION_3 || '.' || POSTAL_CODE || '.' || TOWN_OR_CITY || '.' || REGION_1 || '.' || COUNTRY || '.' || TELEPHONE_NUMBER_1 || '.' || TELEPHONE_NUMBER_2 || '.' || TELEPHONE_NUMBER_3,  
      'FR_GLB', STYLE || '.' || ADDRESS_LINE_1 || '.' || ADDRESS_LINE_2 || '.' || ADDRESS_LINE_3 || '.' || REGION_3 || '.' || POSTAL_CODE || '.' || TOWN_OR_CITY || '.' || REGION_1 || '.' || COUNTRY || '.' || TELEPHONE_NUMBER_1 || '.' || TELEPHONE_NUMBER_2 || '.' || TELEPHONE_NUMBER_3, NULL)) 
 FROM PQH_ACCOMMODATIONS_F

View Text - HTML Formatted

SELECT ROWID
, STYLE
, (DECODE (STYLE
, 'FR_GLB'
, ADDRESS_LINE_1
, 'FR'
, ADDRESS_LINE_1
, NULL))
, (DECODE (STYLE
, 'FR_GLB'
, ADDRESS_LINE_2
, 'FR'
, ADDRESS_LINE_2
, NULL))
, (DECODE (STYLE
, 'FR_GLB'
, ADDRESS_LINE_3
, 'FR'
, ADDRESS_LINE_3
, NULL))
, REGION_2
, REGION_3
, (DECODE (STYLE
, 'FR_GLB'
, POSTAL_CODE
, 'FR'
, POSTAL_CODE
, NULL))
, (DECODE (STYLE
, 'FR_GLB'
, TOWN_OR_CITY
, 'FR'
, TOWN_OR_CITY
, NULL))
, (DECODE (STYLE
, 'FR_GLB'
, REGION_1
, 'FR'
, REGION_1
, NULL))
, (DECODE (STYLE
, 'FR_GLB'
, COUNTRY
, 'FR'
, COUNTRY
, NULL))
, (DECODE (STYLE
, 'FR_GLB'
, TELEPHONE_NUMBER_1
, 'FR'
, TELEPHONE_NUMBER_1
, NULL))
, (DECODE (STYLE
, 'FR_GLB'
, TELEPHONE_NUMBER_2
, 'FR'
, TELEPHONE_NUMBER_2
, NULL))
, (DECODE (STYLE
, 'FR_GLB'
, TELEPHONE_NUMBER_3
, 'FR'
, TELEPHONE_NUMBER_3
, NULL))
, REGION_3
, (DECODE (STYLE
, 'FR'
, STYLE || '.' || ADDRESS_LINE_1 || '.' || ADDRESS_LINE_2 || '.' || ADDRESS_LINE_3 || '.' || REGION_2 || '.' || REGION_3 || '.' || POSTAL_CODE || '.' || TOWN_OR_CITY || '.' || REGION_1 || '.' || COUNTRY || '.' || TELEPHONE_NUMBER_1 || '.' || TELEPHONE_NUMBER_2 || '.' || TELEPHONE_NUMBER_3
, 'FR_GLB'
, STYLE || '.' || ADDRESS_LINE_1 || '.' || ADDRESS_LINE_2 || '.' || ADDRESS_LINE_3 || '.' || REGION_3 || '.' || POSTAL_CODE || '.' || TOWN_OR_CITY || '.' || REGION_1 || '.' || COUNTRY || '.' || TELEPHONE_NUMBER_1 || '.' || TELEPHONE_NUMBER_2 || '.' || TELEPHONE_NUMBER_3
, NULL))
FROM PQH_ACCOMMODATIONS_F