APPS.WSH_WSHRDBSR_XMLP_PKG SQL Statements

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

Line: 18

        SELECT
          CP.USER_CONCURRENT_PROGRAM_NAME
        INTO L_REPORT_NAME
        FROM
          FND_CONCURRENT_PROGRAMS_VL CP,
          FND_CONCURRENT_REQUESTS CR
        WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
          AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
          AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;

Line: 69

        SELECT
          ID_FLEX_NUM
        FROM
          FND_ID_FLEX_STRUCTURES
        WHERE ID_FLEX_CODE = FLEX_CODE;

Line: 97

          SELECT
            NAME
          INTO RP_ORDER_TYPE_NAME
          FROM
            OE_TRXT_TYPES_NOORGS_VL
          WHERE TRANSACTION_TYPE_ID = P_TRANSACTION_TYPE_ID;

Line: 132

            SELECT
              ORDER_NUMBER
            INTO L_ORDER_NUM_LOW
            FROM
              OE_ORDER_HEADERS_ALL
            WHERE HEADER_ID = P_HEADER_ID_LOW;

Line: 140

            SELECT
              ORDER_NUMBER
            INTO L_ORDER_NUM_HIGH
            FROM
              OE_ORDER_HEADERS_ALL
            WHERE HEADER_ID = P_HEADER_ID_HIGH;

Line: 157

        SELECT
          MEANING
        INTO ITEM_DISPLAY_MEANING
        FROM
          SO_LOOKUPS
        WHERE LOOKUP_TYPE = 'ITEM_DISPLAY'
          AND LOOKUP_CODE = P_ITEM_DISPLAY;

Line: 173

          SELECT
            NAME
          INTO WAREHOUSE_NAME
          FROM
            HR_ORGANIZATION_UNITS
          WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 196

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

Line: 263

    SELECT
      NAME
    INTO WAREHOUSE_NAME
    FROM
      HR_ORGANIZATION_UNITS
    WHERE ORGANIZATION_ID = ORGANIZATION_ID_V;

Line: 285

      SELECT
        SUM(NVL(SHIPPED_QUANTITY
               ,0))
      INTO SHP_QTY
      FROM
        WSH_DELIVERY_DETAILS
      WHERE ORGANIZATION_ID = ORGANIZATION_ID_V
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
        AND SOURCE_HEADER_NUMBER = SOURCE_HEADER_NUMBER_V
        AND SOURCE_HEADER_TYPE_NAME = ORDER_TYPE
        AND RELEASED_STATUS = 'C'
        AND SOURCE_CODE = 'OE'
        AND REQUESTED_QUANTITY_UOM = REQUESTED_QUANTITY_UOM_V
        AND CURRENCY_CODE = CURRENCY_CODE_V
        AND UNIT_PRICE = UNIT_PRICE_V;

Line: 302

      SELECT
        SUM(NVL(SHIPPED_QUANTITY
               ,0))
      INTO SHP_QTY
      FROM
        WSH_DELIVERY_DETAILS
      WHERE ORGANIZATION_ID = ORGANIZATION_ID_V
        AND INVENTORY_ITEM_ID = INVENTORY_ITEM_ID1
        AND SOURCE_HEADER_NUMBER = SOURCE_HEADER_NUMBER_V
        AND SOURCE_HEADER_TYPE_NAME = ORDER_TYPE
        AND RELEASED_STATUS = 'C'
        AND SOURCE_CODE = 'OE'
        AND REQUESTED_QUANTITY_UOM = REQUESTED_QUANTITY_UOM_V
        AND UNIT_PRICE = UNIT_PRICE_V;

Line: 326

      SELECT
        MAX(WTS.ACTUAL_DEPARTURE_DATE) LAST_SHIPPED_DATE
      FROM
        WSH_DELIVERY_DETAILS WDD,
        WSH_DELIVERY_ASSIGNMENTS_V WDA,
        WSH_DELIVERY_LEGS WDL,
        WSH_TRIP_STOPS WTS
      WHERE WDD.RELEASED_STATUS in ( 'C' , 'I' )
        AND WDD.SOURCE_CODE = 'OE'
        AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
        AND NVL(WDD.LINE_DIRECTION
         ,'O') IN ( 'O' , 'IO' )
        AND WDA.DELIVERY_ID = wdl.delivery_id (+)
        AND WDL.PICK_UP_STOP_ID = wts.stop_id (+)
        AND WDD.ORGANIZATION_ID = P_ORGANIZATION_ID
        AND WDD.SOURCE_HEADER_NUMBER = P_SOURCE_HEADER_NUMBER;