DBA Data[Home] [Help]

APPS.FTE_TRIPS_PVT dependencies on WSH_NEW_DELIVERIES

Line 1414: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,

1410: --
1411: CURSOR get_org_info_cur (c_stop_id IN NUMBER)
1412: IS
1413: SELECT distinct(org.organization_name) org_name
1414: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1415: wsh_trip_stops stops, org_organization_definitions org
1416: WHERE dlegs.delivery_id = dlvy.delivery_id
1417: AND dlegs.pick_up_stop_id = stops.stop_id
1418: AND org.organization_id = dlvy.organization_id

Line 1623: FROM wsh_new_deliveries

1619: -- Cursor to get total weight and vol info by delivery
1620: CURSOR get_dlvy_weight_vol_cur (c_trip_id IN NUMBER)
1621: IS
1622: SELECT delivery_id, gross_weight, weight_uom_code, volume, volume_uom_code
1623: FROM wsh_new_deliveries
1624: WHERE delivery_id IN
1625: (SELECT distinct(wdl.delivery_id)
1626: FROM wsh_trip_stops wts, --t
1627: wsh_delivery_legs wdl --d