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 372: wsh_delivery_legs wdl,

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

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

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