APPS.ONT_OEXOEOCR_XMLP_PKG SQL Statements

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

Line: 22

          SELECT
            CONCATENATED_SEGMENTS
          INTO P_ITEM_NAME
          FROM
            MTL_SYSTEM_ITEMS_KFV
          WHERE INVENTORY_ITEM_ID = P_ITEM
            AND CUSTOMER_ORDER_ENABLED_FLAG = 'Y'
            AND BOM_ITEM_TYPE in ( 1 , 4 )
            AND ORGANIZATION_ID = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');

Line: 37

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

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

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

Line: 305

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

Line: 325

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

Line: 344

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

Line: 408

          SELECT
            C_GL_CONV_RATE * CALC_AMOUNT
          INTO ORDER_AMOUNT
          FROM
            DUAL;

Line: 446

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

Line: 469

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

Line: 506

      SELECT
        COUNT(1)
      INTO HIST_LINES
      FROM
        OE_ORDER_LINES_HISTORY
      WHERE LINE_ID = LINEID
        AND HIST_TYPE_CODE = 'CANCELLATION';

Line: 514

        SELECT
          CANCELLED_QUANTITY
        INTO CAN_QTY_1
        FROM
          OE_ORDER_LINES_ALL
        WHERE LINE_ID = LINEID;

Line: 522

        SELECT
          MAX(ORDERED_QUANTITY),
          MAX(CANCELLED_QUANTITY)
        INTO ORD_QTY_MAX,CAN_QTY_MAX
        FROM
          OE_ORDER_LINES_HISTORY
        WHERE LINE_ID = LINEID
          AND HIST_TYPE_CODE = 'CANCELLATION';

Line: 531

          SELECT
            ( CANCELLED_QUANTITY - CAN_QTY_MAX )
          INTO CAN_QTY_FINAL1
          FROM
            OE_ORDER_LINES_ALL
          WHERE LINE_ID = LINEID;

Line: 539

          SELECT
            MIN(CANCELLED_QUANTITY)
          INTO CAN_QTY_FINAL2
          FROM
            OE_ORDER_LINES_HISTORY
          WHERE LINE_ID = LINEID
            AND CANCELLED_QUANTITY > CANCELLED_QTY
            AND HIST_TYPE_CODE = 'CANCELLATION';

Line: 568

      SELECT
        COUNT(1)
      INTO HIST_LINES
      FROM
        OE_ORDER_LINES_HISTORY
      WHERE LINE_ID = LINEID
        AND HIST_TYPE_CODE = 'CANCELLATION';

Line: 576

        SELECT
          CANCELLED_QUANTITY,
          UNIT_SELLING_PRICE
        INTO CAN_QTY_1,UNIT_SELLING_PRICE_VAR
        FROM
          OE_ORDER_LINES_ALL
        WHERE LINE_ID = LINEID;

Line: 585

        SELECT
          MAX(ORDERED_QUANTITY),
          MAX(CANCELLED_QUANTITY)
        INTO ORD_QTY_MAX,CAN_QTY_MAX
        FROM
          OE_ORDER_LINES_HISTORY
        WHERE LINE_ID = LINEID
          AND HIST_TYPE_CODE = 'CANCELLATION';

Line: 594

          SELECT
            ( CANCELLED_QUANTITY - CAN_QTY_MAX ),
            UNIT_SELLING_PRICE
          INTO CAN_QTY_FINAL1,UNIT_SELLING_PRICE_VAR
          FROM
            OE_ORDER_LINES_ALL
          WHERE LINE_ID = LINEID;

Line: 603

          SELECT
            MIN(CANCELLED_QUANTITY)
          INTO CAN_QTY_FINAL2
          FROM
            OE_ORDER_LINES_HISTORY
          WHERE LINE_ID = LINEID
            AND CANCELLED_QUANTITY > CANCELLED_QTY
            AND HIST_TYPE_CODE = 'CANCELLATION';

Line: 611

          SELECT
            DISTINCT
            UNIT_SELLING_PRICE
          INTO UNIT_SELLING_PRICE_VAR
          FROM
            OE_ORDER_LINES_HISTORY
          WHERE LINE_ID = LINEID
            AND CANCELLED_QUANTITY = CAN_QTY_FINAL2
            AND HIST_TYPE_CODE = 'CANCELLATION';

Line: 634

      SELECT
        PRECISION
      INTO W_PRECISION
      FROM
        FND_CURRENCIES CUR
      WHERE CUR.CURRENCY_CODE = C_PRECISIONFORMULA.CURRENCY_CODE;

Line: 985

    select sitems.description description
    into   v_description
    from   mtl_system_items_vl sitems
    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 = IID;

Line: 1006

    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) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
    and    sitems.inventory_item_id = IID;

Line: 1019

    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_T
    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 = IID
    and   items.org_independent_flag = 'N'
    and   items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);

Line: 1034

    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_T
    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 = IID
    and items.org_independent_flag ='Y';