APPS.ONT_OEXOEOSR_XMLP_PKG SQL Statements

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

Line: 27

        SELECT
          SOB.NAME,
          SOB.CURRENCY_CODE
        INTO L_COMPANY_NAME,L_FUNCTIONAL_CURRENCY
        FROM
          GL_SETS_OF_BOOKS SOB,
          FND_CURRENCIES CUR
        WHERE SOB.SET_OF_BOOKS_ID = P_SOB_ID
          AND SOB.CURRENCY_CODE = CUR.CURRENCY_CODE;

Line: 45

        SELECT
          NAME
        INTO L_ORDER_SOURCE_NAME
        FROM
          OE_ORDER_SOURCES
        WHERE ORDER_SOURCE_ID = NVL(P_ORDER_SOURCE
           ,-999);

Line: 60

        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: 264

            SELECT
              NAME
            INTO L_AGREEMENT_NAME
            FROM
              OE_AGREEMENTS
            WHERE AGREEMENT_ID = P_AGREEMENT;

Line: 282

        SELECT
          MEANING
        INTO L_MEANING
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
          AND LOOKUP_CODE = SUBSTR(UPPER(P_OPEN_ORDERS_ONLY)
              ,1
              ,1);

Line: 304

          SELECT
            MEANING
          INTO ORDER_BY
          FROM
            OE_LOOKUPS
          WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
            AND LOOKUP_CODE = L_LOOKUP_CODE;

Line: 345

          SELECT
            OEOT.NAME
          INTO L_ORDER_TYPE_LOW
          FROM
            OE_TRANSACTION_TYPES_TL OEOT
          WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
            AND OEOT.LANGUAGE = USERENV('LANG');

Line: 354

          SELECT
            OEOT.NAME
          INTO L_ORDER_TYPE_LOW
          FROM
            OE_TRANSACTION_TYPES_TL OEOT
          WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
            AND OEOT.LANGUAGE = USERENV('LANG');

Line: 361

          SELECT
            OEOT.NAME
          INTO L_ORDER_TYPE_HIGH
          FROM
            OE_TRANSACTION_TYPES_TL OEOT
          WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
            AND OEOT.LANGUAGE = USERENV('LANG');

Line: 371

        SELECT
          OEOT.NAME
        INTO L_ORDER_TYPE_LOW
        FROM
          OE_TRANSACTION_TYPES_TL OEOT
        WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_LOW
          AND OEOT.LANGUAGE = USERENV('LANG');

Line: 380

        SELECT
          OEOT.NAME
        INTO L_ORDER_TYPE_HIGH
        FROM
          OE_TRANSACTION_TYPES_TL OEOT
        WHERE OEOT.TRANSACTION_TYPE_ID = P_ORDER_TYPE_HIGH
          AND OEOT.LANGUAGE = USERENV('LANG');

Line: 500

      SELECT
        COUNT(1)
      INTO L_COUNT
      FROM
        OE_ORDER_LINES_ALL L
      WHERE L.HEADER_ID = HEADER_ID1;

Line: 520

      SELECT
        MEANING
      INTO L_TEMP
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_CODE = L_LOOKUP_CODE
        AND LOOKUP_TYPE = L_LOOKUP_TYPE;

Line: 676

      SELECT
        UNIT_OF_MEASURE
      INTO L_CHARGE_PERIODICITY
      FROM
        MTL_UNITS_OF_MEASURE_VL
      WHERE UOM_CLASS = L_UOM_CLASS
        AND UOM_CODE = CHARGE_PERIODICITY_CODE;