DBA Data[Home] [Help]

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 357: --, wsh_carriers_v wcv

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
357: --, wsh_carriers_v wcv
358: , wsh_trip_stops wts
359: , wsh_trips wt
360: --Added to fix the issue reported in the Bug#4445708
361: , ( select party_site.addressee addressee

Line 664: FROM wsh_carriers_v

660: IF v_delivery.carrier_id IS NOT NULL THEN
661: BEGIN
662: SELECT carrier_name
663: INTO v_delivery.carrier
664: FROM wsh_carriers_v
665: WHERE carrier_id = v_delivery.carrier_id
666: AND ROWNUM<2;
667: EXCEPTION
668: WHEN others THEN