APPS.WSH_WSHRDSDL_XMLP_PKG dependencies on WSH_TRIP_STOPS

Line 163: LP_TABLE_NAME := '( select /*+ leading(wts) cardinality(wts,3)*/ * from wsh_trip_stops wts ) WTS';

159: IF (P_ITEM IS NOT NULL) THEN
160: LP_ITEM := ' AND WDD.INVENTORY_ITEM_ID = :P_ITEM ';
161: END IF;
162: IF (P_SHIP_DATE_LOW IS NOT NULL AND P_SHIP_DATE_HIGH IS NOT NULL AND P_ORDER_NUMBER_LOW IS NULL AND P_CUSTOMER_NAME_LOW IS NULL) THEN
163: LP_TABLE_NAME := '( select /*+ leading(wts) cardinality(wts,3)*/ * from wsh_trip_stops wts ) WTS';
164: ELSE
165: LP_TABLE_NAME := 'WSH_TRIP_STOPS WTS';
166: END IF;
167: LP_WHERE_CLAUSE := ' AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID ';

Line 165: LP_TABLE_NAME := 'WSH_TRIP_STOPS WTS';

161: END IF;
162: IF (P_SHIP_DATE_LOW IS NOT NULL AND P_SHIP_DATE_HIGH IS NOT NULL AND P_ORDER_NUMBER_LOW IS NULL AND P_CUSTOMER_NAME_LOW IS NULL) THEN
163: LP_TABLE_NAME := '( select /*+ leading(wts) cardinality(wts,3)*/ * from wsh_trip_stops wts ) WTS';
164: ELSE
165: LP_TABLE_NAME := 'WSH_TRIP_STOPS WTS';
166: END IF;
167: LP_WHERE_CLAUSE := ' AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID ';
168: LP_WHERE_CLAUSE := LP_WHERE_CLAUSE || ' AND WTS.TRIP_ID = WT.TRIP_ID ';
169: LP_WHERE_CLAUSE := LP_WHERE_CLAUSE || ' AND WTS.STOP_LOCATION_ID = WDD.SHIP_FROM_LOCATION_ID ';

Line 421: WSH_TRIP_STOPS WTS

417: SELECT
418: TO_CHAR(ACTUAL_DEPARTURE_DATE
419: ,'DD-MON-RRRR')
420: FROM
421: WSH_TRIP_STOPS WTS
422: WHERE WTS.STOP_ID = STOP_ID_1;
423: L_DEP_DATE VARCHAR2(20);
424: BEGIN
425: OPEN C_DEP_DATE;