eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT7 dependencies on WSH_DELIVERY_LEGS

Line 352: wsh_delivery_legs wdl,

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
355: , fnd_common_lookups fcl
356: -- Bug 5121507 Getting Carrier in the order of Trip->Delivery

Line 387: AND wdi.entity_name (+) = 'WSH_DELIVERY_LEGS' -- Bug 3905110

383: AND hrl.location_id(+) = wnd.INITIAL_PICKUP_LOCATION_ID
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'