APPS.INV_LABEL_PVT7 dependencies on HZ_LOCATIONS

Line 345: from hz_locations hz ) hrl,

341: select hz.location_id location_id,hz.address1 address_line_1
342: ,hz.address2 address_line_2,hz.address3 address_line_3
343: ,hz.address4 address_line_4,hz.city city,hz.postal_code postal_code
344: ,hz.state state,hz.county county,hz.country country,hz.province province
345: from hz_locations hz ) hrl,
346: --Bug 3969347 -Adding the table hr_organization_units
347: hr_organization_units hro,
348: --End of fix for Bug 3969347.
349: (select loc.location_id location_id,loc.address_line_1 address_line_1

Line 370: from hz_locations hz ) hrl1,

366: select hz.location_id location_id,hz.address1 address_line_1
367: ,hz.address2 address_line_2,hz.address3 address_line_3
368: ,hz.address4 address_line_4,hz.city city,hz.postal_code postal_code
369: ,hz.state state,hz.county county,hz.country country,hz.province province
370: from hz_locations hz ) hrl1,
371: wsh_new_deliveries wnd,
372: wsh_delivery_legs wdl,
373: wsh_document_instances wdi
374: -- Bug 2878652, get carrier name and ship method name

Line 388: , hz_locations loc

384: , wsh_delivery_assignments wda
385: , hz_cust_site_uses_all hcsua
386: , hz_party_sites party_site
387: , hz_loc_assignments loc_assign
388: , hz_locations loc
389: , hz_cust_acct_sites_all acct_site
390: where wdd.delivery_detail_id = wda.delivery_detail_id
391: and wda.delivery_id = p_delivery_id
392: and wdd.container_flag = 'N'