DBA Data[Home] [Help]

APPS.INV_LABEL_PVT7 dependencies on HR_LOCATIONS_ALL

Line 329: from hr_locations_all loc

325: ,loc.address_line_2 address_line_2,loc.address_line_3 address_line_3
326: ,loc.loc_information13 address_line_4,loc.town_or_city city
327: ,loc.postal_code postal_code,loc.region_2 state,loc.region_1 county
328: ,loc.country country,loc.region_3 province
329: from hr_locations_all loc
330: union all
331: select hz.location_id location_id,hz.address1 address_line_1
332: ,hz.address2 address_line_2,hz.address3 address_line_3
333: ,hz.address4 address_line_4,hz.city city,hz.postal_code postal_code

Line 344: from hr_locations_all loc

340: ,loc.address_line_2 address_line_2,loc.address_line_3 address_line_3
341: ,loc.loc_information13 address_line_4,loc.town_or_city city
342: ,loc.postal_code postal_code,loc.region_2 state,loc.region_1 county
343: ,loc.country country,loc.region_3 province
344: from hr_locations_all loc
345: union all
346: select hz.location_id location_id,hz.address1 address_line_1
347: ,hz.address2 address_line_2,hz.address3 address_line_3
348: ,hz.address4 address_line_4,hz.city city,hz.postal_code postal_code