DBA Data[Home] [Help]

APPS.WSH_WSHRDINV_XMLP_PKG dependencies on WSH_CARRIER_SERVICES

Line 251: WSH_CARRIER_SERVICES WCS,

247: FROM
248: WSH_TRIPS T,
249: WSH_TRIP_STOPS ST,
250: WSH_DELIVERY_LEGS DG,
251: WSH_CARRIER_SERVICES WCS,
252: WSH_ORG_CARRIER_SERVICES WOCS
253: WHERE DG.DELIVERY_ID = DELIVERY_ID3
254: AND DG.PICK_UP_STOP_ID = ST.STOP_ID
255: AND ST.TRIP_ID = T.TRIP_ID

Line 265: WSH_CARRIER_SERVICES WCS

261: CURSOR GET_SHIP_METHOD_MEANING IS
262: SELECT
263: WCS.SHIP_METHOD_MEANING
264: FROM
265: WSH_CARRIER_SERVICES WCS
266: WHERE WCS.SHIP_METHOD_CODE = SHIP_VIA;
267: L_SHIP_METHOD VARCHAR2(500) := SHIP_VIA;
268: BEGIN
269: IF NVL(L_SHIP_METHOD