APPS.ONT_OEXOEUBD_XMLP_PKG SQL Statements

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

Line: 24

      SELECT
        MEANING
      INTO LP_ORDER_BY_MEAN
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_CODE = UPPER(P_ORDER_BY)
        AND LOOKUP_TYPE = 'ONT_OEXOEUBD_XMLP_PKG SORT BY';

Line: 75

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

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

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

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

      SELECT
        PRECISION
      INTO W_PRECISION
      FROM
        FND_CURRENCIES
      WHERE CURRENCY_CODE = TRANSACTIONAL_CURR_CODE;

Line: 197

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

Line: 299

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

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

  			   MODE="SELECT"
  			   DISPLAY="ALL"
  			   TABLEALIAS="MSI"
  			    ');

Line: 367

      SELECT MEANING
      INTO   l_meaning
      FROM OE_LOOKUPS
      WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
      AND LOOKUP_CODE  = substr(upper(p_print_description),1,1)
      ;