APPS.INV_LABEL_PVT7 dependencies on HR_ORGANIZATION_UNITS

Line 336: --Bug 3969347 -Adding the table hr_organization_units

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
340: ,loc.address_line_2 address_line_2,loc.address_line_3 address_line_3

Line 337: hr_organization_units hro,

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
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

Line 388: --Bug 3969347 --Added this condition to join the table hr_organization_units.

384: AND hrl1.location_id(+) = wnd.ULTIMATE_DROPOFF_LOCATION_ID
385: AND wdl.delivery_id (+) = wnd.delivery_id
386: AND wdi.entity_id (+) = wdl.delivery_leg_id
387: AND wdi.entity_name (+) = 'WSH_DELIVERY_LEGS' -- Bug 3905110
388: --Bug 3969347 --Added this condition to join the table hr_organization_units.
389: AND hro.organization_id(+) = wnd.organization_id
390: --End of fix for Bug 3969347
391: AND wdi.document_type(+) = 'BOL'
392: AND fcl.lookup_type(+) = 'SHIP_METHOD'