APPS.WSH_DELIVERY_SPLITTER_PKG SQL Statements

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

Line: 254

    SELECT decode(WDD.WEIGHT_UOM_CODE,
                  p_uom, WDD.GROSS_WEIGHT,
                  WSH_WV_UTILS.convert_uom(
                                wdd.weight_uom_code,
                                p_uom,
                                WDD.GROSS_WEIGHT)) gross_weight_converted,
           WDA.DELIVERY_DETAIL_ID
    FROM   WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA
    WHERE  WDA.DELIVERY_ID = p_delivery_id
    AND    wda.delivery_detail_id = wdd.delivery_detail_id
    AND    WDA.PARENT_DELIVERY_DETAIL_ID IS NULL
    AND    WDD.WEIGHT_UOM_CODE IS NOT NULL
    AND    WDD.GROSS_WEIGHT <> 0
    ORDER BY gross_weight_converted ASC;

Line: 271

    SELECT WDD.RELEASED_STATUS
    FROM   WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA
    WHERE  WDA.DELIVERY_ID = p_delivery_id
    AND    WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
    AND    WDD.CONTAINER_FLAG = 'N'
    AND    WDD.RELEASED_STATUS NOT IN ('R', 'B', 'X');

Line: 280

    SELECT 1
    FROM WSH_DELIVERY_LEGS
    WHERE delivery_id = p_delivery_id
    AND rownum = 1;

Line: 458

          l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED OR
          l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS ) THEN


        IF l_debug_on THEN
          wsh_debug_sv.logmsg(l_module_name, 'accepted delivery ' || p_delivery_tab(i).entity_id || ' because ignore for planning, DR or DP status');

Line: 673

        l_line_and_container_weight.DELETE;

Line: 674

        l_line_and_container_id.DELETE;

Line: 928

      l_line_status.DELETE;

Line: 988

          l_temp_ids.DELETE;

Line: 1055

          l_current_ids.DELETE;

Line: 1071

              l_temp_ids.DELETE;

Line: 1175

              l_current_ids.DELETE;

Line: 1185

          l_temp_ids.DELETE;

Line: 1373

          l_curr_del_split_list.DELETE;

Line: 1374

          l_curr_del_split_name.DELETE;

Line: 1375

          l_current_ids.DELETE;  --remove current autocreate ids