APPS.WSH_WSHRDMBL_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      ORGANIZATION_NAME
    INTO L_SHIPPER_NAME
    FROM
      WSH_SHIP_FROM_ORGS_V WSFO,
      WSH_TRIP_STOPS WTS
    WHERE TRIP_ID = P_TRIP_ID
      AND WTS.STOP_LOCATION_ID = WSFO.LOCATION_ID
      AND WTS.STOP_SEQUENCE_NUMBER = (
      SELECT
        MIN(STOP_SEQUENCE_NUMBER)
      FROM
        WSH_TRIP_STOPS
      WHERE TRIP_ID = WTS.TRIP_ID );

Line: 26

        SELECT
          DISTINCT
          ORGANIZATION_NAME
        INTO L_SHIPPER_NAME
        FROM
          WSH_SHIP_FROM_ORGS_V WSFO,
          WSH_TRIP_STOPS WTS,
          WSH_NEW_DELIVERIES WND,
          WSH_DELIVERY_LEGS WDL
        WHERE WTS.TRIP_ID = P_TRIP_ID
          AND WTS.STOP_ID = CF_SHIPPER_NAMEFORMULA.STOP_ID
          AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
          AND WND.DELIVERY_ID = WDL.DELIVERY_ID
          AND WTS.STOP_LOCATION_ID = WSFO.LOCATION_ID
          AND WND.ORGANIZATION_ID = WSFO.ORGANIZATION_ID
          AND WTS.STOP_SEQUENCE_NUMBER = (
          SELECT
            MIN(STOP_SEQUENCE_NUMBER)
          FROM
            WSH_TRIP_STOPS
          WHERE TRIP_ID = WTS.TRIP_ID )
          AND ROWNUM = 1;

Line: 127

    SELECT
      NAME
    INTO L_TRIP_NAME
    FROM
      WSH_TRIPS
    WHERE TRIP_ID = P_TRIP_ID;

Line: 157

      SELECT
        DESCRIPTION
      FROM
        MTL_SYSTEM_ITEMS_VL
      WHERE INVENTORY_ITEM_ID = ID
        AND ORGANIZATION_ID = ORG_ID;

Line: 182

      SELECT
        DESCRIPTION
      FROM
        MTL_SYSTEM_ITEMS_VL
      WHERE INVENTORY_ITEM_ID = ID
        AND ORGANIZATION_ID = ORG_ID;

Line: 207

      SELECT
        MEANING
      INTO L_MODE_MEAN
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = 'WSH_MODE_OF_TRANSPORT'
        AND LOOKUP_CODE = MODE_OF_TRANSPORT;

Line: 226

      SELECT
        MEANING
      INTO L_SERVICE_LEVEL
      FROM
        FND_LOOKUP_VALUES_VL
      WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
        AND LOOKUP_CODE = SERVICE_LEVEL;

Line: 242

    SELECT
      MEANING
    INTO L_TRIP_STATUS
    FROM
      FND_LOOKUP_VALUES_VL
    WHERE LOOKUP_TYPE = 'TRIP_STATUS'
      AND LOOKUP_CODE = TRIP_STATUS;

Line: 255

    SELECT
      MEANING
    INTO L_STOP_STATUS
    FROM
      FND_LOOKUP_VALUES_VL
    WHERE LOOKUP_TYPE = 'TRIP_STOP_STATUS'
      AND LOOKUP_CODE = STOP_STATUS;

Line: 269

      SELECT
        UNIT_OF_MEASURE_TL
      INTO L_WEIGHT_UOM
      FROM
        MTL_UNITS_OF_MEASURE_VL
      WHERE UOM_CODE = WEIGHT_UOM;

Line: 283

      SELECT
        UNIT_OF_MEASURE_TL
      FROM
        MTL_UNITS_OF_MEASURE_VL
      WHERE UOM_CODE = P_VOLUME_UOM_CODE;

Line: 310

    SELECT
      MEANING
    INTO L_STATUS_MEANING
    FROM
      FND_LOOKUP_VALUES_VL
    WHERE LOOKUP_TYPE = 'DELIVERY_STATUS'
      AND LOOKUP_CODE = DELIVERY_STATUS_DP;

Line: 324

      SELECT
        UNIT_OF_MEASURE_TL
      INTO L_WEIGHT_UNIT
      FROM
        MTL_UNITS_OF_MEASURE_VL
      WHERE UOM_CODE = WEIGHT_UOM_DP;

