APPS.FTE_DELIVERY_LEGS_PVT dependencies on WSH_DELIVERY_LEGS

Line 1216: UPDATE wsh_delivery_legs

1212: AND l_fte_trip_id IS NOT NULL
1213: )
1214: THEN
1215: --{
1216: UPDATE wsh_delivery_legs
1217: SET fte_trip_id = l_fte_trip_id,
1218: LAST_UPDATE_DATE = SYSDATE,
1219: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1220: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1260: UPDATE wsh_delivery_legs

1256: --
1257: IF l_reprice_required = 'Y'
1258: THEN
1259: --{
1260: UPDATE wsh_delivery_legs
1261: SET reprice_required = l_reprice_required,
1262: LAST_UPDATE_DATE = SYSDATE,
1263: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1264: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1268: wsh_delivery_legs wdl

1264: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1265: WHERE delivery_leg_id IN
1266: ( SELECT delivery_leg_id
1267: FROM wsh_trip_stops wts,
1268: wsh_delivery_legs wdl
1269: WHERE wts.trip_id = p_wsh_trip_id
1270: AND wdl.pick_up_stop_id = wts.stop_id
1271: );
1272: --

Line 2013: FROM wsh_delivery_legs dl, wsh_trip_stops st, wsh_trips t

2009: t.load_tender_status, -- new 11/6 added by dmlewis
2010: t.planned_flag, t.shipments_type_flag, t.vehicle_item_id,
2011: t.vehicle_organization_id, dl.parent_delivery_leg_id,
2012: t.rank_id, t.routing_rule_id, t.append_flag
2013: FROM wsh_delivery_legs dl, wsh_trip_stops st, wsh_trips t
2014: WHERE dl.delivery_leg_id = dLegId
2015: AND dl.pick_up_stop_id = st.stop_id
2016: AND t.trip_id = st.trip_id;
2017: --

Line 2032: (SELECT stop_id FROM wsh_trip_stops, wsh_delivery_legs

2028: st.stop_sequence_number, st.status_code
2029: FROM wsh_trip_stops st
2030: WHERE physical_stop_id IS NULL
2031: START WITH stop_id IN
2032: (SELECT stop_id FROM wsh_trip_stops, wsh_delivery_legs
2033: WHERE drop_off_stop_id = stop_id
2034: AND delivery_leg_id = dlegId)
2035: CONNECT BY PRIOR physical_stop_id = stop_id;
2036: --

Line 2101: AND entity_name = 'WSH_DELIVERY_LEGS'

2097: IS
2098: SELECT sequence_number
2099: FROM wsh_document_instances
2100: WHERE entity_id = dLegId
2101: AND entity_name = 'WSH_DELIVERY_LEGS'
2102: AND document_type = 'BOL'
2103: AND status = 'PLANNED';
2104: --
2105: -- GET PARENT DELIVERY INFO

Line 2109: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl

2105: -- GET PARENT DELIVERY INFO
2106: CURSOR get_parent_dlvy_info_cur (c_parentDLegId NUMBER)
2107: IS
2108: SELECT wnd.delivery_id, wnd.name
2109: FROM wsh_new_deliveries wnd, wsh_delivery_legs wdl
2110: WHERE wdl.delivery_leg_id = c_parentDLegId
2111: AND wdl.delivery_id = wnd.delivery_id;
2112: --
2113: --