APPS.WSH_MBOLS_PVT dependencies on WSH_NEW_DELIVERIES

Line 254: FROM wsh_new_deliveries del,

250: dlg.delivery_leg_id,
251: wt.ship_method_code,
252: del.initial_pickup_location_id,
253: wt.name
254: FROM wsh_new_deliveries del,
255: wsh_delivery_legs dlg,
256: wsh_trip_stops st,
257: wsh_trips wt
258: WHERE del.delivery_id = dlg.delivery_id

Line 268: wsh_new_deliveries del

264:
265: CURSOR c_get_ledger_id(p_delivery_id IN NUMBER) IS
266: SELECT ood.set_of_books_id
267: FROM org_organization_definitions ood,
268: wsh_new_deliveries del
269: WHERE ood.organization_id = del.organization_id
270: AND del.delivery_id = p_delivery_id;
271:
272: l_delivery_id NUMBER;

Line 1078: from wsh_new_deliveries

1074: END IF;
1075:
1076: select organization_id
1077: into l_organization_id
1078: from wsh_new_deliveries
1079: where delivery_id = l_first_delivery_id;
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.log(l_module_name,'l_organization_id', l_organization_id);
1082: END IF;