APPS.ONT_OEXOEITR_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: 60

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

Line: 80

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

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

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

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

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

          SELECT
            MEANING
          INTO MEANING
          FROM
            FND_LOOKUPS
          WHERE LOOKUP_TYPE = 'YES_NO'
            AND LOOKUP_CODE = P_OPENONLY;

Line: 288

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

Line: 312

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

Line: 342

    SELECT
      NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
                                 ,MO_GLOBAL.GET_CURRENT_ORG_ID)
         ,0)
    INTO V_MASTER_ORG
    FROM
      DUAL;

Line: 357

      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;

Line: 493

    select sitems.description description
    into   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) = c_master_org
    and    sitems.inventory_item_id = inventory_item_id_T;

Line: 514

    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
    and    nvl(sitems.organization_id,0) = c_master_org
    and    sitems.inventory_item_id = inventory_item_id_T;

Line: 529

    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
    and    items.cross_reference_type = item_identifier_type
    and    nvl(sitems.organization_id,0) = c_master_org
    and    sitems.inventory_item_id = inventory_item_id_T
    -- Bug 3433353 Start
    and    items.org_independent_flag = 'N'
    and    items.organization_id = c_master_org;

Line: 547

     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
     and items.cross_reference_type = item_identifier_type
     and nvl(sitems.organization_id,0) = c_master_org
     and sitems.inventory_item_id = inventory_item_id_T
     and items.org_independent_flag = 'Y';