DBA Data[Home] [Help]

APPS.FTE_TRIPS_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1415: wsh_trip_stops stops, org_organization_definitions org

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
1419: AND stops.stop_id = c_stop_id;