DBA Data[Home] [Help]

APPS.WSH_WSHRDINV_XMLP_PKG dependencies on WSH_CARRIER_SERVICES

Line 265: WSH_CARRIER_SERVICES WCS,

261: FROM
262: WSH_TRIPS T,
263: WSH_TRIP_STOPS ST,
264: WSH_DELIVERY_LEGS DG,
265: WSH_CARRIER_SERVICES WCS,
266: WSH_ORG_CARRIER_SERVICES WOCS
267: WHERE DG.DELIVERY_ID = DELIVERY_ID3
268: AND DG.PICK_UP_STOP_ID = ST.STOP_ID
269: AND ST.TRIP_ID = T.TRIP_ID

Line 279: WSH_CARRIER_SERVICES WCS

275: CURSOR GET_SHIP_METHOD_MEANING IS
276: SELECT
277: WCS.SHIP_METHOD_MEANING
278: FROM
279: WSH_CARRIER_SERVICES WCS
280: WHERE WCS.SHIP_METHOD_CODE = SHIP_VIA;
281: L_SHIP_METHOD VARCHAR2(500) := SHIP_VIA;
282: BEGIN
283: IF NVL(L_SHIP_METHOD