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_DETAILS

Line 920: from wsh_delivery_details wdd,

916: and wnd.organization_id = wsp.organization_id;
917:
918: cursor stop_to_det_cur( p_stop_id IN NUMBER ) is
919: select distinct 'X'
920: from wsh_delivery_details wdd,
921: wsh_new_deliveries wnd,
922: wsh_delivery_assignments_v wda,
923: wsh_delivery_legs wdl
924: where (wdl.pick_up_stop_id = p_stop_id OR wdl.drop_off_stop_id = p_stop_id)

Line 3134: FROM wsh_delivery_assignments wda, wsh_delivery_details wdd,

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