DBA Data[Home] [Help]

APPS.WSH_DSNO dependencies on WSH_TRIPS

Line 256: WSH_TRIPS WTP,

252: cursor c_dsno_deliveries(c_trip_stop_id number ) is
253: SELECT
254: DECODE(HCAS.ORG_ID,WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(wnd.delivery_id),1,NULL,1, NULL) record_exists
255: FROM WSH_TRIP_STOPS WTS,
256: WSH_TRIPS WTP,
257: WSH_TRIP_STOPS WTS2,
258: WSH_DELIVERY_LEGS WDL,
259: WSH_NEW_DELIVERIES WND,
260: WSH_LOCATIONS WSHL,