APPS.ONT_OEXOEORS_XMLP_PKG SQL Statements

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

Line: 42

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

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

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

Line: 216

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

Line: 231

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

Line: 246

     select meaning
       into l_fc_display
       from oe_lookups
      where lookup_type='YES_NO'
	and lookup_code = p_use_functional_currency
	;

Line: 350

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

Line: 360

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

Line: 429

      SELECT
        MEANING
      INTO L_SORT_BY
      FROM
        OE_LOOKUPS
      WHERE LOOKUP_CODE = P_ORDER_BY
        AND LOOKUP_TYPE = 'OEXOEORS SORT BY';

Line: 731

    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)
    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_id1;

Line: 745

    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 = inventory_item_id1;

Line: 760

    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) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
    and    sitems.inventory_item_id = inventory_item_id1
    -- Bug 3433353 Begin
    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: 778

    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) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)
    and sitems.inventory_item_id = inventory_item_id1
    and items.org_independent_flag = 'Y';