APPS.INV_LABEL_PVT7 dependencies on HZ_LOCATIONS

Line 335: from hz_locations hz ) hrl,

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
334: ,hz.state state,hz.county county,hz.country country,hz.province province
335: from hz_locations hz ) hrl,
336: --Bug 3969347 -Adding the table hr_organization_units
337: hr_organization_units hro,
338: --End of fix for Bug 3969347.
339: (select loc.location_id location_id,loc.address_line_1 address_line_1

Line 350: from hz_locations hz ) hrl1,

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
349: ,hz.state state,hz.county county,hz.country country,hz.province province
350: from hz_locations hz ) hrl1,
351: wsh_new_deliveries wnd,
352: wsh_delivery_legs wdl,
353: wsh_document_instances wdi
354: -- Bug 2878652, get carrier name and ship method name

Line 367: , hz_locations loc

363: , wsh_delivery_assignments wda
364: , hz_cust_site_uses_all hcsua
365: , hz_party_sites party_site
366: , hz_loc_assignments loc_assign
367: , hz_locations loc
368: , hz_cust_acct_sites_all acct_site
369: where wdd.delivery_detail_id = wda.delivery_detail_id
370: and wda.delivery_id = p_delivery_id
371: and wdd.container_flag = 'N'