Line: 343

      SELECT
        UNIT_OF_MEASURE_TL
      INTO L_VOLUME_UNIT
      FROM
        MTL_UNITS_OF_MEASURE_VL
      WHERE UOM_CODE = VOLUME_UOM_DP;

Line: 362

      SELECT
        UNIT_OF_MEASURE_TL
      INTO L_VOLUME_UNIT
      FROM
        MTL_UNITS_OF_MEASURE_VL
      WHERE UOM_CODE = VOLUME_UOM_DD;

Line: 381

      SELECT
        UNIT_OF_MEASURE_TL
      INTO L_WEIGHT_UNIT
      FROM
        MTL_UNITS_OF_MEASURE_VL
      WHERE UOM_CODE = WEIGHT_UOM_DD;

Line: 399

    SELECT
      MEANING
    INTO L_STATUS_MEANING
    FROM
      FND_LOOKUP_VALUES_VL
    WHERE LOOKUP_TYPE = 'DELIVERY_STATUS'
      AND LOOKUP_CODE = DELIVERY_STATUS_DD;

Line: 413

      SELECT
        CONCATENATED_SEGMENTS COMM_CLASS
      FROM
        MTL_CATEGORIES_KFV MC,
        MTL_ITEM_CATEGORIES MIC,
        MTL_CATEGORY_SETS_VL MCSTL
      WHERE MIC.INVENTORY_ITEM_ID = C_INV_ITEM_ID
        AND MIC.ORGANIZATION_ID = C_INV_ORG_ID
        AND MIC.CATEGORY_SET_ID = MCSTL.CATEGORY_SET_ID
        AND MC.CATEGORY_ID = MIC.CATEGORY_ID
        AND MCSTL.CATEGORY_SET_NAME = 'WSH_COMMODITY_CODE'
      ORDER BY
        MC.CATEGORY_ID;

Line: 446

      SELECT
        CONCATENATED_SEGMENTS COMM_CLASS
      FROM
        MTL_CATEGORIES_KFV MC,
        MTL_ITEM_CATEGORIES MIC,
        MTL_CATEGORY_SETS_VL MCSTL
      WHERE MIC.INVENTORY_ITEM_ID = C_INV_ITEM_ID
        AND MIC.ORGANIZATION_ID = C_INV_ORG_ID
        AND MIC.CATEGORY_SET_ID = MCSTL.CATEGORY_SET_ID
        AND MC.CATEGORY_ID = MIC.CATEGORY_ID
        AND MCSTL.CATEGORY_SET_NAME = 'WSH_COMMODITY_CODE'
      ORDER BY
        MC.CATEGORY_ID;

Line: 479

      SELECT
        NAME
      INTO L_PARENT_DEL_NAME
      FROM
        WSH_NEW_DELIVERIES
      WHERE DELIVERY_ID in (
        SELECT
          DELIVERY_ID
        FROM
          WSH_DELIVERY_LEGS
        WHERE DELIVERY_LEG_ID in (
          SELECT
            PARENT_DELIVERY_LEG_ID
          FROM
            WSH_DELIVERY_LEGS
          WHERE DELIVERY_LEG_ID = DELIVERY_LEG_ID_DP ) )
        AND ROWNUM = 1;

Line: 507

      SELECT
        NAME
      INTO L_PARENT_DEL_NAME
      FROM
        WSH_NEW_DELIVERIES
      WHERE DELIVERY_ID in (
        SELECT
          DELIVERY_ID
        FROM
          WSH_DELIVERY_LEGS
        WHERE DELIVERY_LEG_ID in (
          SELECT
            PARENT_DELIVERY_LEG_ID
          FROM
            WSH_DELIVERY_LEGS
          WHERE DELIVERY_LEG_ID = DELIVERY_LEG_ID_DD ) )
        AND ROWNUM = 1;

Line: 536

      SELECT
        FV.FREIGHT_TERMS
      INTO L_FREIGHT_TERMS
      FROM
        OE_FRGHT_TERMS_ACTIVE_V FV
      WHERE FV.FREIGHT_TERMS_CODE = CF_FREIGHT_TERMS_DPFORMULA.FREIGHT_TERMS_CODE;

Line: 560

      SELECT
        FV.FREIGHT_TERMS
      INTO L_FREIGHT_TERMS
      FROM
        OE_FRGHT_TERMS_ACTIVE_V FV
      WHERE FV.FREIGHT_TERMS_CODE = FREIGHT_TERMS_DD1;