APPS.ONT_OEXOESOS_XMLP_PKG SQL Statements

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

Line: 14

    select sitems.concatenated_segments item,
    	   sitems.description description
    into   v_item,v_description
    from   mtl_system_items_vl sitems
--    where  sitems.customer_order_enabled_flag = 'Y'
--    and    sitems.bom_item_type in (1,4)
    where    nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
    and    sitems.inventory_item_id = inventory_item_id_L;

Line: 35

    select citems.customer_item_number item,
    	   nvl(citems.customer_item_desc,sitems.description) description
    into   v_item,v_description
    from   mtl_customer_items citems,
           mtl_customer_item_xrefs cxref,
           mtl_system_items_vl sitems
    where  citems.customer_item_id = cxref.customer_item_id
    and    cxref.inventory_item_id = sitems.inventory_item_id
    and    citems.customer_item_id = ordered_item_id_L
    and    nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
    and    sitems.inventory_item_id = inventory_item_id_L;

Line: 49

    select items.cross_reference item,
    	   nvl(items.description,sitems.description) description
    into   v_item,v_description
    from   mtl_cross_reference_types xtypes,
           mtl_cross_references items,
           mtl_system_items_vl sitems
    where  xtypes.cross_reference_type = items.cross_reference_type
    and    items.inventory_item_id = sitems.inventory_item_id
    and    items.cross_reference = ordered_item_L
    and    items.cross_reference_type = item_identifier_type_L
    and    nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
    and    sitems.inventory_item_id = inventory_item_id_L;

Line: 113

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

			   MODE="SELECT"
			   DISPLAY="ALL"
			   TABLEALIAS="SI"');*/

Line: 159

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

      SELECT NAME
      INTO L_AGREEMENT_NAME
      FROM OE_AGREEMENTS
      WHERE AGREEMENT_ID = P_AGREEMENT;

Line: 255

      SELECT
        USERENV('LANG')
      INTO P_LANG
      FROM
        DUAL;

Line: 310

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

Line: 332

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

Line: 419

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

Line: 439

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

Line: 457

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

Line: 474

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

Line: 535

          SELECT
            C_GL_CONV_RATE * EXTENDED_PRICE
          INTO AMOUNT
          FROM
            DUAL;

Line: 576

        SELECT
          ( ( S_LISTP_CURR - 2 * S_LISTP_CURR_RMA ) - ( S_SELLP_CURR - 2 * S_SELLP_CURR_RMA ) ) / ( S_LISTP_CURR - 2 * S_LISTP_CURR_RMA ) * 100
        INTO DISCOUNT
        FROM
          DUAL;

Line: 602

        SELECT
          ( ( S_LISTP_SR - 2 * S_LISTP_SR_RMA ) - ( S_SELLP_SR - 2 * S_SELLP_SR_RMA ) ) / ( S_LISTP_SR - 2 * S_LISTP_SR_RMA ) * 100
        INTO DISCOUNT
        FROM
          DUAL;

Line: 624

        SELECT
          ( S_LISTP_CUST - S_SELLP_CUST ) / S_LISTP_CUST * 100
        INTO DISCOUNT
        FROM
          DUAL;

Line: 647

          SELECT
            C_GL_CONV_RATE * SALE_PRICE
          INTO AMOUNT
          FROM
            DUAL;

Line: 672

        SELECT
          ( S_LISTP_ORDER - S_SELLP_ORDER ) / S_LISTP_ORDER * 100
        INTO DISCOUNT
        FROM
          DUAL;

Line: 698

      SELECT
        ( S_PRICE_CURR - 2 * S_PRICE_CURR_RMA )
      INTO TOTAL_NET
      FROM
        DUAL;

Line: 715

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

Line: 737

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

Line: 757

      SELECT
        count(SC.LINE_ID)
      INTO LINE_NUM
      FROM
        OE_SALES_CREDITS SC
      WHERE SC.HEADER_ID = C_COUNT_LINEFORMULA.HEADER_ID;

Line: 782

        SELECT
          count(SC.SALESREP_ID)
        INTO SALESREP_NUM
        FROM
          OE_SALES_CREDITS SC
        WHERE SC.HEADER_ID = C_COUNT_SALESREPFORMULA.HEADER_ID;

Line: 806

      SELECT
        ( C_SALESREP_TOTAL - 2 * C_SALESREP_TOTAL_RMA )
      INTO TOTAL_NET
      FROM
        DUAL;

Line: 820

      SELECT
        UNIT_OF_MEASURE
      INTO L_CHARGE_PERIODICITY
      FROM
        MTL_UNITS_OF_MEASURE_VL
      WHERE UOM_CODE = CHARGE_PERIODICITY_CODE
        AND UOM_CLASS = FND_PROFILE.VALUE('ONT_UOM_CLASS_CHARGE_PERIODICITY');

Line: 846

        SELECT
          ( S_LISTP_PERIODICITY - S_SELLP_PERIODICITY ) / S_LISTP_PERIODICITY * 100
        INTO DISCOUNT
        FROM
          DUAL;