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_TRIP_STOPS_VALIDATIONS dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 926: wsh_delivery_assignments_v wda,

922: cursor stop_to_det_cur( p_stop_id IN NUMBER ) is
923: select distinct 'X'
924: from wsh_delivery_details wdd,
925: wsh_new_deliveries wnd,
926: wsh_delivery_assignments_v wda,
927: wsh_delivery_legs wdl
928: where (wdl.pick_up_stop_id = p_stop_id OR wdl.drop_off_stop_id = p_stop_id)
929: and wnd.delivery_id = wdl.delivery_id
930: and wda.delivery_id = wnd.delivery_id

Line 3138: FROM wsh_delivery_assignments wda, wsh_delivery_details wdd,

3134: --
3135: -- Need to get receiving organization_id and destination type code for location
3136: CURSOR get_org_id (c_delivery_id NUMBER) IS
3137: SELECT pl.destination_organization_id, pl.destination_type_code
3138: FROM wsh_delivery_assignments wda, wsh_delivery_details wdd,
3139: oe_order_lines_all oel, po_requisition_lines_all pl
3140: WHERE wda.delivery_id = c_delivery_id
3141: AND wda.delivery_detail_id = wdd.delivery_detail_id
3142: AND wdd.source_document_type_id = 10