APPS.WSH_WSHRDBDR_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: 63

        SELECT
          ID_FLEX_NUM
        FROM
          FND_ID_FLEX_STRUCTURES
        WHERE ID_FLEX_CODE = FLEX_CODE;

Line: 128

        SELECT
          NAME
        INTO RP_ORDER_TYPE_NAME
        FROM
          OE_TRXT_TYPES_NOORGS_VL
        WHERE TRANSACTION_TYPE_ID = P_TRANSACTION_TYPE_ID;

Line: 145

          SELECT meaning
            INTO rp_sort_by
            FROM fnd_lookup_values_vl
            --Bug 14133213 modified the looktype to get the value of sortby
           WHERE lookup_type = 'WSH_WSHRDBDR_SORT_BY'
             AND enabled_flag = 'Y'
             AND lookup_code = P_SORT_BY;

Line: 159

          SELECT
            SUBSTRB(PARTY.PARTY_NAME
                   ,1
                   ,50)
          INTO RP_CUSTOMER
          FROM
            HZ_PARTIES PARTY,
            HZ_CUST_ACCOUNTS CUST_ACCT
          WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
            AND CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER_ID;

Line: 179

          SELECT
            USER_NAME
          INTO RP_USER
          FROM
            FND_USER
          WHERE USER_ID = P_CREATED_BY_ID;

Line: 195

          SELECT
            TERRITORY_SHORT_NAME
          INTO RP_TERRITORY_CODE
          FROM
            FND_TERRITORIES_VL
          WHERE TERRITORY_CODE = P_SHIP_TO_COUNTRY_CODE;

Line: 232

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

Line: 248

        SELECT
          SUBSTR(DESCRIPTION
                ,1
                ,40)
        INTO CATEGORY_SET
        FROM
          MTL_CATEGORY_SETS
        WHERE CATEGORY_SET_ID = P_ITEM_CATE_SET_ID;

Line: 266

        SELECT
          SUBSTR(DESCRIPTION
                ,1
                ,40)
        INTO CATEGORY
        FROM
          MTL_CATEGORIES
        WHERE CATEGORY_ID = P_ITEM_CATEGORY_ID;

Line: 284

        SELECT
          NAME
        INTO WAREHOUSE_NAME
        FROM
          HR_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 303

      SELECT
        MEANING
      INTO SCODE
      FROM
        WSH_LOOKUPS
      WHERE LOOKUP_CODE = P_SOURCE_SYSTEM
        AND LOOKUP_TYPE = 'SOURCE_SYSTEM';

Line: 325

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

Line: 372

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

Line: 425

          SELECT
            SUM(NVL(SHIPPED_QUANTITY
                   ,0))
          INTO L_SHIPPED_QTY
          FROM
            WSH_DELIVERY_DETAILS
          WHERE SOURCE_HEADER_ID = CF_LINE_SHIPPED_QTYFORMULA.SOURCE_HEADER_ID
            AND SOURCE_LINE_SET_ID = CF_LINE_SHIPPED_QTYFORMULA.SOURCE_LINE_SET_ID
            AND RELEASED_STATUS = 'C'
            AND SOURCE_CODE = P_SOURCE_SYSTEM
          GROUP BY
            SOURCE_LINE_SET_ID;

Line: 439

            SELECT
              SUM(NVL(SHIPPED_QUANTITY
                     ,0))
            INTO L_SHIPPED_QTY
            FROM
              WSH_DELIVERY_DETAILS WDD
            WHERE SOURCE_LINE_ID = CF_LINE_SHIPPED_QTYFORMULA.SOURCE_LINE_SET_ID
              AND RELEASED_STATUS = 'C'
              AND SOURCE_CODE = P_SOURCE_SYSTEM
            GROUP BY
              SOURCE_LINE_ID;

Line: 468

      SELECT
        OL.UNIT_SELLING_PRICE
      INTO SPRICE
      FROM
        OE_ORDER_LINES_ALL OL
      WHERE OL.LINE_ID = CF_SELLING_PRICEFORMULA.SOURCE_LINE_ID;

Line: 493

          SELECT
            SUM(NVL(REQUESTED_QUANTITY
                   ,0))
          INTO BO_QTY
          FROM
            WSH_DELIVERY_DETAILS
          WHERE SOURCE_HEADER_ID = CF_LINE_BO_QTYFORMULA.SOURCE_HEADER_ID
            AND SOURCE_LINE_SET_ID = CF_LINE_BO_QTYFORMULA.SOURCE_LINE_SET_ID
            AND RELEASED_STATUS = 'B'
	    AND   replenishment_status IS NULL -- bug#6689448 (replenishment project)
            AND SOURCE_CODE = P_SOURCE_SYSTEM
          GROUP BY
            SOURCE_LINE_SET_ID;

Line: 508

            SELECT
              SUM(NVL(REQUESTED_QUANTITY
                     ,0))
            INTO BO_QTY
            FROM
              WSH_DELIVERY_DETAILS
            WHERE SOURCE_LINE_ID = CF_LINE_BO_QTYFORMULA.SOURCE_LINE_SET_ID
              AND RELEASED_STATUS = 'B'
              AND   replenishment_status IS NULL -- bug#6689448 (replenishment project)
              AND SOURCE_CODE = P_SOURCE_SYSTEM;

Line: 568

            SELECT
              SUM(NVL(ORDERED_QUANTITY
                     ,0))
            INTO LINE_SET_ORD_QTY
            FROM
              OE_ORDER_LINES_ALL
            WHERE LINE_SET_ID = SOURCE_LINE_SET_ID
            GROUP BY
              LINE_SET_ID;

Line: 579

              SELECT
                SUM(NVL(ORDERED_QUANTITY
                       ,0))
              INTO LINE_SET_ORD_QTY
              FROM
                OE_ORDER_LINES_ALL
              WHERE LINE_ID = SOURCE_LINE_SET_ID;

Line: 602

      SELECT
        OL.PROMISE_DATE
      INTO PDATE
      FROM
        OE_ORDER_LINES_ALL OL
      WHERE OL.LINE_ID = SOURCE_LINE_ID;

Line: 625

    SELECT
      MEANING
    INTO SCODE
    FROM
      WSH_LOOKUPS
    WHERE LOOKUP_CODE = CF_SOURCE_CODEFORMULA.SOURCE_CODE
      AND LOOKUP_TYPE = 'SOURCE_SYSTEM';

Line: 638

    SELECT
      count(distinct( LINES.ORDER_QUANTITY_UOM ))
    INTO UOM_COUNT
    FROM
      OE_ORDER_LINES_ALL LINES,
      OE_ORDER_HEADERS_ALL HEAD
    WHERE LINES.HEADER_ID = HEAD.HEADER_ID
      AND HEAD.ORDER_NUMBER = CF_DISTINCT_UOMFORMULA.ORDER_NUMBER;