APPS.ASO_SERVICE_CONTRACTS_INT_W SQL Statements

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

Line: 273

      SELECT   inventory_item_id, inv_master_organization_id
      FROM     csi_item_instances
      WHERE    instance_id=p_source_id;

Line: 279

      SELECT   inventory_item_id, organization_id
      FROM     aso_quote_lines_all
      WHERE    quote_line_id=p_source_id;

Line: 286

     SELECT inventory_item_id
     FROM   oe_order_lines_all
     WHERE  line_id =p_source_id;

Line: 292

     SELECT master_organization_id
     FROM   oe_system_parameters;

Line: 300

     SELECT  msiv.concatenated_segments, msiv.description,
             aql.start_date_active, aqld.service_ref_line_id,
             aqld.service_duration, aqld.service_period
     FROM    aso_quote_lines_all aql,
             aso_quote_line_details aqld, mtl_system_items_vl msiv
     WHERE   aqld.quote_line_id = aql.quote_line_id
     AND     aql.inventory_item_id = msiv.inventory_item_id
     AND     aql.organization_id = msiv.organization_id
     AND     msiv.organization_id=p_orgId
     AND     aqld.service_ref_line_id =p_source_Id;

Line: 313

    SELECT  msiv.concatenated_segments, msiv.description,
            ol.service_start_date, ol.service_duration, ol.service_period
    FROM    oe_order_lines_all ol, mtl_system_items_vl msiv
    WHERE   ol.service_reference_type_code = 'ORDER'
    AND     ol.inventory_item_id = msiv.inventory_item_id
    AND     msiv.organization_id = p_orgId
    AND     ol.service_reference_line_id=p_source_Id ;