DBA Data[Home] [Help]

APPS.WSH_DSNO dependencies on WSH_TRIP_STOPS

Line 235: FROM WSH_TRIP_STOPS WTS,

231:
232: cursor c_dsno_deliveries(c_trip_stop_id number ) is
233: SELECT
234: DECODE(HCAS.ORG_ID,WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(wnd.delivery_id),1,NULL,1, NULL) record_exists
235: FROM WSH_TRIP_STOPS WTS,
236: WSH_TRIPS WTP,
237: WSH_TRIP_STOPS WTS2,
238: WSH_DELIVERY_LEGS WDL,
239: WSH_NEW_DELIVERIES WND,

Line 237: WSH_TRIP_STOPS WTS2,

233: SELECT
234: DECODE(HCAS.ORG_ID,WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(wnd.delivery_id),1,NULL,1, NULL) record_exists
235: FROM WSH_TRIP_STOPS WTS,
236: WSH_TRIPS WTP,
237: WSH_TRIP_STOPS WTS2,
238: WSH_DELIVERY_LEGS WDL,
239: WSH_NEW_DELIVERIES WND,
240: WSH_LOCATIONS WSHL,
241: WSH_LOCATIONS WSHL2,