<?xml version="1.0" encoding="utf-8"?>
<AisMenuItem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/AisMenuItem.xsd">
	<Action>stat</Action>
	<SecondAction></SecondAction>
	<Ico></Ico>
  <Label>
    <L1>Products - fleet - list</L1>
    <L2>Produits - flottes - liste</L2>
  </Label>
  <Description>
    <L1>Fleets list</L1>
    <L2>Liste des flottes automobile</L2>
  </Description>
  <Stat>
    <FileMajorVersion>1</FileMajorVersion>
    <FileMinorVersion>0</FileMinorVersion>
    <Parameters>
      <Parameter>
        <Name>policy</Name>
        <Type>string</Type>
        <Label>
          <L1>Policy</L1>
          <L2>Police</L2>
        </Label>
      </Parameter>
    </Parameters>
    <SQL>
			select
	[Client] = adr_complete_name
	,[Référence externe] = act_external_reference
	,[Police] = pols_number
	,[Risque] = riss_number
	,[Date de mouvement] = pols_mvt_date
	,[Date d'entrée] = riss_entrance_date
	,[Date de sortie] = riss_retire_date
	,[Nature] = isnull(pfn_l2,pfn_l1)
	,[Formule] = riss_formula_code
	--,prdv_variable_code
	--,invrisv_ti

	from
	pol_policies
	inner join pol_policies_situations on pol_last_policy_situation_id = pols_policy_situation_id
	inner join ris_risks on pol_policy_id = ris_policy_id
	inner join ris_risks_situations on ris_last_risk_situation_id = riss_risk_situation_id and riss_policy_situation_id = pols_policy_situation_id
	inner join vw_act_clients on cli_actor_id = pol_client_id
	--left join acc_invoices_risks_situations on invris_risk_situation_id = riss_risk_situation_id
	--left join acc_invoices_risks_variables on invrisv_invoice_id = invris_invoice_id
	--left join pr_products_variables on prdv_variable_id = invrisv_variable_id
	left join pr_products on prd_product_code = pol_product_code
	left join pr_families_natures on pfn_family_code = prd_family_code and pfn_nature_code = riss_nature_code
	where pols_number like @policy+'%'
	</SQL>
</Stat>

</AisMenuItem>
