APPS.WSH_DSNO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

    SELECT ece_output_runs_s.nextval
    FROM   dual;

Line: 253

  SELECT
  DECODE(HCAS.ORG_ID,WSH_UTIL_CORE.GET_OPERATINGUNIT_ID(wnd.delivery_id),1,NULL,1, NULL) record_exists
  FROM WSH_TRIP_STOPS        WTS,
    WSH_TRIPS                WTP,
    WSH_TRIP_STOPS           WTS2,
    WSH_DELIVERY_LEGS        WDL,
    WSH_NEW_DELIVERIES       WND,
    WSH_LOCATIONS            WSHL,
    WSH_LOCATIONS            WSHL2,
    HR_ORGANIZATION_UNITS    HOU,
    MTL_PARAMETERS           MTP,
    HZ_PARTY_SITES           HPS,
    HZ_CUST_ACCT_SITES_ALL   HCAS,
    HZ_CUST_SITE_USES_ALL    HCSU,
    ECE_TP_HEADERS           ETH,
    ECE_TP_DETAILS           ETD
  WHERE
     WND.INITIAL_PICKUP_LOCATION_ID = WSHL.WSH_LOCATION_ID AND
/*J Inbound Logistics Changes jckwok*/
     NVL(WND.SHIPMENT_DIRECTION , 'O') IN ('O', 'IO') AND
     WSHL.LOCATION_SOURCE_CODE = 'HR' AND
     HOU.ORGANIZATION_ID = WND.ORGANIZATION_ID AND
     HOU.ORGANIZATION_ID = MTP.ORGANIZATION_ID AND
     WTP.TRIP_ID = WTS.TRIP_ID AND
     WTP.TRIP_ID = WTS2.TRIP_ID AND
     WTS.TRIP_ID = WTS2.TRIP_ID AND
     WND.ULTIMATE_DROPOFF_LOCATION_ID = WTS2.STOP_LOCATION_ID AND
     WND.ULTIMATE_DROPOFF_LOCATION_ID = WSHL2.WSH_LOCATION_ID AND
     WSHL2.LOCATION_SOURCE_CODE = 'HZ' AND
     WSHL2.SOURCE_LOCATION_ID = HPS.LOCATION_ID AND
     NVL(HCAS.ORG_ID, -999) = NVL(HCSU.ORG_ID, -999) AND
     WND.DELIVERY_ID = WDL.DELIVERY_ID AND
     WTS2.STOP_ID = WDL.DROP_OFF_STOP_ID AND
     WDL.PICK_UP_STOP_ID = WTS.STOP_ID AND
     HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID AND
     HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID AND
     HCSU.SITE_USE_CODE = 'SHIP_TO' AND
     HCSU.STATUS = 'A' AND
     ETH.TP_HEADER_ID = HCAS.TP_HEADER_ID AND
     ETD.TP_HEADER_ID = ETH.TP_HEADER_ID AND
     ETD.EDI_FLAG = 'Y' AND
     ETD.DOCUMENT_ID = 'DSNO' AND
     WTS.STOP_ID = c_trip_stop_id
     ORDER BY RECORD_EXISTS;

Line: 355

        WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit RLM_TPA_SV.UPDATECUMKEY',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 358

      rlm_tpa_sv.updatecumkey(
                      p_trip_stop_id,
                      l_return_status);

Line: 529

/*   SELECT COUNT(*)
     INTO l_delivery_count
     FROM WSH_DSNO_DELIVERIES_V
    WHERE PICK_UP_STOP_ID = p_trip_stop_id;