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_CARRIERS_V

Line 235: -- Bug 2878652, get carrier name from wsh_carriers_v

231: , hrl1.state ship_to_state
232: , hrl1.county ship_to_county
233: , hrl1.country ship_to_country
234: , hrl1.province ship_to_province
235: -- Bug 2878652, get carrier name from wsh_carriers_v
236: -- Bug 5121507, Get carrier in order of Trip->Delivery
237: -- Get carrier_id first, then query carrier_name later
238: --, wcv.carrier_name carrier
239: , nvl(wt.carrier_id, wnd.carrier_id) carrier_id

Line 377: --, wsh_carriers_v wcv

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
377: --, wsh_carriers_v wcv
378: , wsh_trip_stops wts
379: , wsh_trips wt
380: --Added to fix the issue reported in the Bug#4445708
381: , ( select wda.delivery_id delivery_id, party_site.addressee addressee -- Added p_delivery_id 13108954

Line 684: FROM wsh_carriers_v

680: IF v_delivery.carrier_id IS NOT NULL THEN
681: BEGIN
682: SELECT carrier_name
683: INTO v_delivery.carrier
684: FROM wsh_carriers_v
685: WHERE carrier_id = v_delivery.carrier_id
686: AND ROWNUM<2;
687: EXCEPTION
688: WHEN others THEN