DBA Data[Home] [Help]

APPS.WSH_TRIP_VALIDATIONS dependencies on WSH_SHIPPING_PARAMETERS

Line 973: wsh_shipping_parameters wsp

969: SELECT count(*)
970: FROM wsh_trip_stops t,
971: wsh_delivery_legs dg,
972: wsh_new_deliveries dl,
973: wsh_shipping_parameters wsp
974: WHERE t.stop_id = p_trip_id AND
975: dg.pick_up_stop_id = t.stop_id AND
976: dl.delivery_id = dg.delivery_id AND
977: dl.organization_id = wsp.organization_id AND

Line 2143: wsh_shipping_parameters wsp, -- OTM R12, glog proj

2139: wsh_delivery_legs wdl,
2140: wsh_trip_stops wts1,
2141: wsh_trip_stops wts2,
2142: wsh_trips wt,
2143: wsh_shipping_parameters wsp, -- OTM R12, glog proj
2144: mtl_client_parameters_v mcp -- LSP PROJECT
2145: WHERE wnd.delivery_id = wdl.delivery_id
2146: AND wts1.stop_id = wdl.PICK_UP_STOP_ID
2147: AND wts2.stop_id = wdl.DROP_OFF_STOP_ID