APPS.CSP_PARTS_REPAIR SQL Statements

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

Line: 45

      SELECT po_requisition_headers_s.nextval
      FROM sys.dual;

Line: 49

      SELECT related_item_id
      FROM mtl_related_items_view
      WHERE relationship_type_id = 18
      AND inventory_item_id = p_item_id;

Line: 71

           select location_id
           into l_order_hdr_Rec.ship_to_location_id
           from hr_organization_units
           where organization_id = p_repair_supplier_id;

Line: 115

           select location_id
           into l_order_hdr_Rec.ship_to_location_id
           from hr_organization_units
           where organization_id = px_header_rec.dest_organization_id;