1. Tables and Views for Financials
  2. ZX_FINAL_DISCHARGE_LOC_V

ZX_FINAL_DISCHARGE_LOC_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

LOCATION_ID

LOCATION_CODE

FINAL_DISCHARGE_LOC_TYPE

ADDRESS

COUNTRY

STATE

COUNTY

CITY

POSTAL_CODE

PROVINCE

FINAL_DISCHARGE_LOC_TYPE_NAME

Query

SQL_Statement

SELECT

location_id,

location_code,

final_discharge_loc_type,

address,

country,

state,

county,

city,

postal_code,

province,

final_discharge_loc_type_name

FROM

(

SELECT

hzloc.location_id,

clli_code location_code,

zxloc.entity_code final_discharge_loc_type,

( address1

|| ' '

|| address2

|| ' '

|| address3

|| ' '

|| address4

|| ' '

|| city

|| ' '

|| state

|| ' '

|| postal_code ) AS address,

country,

state,

county,

city,

postal_code,

province,

fndlkp.meaning final_discharge_loc_type_name

FROM

hz_locations hzloc,

zx_final_discharge_locations zxloc,

fnd_lookups fndlkp

WHERE

hzloc.location_id = zxloc.entity_id

AND zxloc.entity_code = 'HZ_LOCATIONS'

AND fndlkp.lookup_type = 'ZX_LOCATION_TYPE'

AND fndlkp.lookup_code = zxloc.entity_code

UNION ALL

SELECT

hrloc.location_id,

location_code,

fndlkp.lookup_code final_discharge_location_type,

( address_line_1

|| ' '

|| address_line_2

|| ' '

|| address_line_3

|| ' '

|| address_line_4

|| ' '

|| town_or_city

|| ' '

|| region_2

|| ' '

|| postal_code ) AS address,

country,

region_2 state,

region_1 county,

town_or_city city,

postal_code,

region_3 province,

fndlkp.meaning final_discharge_loc_type_name

FROM

hr_locations hrloc,

fnd_lookups fndlkp

WHERE

fndlkp.lookup_type = 'ZX_LOCATION_TYPE'

AND fndlkp.lookup_code = 'HR_LOCATIONS'

AND ( ( ship_to_site_flag IS NOT NULL

AND ship_to_site_flag = 'Y' )

OR ( bill_to_site_flag IS NOT NULL

AND bill_to_site_flag = 'Y' ) )

ORDER BY

country

)