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.WSH_BOLS_PVT dependencies on WSH_TRIPS

Line 65: l_trip_info wsh_trips_pvt.trip_rec_type;

61: , x_document_number IN OUT NOCOPY VARCHAR2
62: )
63: IS
64: x_rowid varchar2(30);
65: l_trip_info wsh_trips_pvt.trip_rec_type;
66: l_leg_info_new wsh_delivery_legs_pvt.delivery_leg_rec_type;
67: l_leg_info_old wsh_delivery_legs_pvt.delivery_leg_rec_type;
68: l_old_leg_id NUMBER;
69: l_new_leg_id NUMBER;

Line 328: l_trip_info wsh_trips_pvt.trip_rec_type;

324: p_carrier_id IN NUMBER
325: )
326: IS
327: x_rowid varchar2(30);
328: l_trip_info wsh_trips_pvt.trip_rec_type;
329: l_del_rows wsh_util_core.id_tab_type;
330: l_leg_rows wsh_util_core.id_tab_type;
331: l_ledger_id NUMBER; -- LE Uptake
332:

Line 629: wsh_trips wt,

625: wdl.delivery_id , --bugfix 3990683
626: wt.name
627: from wsh_delivery_legs wdl,
628: wsh_trip_stops wts1,
629: wsh_trips wt,
630: wsh_document_instances wdi,
631: wsh_doc_sequence_categories wdsc
632: where wdsc.doc_sequence_category_id = wdi.doc_sequence_category_id
633: AND NVL(wdsc.document_code, '-99') <> '-99'

Line 652: wsh_trips wt,

648: wt.name
649: from wsh_delivery_legs wdl,
650: wsh_trip_stops wts1,
651: wsh_trip_stops wts2,
652: wsh_trips wt,
653: wsh_document_instances wdi
654: where wdi.entity_id = wdl.delivery_leg_id
655: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
656: AND wdi.document_type = 'BOL'