APPS.OE_INSTALL_BASE_UTIL SQL Statements

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

Line: 11

    SELECT oel.IB_OWNER,
           oel.IB_INSTALLED_AT_LOCATION,
           oel.IB_CURRENT_LOCATION,
           nvl(oel.END_CUSTOMER_ID,oeh.END_CUSTOMER_ID),
           nvl(oel.END_CUSTOMER_CONTACT_ID,oeh.END_CUSTOMER_CONTACT_ID),
           nvl(oel.END_CUSTOMER_SITE_USE_ID,oeh.END_CUSTOMER_SITE_USE_ID),
           oeh.sold_to_site_use_id
    INTO   x_partner_order_rec.IB_OWNER,
           x_partner_order_rec.IB_INSTALLED_AT_LOCATION,
           x_partner_order_rec.IB_CURRENT_LOCATION,
           x_partner_order_rec.END_CUSTOMER_ID,
           x_partner_order_rec.END_CUSTOMER_CONTACT_ID,
           x_partner_order_rec.END_CUSTOMER_SITE_USE_ID,
           x_partner_order_rec.SOLD_TO_SITE_USE_ID
    FROM   oe_order_lines_all oel,
           oe_order_headers_all oeh
    WHERE  oel.line_id = p_order_line_id
    AND    oeh.header_id = oel.header_id;

Line: 32

  PROCEDURE return_selected_instances(
    l_returned_inst_tbl IN  csi_datastructures_pub.instance_cz_tbl)
  IS
  BEGIN

    g_returned_inst_tbl := l_returned_inst_tbl;

Line: 39

  END return_selected_instances;