APPS.ASO_SERVICE_CONTRACTS_INT SQL Statements

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

Line: 32

                select SERVICEABLE_PRODUCT_FLAG
      		from MTL_SYSTEM_ITEMS_B
      		where inventory_item_id = inv1
      		and organization_id = lc_organization_id;

Line: 37

             SELECT b.inventory_item_id,b.organization_id,a.cust_account_id
	     FROM aso_quote_headers_all a,aso_quote_lines_all b
	     WHERE b.quote_line_id = c_qln_id and
	     a.quote_header_id=b.quote_header_id;

Line: 42

            SELECT cust_account_id
	     FROM aso_quote_headers_all
	     WHERE quote_header_id= P_Qte_Line_Rec.quote_header_id;

Line: 47

SELECT  a.inventory_item_id
FROM
CS_CUSTOMER_PRODUCTS_All a, mtl_system_items_kfv b
WHERE  a.inventory_item_id   = b.inventory_item_id
  AND  a.customer_product_id = cs_prd_id
  AND  b.organization_id     = ( SELECT  cs_std.get_item_valdn_orgzn_id  FROM DUAL ) ;

Line: 56

SELECT  a.inventory_item_id
FROM
csi_item_instances a, mtl_system_items_b b
WHERE  a.inventory_item_id   = b.inventory_item_id
  AND  a.instance_id = p_instance_id
  AND  b.organization_id     = cs_org_id ;

Line: 64

	     SELECT  inventory_item_id
             FROM  oe_order_lines_All
	     WHERE  line_id=ord_line_id;

Line: 68

             SELECT cust_account_id
	     FROM aso_quote_headers_all
	     WHERE quote_header_id= Quote_hd_id;

Line: 945

  SELECT description, concatenated_segments
 -- SELECT description, segment1
 -- FROM aso_i_items_v
  FROM mtl_system_items_vl
  WHERE inventory_item_id = item_id
  AND organization_id = p_organization_id;