APPS.IBU_ORDER_CAPTURE SQL Statements

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

Line: 79

		select salesrep_id
		from OE_ORDER_HEADERS_ALL
		where header_id = p_header_id;

Line: 84

		select person_id
		from ra_salesreps
		where salesrep_id = p_salesrep_id;

Line: 113

	l_header_cursor_stmt := 'select ord.source_document_id, ord.org_id, ord.source_document_type_id, ord.price_list_id, ord.transactional_curr_code, ord_src.name ';

Line: 331

		l_line_cursor_stmt := 'select org_id, ship_from_org_id, inventory_item_id, order_quantity_uom, price_list_id, unit_list_price, unit_selling_price from oe_order_lines_all where line_id=:v_line_id';

Line: 727

        SELECT  application_id
        FROM    fnd_application_vl
        WHERE   application_short_name = x_short_name;

Line: 732

        SELECT  msg.message_number
        FROM    fnd_new_messages msg, fnd_languages_vl lng
        WHERE   msg.message_name = x_msg
          and   msg.application_id = x_id
          and   lng.LANGUAGE_CODE = msg.language_code
          and   lng.language_id = x_lang_id;

Line: 806

	SELECT LINE_ID, LINE_NUMBER
	FROM ASO_I_OE_ORDER_LINES_V
	WHERE LINE_CATEGORY_CODE = 'RETURN'
	AND HEADER_ID = c_header_id;