APPS.WSH_WSHRDSDL_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: 33

        SELECT
          ORGANIZATION_NAME
        INTO REPORT_SHIP_FROM
        FROM
          ORG_ORGANIZATION_DEFINITIONS
        WHERE ORGANIZATION_ID = P_SHIP_FROM_ORG_ID;

Line: 41

        SELECT
          SOURCE_TYPE_NAME
        INTO REPORT_ORDER_TYPE
        FROM
          WSH_SOURCE_TYPES_V
        WHERE SOURCE_TYPE_ID = P_ORDER_TYPE;

Line: 56

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

Line: 88

      SELECT
        MEANING
      INTO REPORT_SORT_BY_1
      FROM
        WSH_LOOKUPS
      WHERE LOOKUP_TYPE = 'WSH_ORDER_BY'
        AND LOOKUP_CODE = P_ORDER_BY_1;

Line: 95

      SELECT
        MEANING
      INTO REPORT_SORT_BY_2
      FROM
        WSH_LOOKUPS
      WHERE LOOKUP_TYPE = 'WSH_ORDER_BY'
        AND LOOKUP_CODE = P_ORDER_BY_2;

Line: 102

      SELECT
        MEANING
      INTO REPORT_SORT_BY_3
      FROM
        WSH_LOOKUPS
      WHERE LOOKUP_TYPE = 'WSH_ORDER_BY'
        AND LOOKUP_CODE = P_ORDER_BY_3;

Line: 121

        SELECT
          ID_FLEX_NUM
        FROM
          FND_ID_FLEX_STRUCTURES
        WHERE ID_FLEX_CODE = FLEX_CODE;

Line: 163

          LP_TABLE_NAME := '( select /*+ leading(wts) cardinality(wts,3)*/ * from wsh_trip_stops wts ) WTS';

Line: 192

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

Line: 207

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

Line: 309

        SELECT
          SUM(NVL(PICKED_QUANTITY
                 ,0))
        FROM
          WSH_DELIVERY_DETAILS
        START WITH DELIVERY_DETAIL_ID = P_DETAIL_ID
        CONNECT BY prior DELIVERY_DETAIL_ID = SPLIT_FROM_DELIVERY_DETAIL_ID
          AND SOURCE_HEADER_ID = P_SOURCE_HEADER_ID
          AND RELEASED_STATUS = 'Y';

Line: 332

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

Line: 369

      SELECT
        ORGANIZATION_NAME
      INTO ORG_NAME
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = SHIP_FROM_ORGANIZATION;

Line: 383

      SELECT
        TO_CHAR(ACTUAL_DEPARTURE_DATE
               ,'DD-MON-RRRR')
      FROM
        WSH_TRIP_STOPS WTS
      WHERE WTS.STOP_ID = STOP_ID_1;