APPS.INV_LABEL_PVT7 dependencies on HR_ORGANIZATION_UNITS

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

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

Line 347: hr_organization_units hro,

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
350: ,loc.address_line_2 address_line_2,loc.address_line_3 address_line_3
351: ,loc.loc_information13 address_line_4,loc.town_or_city city

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

405: AND hrl1.location_id(+) = wnd.ULTIMATE_DROPOFF_LOCATION_ID
406: AND wdl.delivery_id (+) = wnd.delivery_id
407: AND wdi.entity_id (+) = wdl.delivery_leg_id
408: AND wdi.entity_name (+) = 'WSH_DELIVERY_LEGS' -- Bug 3905110
409: --Bug 3969347 --Added this condition to join the table hr_organization_units.
410: AND hro.organization_id(+) = wnd.organization_id
411: --End of fix for Bug 3969347
412: AND wdi.document_type(+) = 'BOL'
413: AND fcl.lookup_type(+) = 'SHIP_METHOD'