APPS.ONT_OEXIODIS_XMLP_PKG SQL Statements

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

Line: 24

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

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

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

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

        SELECT
          NAME
        INTO L_COMPANY_NAME
        FROM
          GL_SETS_OF_BOOKS
        WHERE SET_OF_BOOKS_ID = P_SOB_ID;

Line: 134

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

        SELECT
          MEANING
        INTO ITEM_DISPLAY_MEANING
        FROM
          OE_LOOKUPS
        WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
          AND LOOKUP_CODE = P_PRINT_DESCRIPTION;

Line: 224

        SELECT
          MEANING
        INTO OPEN_ORDER_ONLY
        FROM
          OE_LOOKUPS
        WHERE LOOKUP_TYPE = 'YES_NO'
          AND LOOKUP_CODE = P_OPEN_ORDER_ONLY;

Line: 239

        SELECT
          MEANING
        INTO ORDER_BY
        FROM
          OE_LOOKUPS
        WHERE LOOKUP_TYPE = 'OEXIODIS ORDER BY'
          AND LOOKUP_CODE = P_ORDER_BY;

Line: 265

      SELECT
        COUNT(ORDER_HOLD_ID)
      INTO L_NUM_HOLD
      FROM
        OE_ORDER_HOLDS_ALL
      WHERE HEADER_ID = OM_HEADER_ID
        AND HOLD_RELEASE_ID is null
        AND ( LINE_ID = OM_LINE_ID
      OR LINE_ID is null );

Line: 275

        SELECT
          MEANING
        INTO L_MEANING
        FROM
          OE_LOOKUPS
        WHERE LOOKUP_TYPE = 'YES_NO'
          AND LOOKUP_CODE = 'N';

Line: 283

        SELECT
          MEANING
        INTO L_MEANING
        FROM
          OE_LOOKUPS
        WHERE LOOKUP_TYPE = 'YES_NO'
          AND LOOKUP_CODE = 'Y';

Line: 434

    select sitems.description description
    into   v_description
    from   mtl_system_items_vl sitems
    --where  sitems.customer_order_enabled_flag = 'Y'
    where    sitems.bom_item_type in (1,4)
    and    nvl(sitems.organization_id,0) = RP_DUMMY_ITEM
    and    sitems.inventory_item_id = item_dspFormula.inventory_item_id;

Line: 457

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

Line: 471

    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 = item_dspFormula.ordered_item
    and    items.cross_reference_type = item_dspFormula.item_identifier_type
    and    nvl(sitems.organization_id,0) = RP_DUMMY_ITEM
    and    sitems.inventory_item_id = item_dspFormula.inventory_item_id;