FROM [Analysis].[Track Entry] as track
	
	inner join [Analysis].[Track] as track_id
		  on track.[Track ID] = track_id.[Track ID]

    inner join [Analysis].[Track Calculate - ILE]  as ile_step0 
		  on track_id.[First Step Item Ledger Entry No] = ile_step0.[Entry No_]
		  and track_id.[First Step Company ID] = ile_step0.[Company ID]

    inner join [Analysis].[Track Calculate - ILE]  as ile
		  on track.[Item Ledger Entry No] = ile.[Entry No_]
		  and track.[Item Ledger Company ID] = ile.[Company ID]

	left join 
		(select 
		ile.[Company ID]
		,ile.[Entry No_] as [Item Ledger Entry No]
		,min(ve.[Entry No_]) as [Min Value Entry No]
		from [Analysis].[Track Calculate - ILE]  as ile

			inner join [Analysis].[Track Calculate - VE] as ve
				  on ve.[Item Ledger Entry No_] = ile.[Entry No_]
				  and ve.[Company ID] = ile.[Company ID]

		group by
		ile.[Company ID]
		,ile.[Entry No_]) as next_ile_min_ve
		on next_ile_min_ve.[Company ID] = track.[Next Item Ledger Company ID]
		and next_ile_min_ve.[Item Ledger Entry No] = track.[Next Item Ledger Entry No]
		  
    inner join [Analysis].[Track Calculate - VE] as ve
		  on ve.[Item Ledger Entry No_] = ile.[Entry No_]
		  and ve.[Company ID] = ile.[Company ID]
		  and 
				(  
					 (  
					   (ve.[Item Ledger Entry Type] = 0 or ve.[Entry Type] = 2)
                        and not (ile.[Entry Type] = 0 and ile.Positive = 0 and ve.[Cost Amount (Non-Invtbl_)] = 0)
					  )
					or (ile.[Entry Type] = 2 and ve.Adjustment = 0)
					or ve.[Item Ledger Entry Quantity] <> 0
					or ve.[Entry Type] = 2
					or (ve.[Item Ledger Entry Type] = 1 and ve.[Expected Cost] = 0)
				)
--------revaluation / no revaluation
----- MSDN Nav Design Details: Revaluation
----- Determining if an Inventory Decrease Is Affected by Revaluation
		  and 
			  (
			  	     (ve.[Entry Type] <> 1
				   --or ve.[Valued Quantity] = ile.Quantity --in database we have mistakes with [Valued Quantity]
                   --or ve_next_ile.[Entry No_] is null 
				   or track.[Next Item Ledger Entry No] = 0
				   --or track.[Item Ledger Entry Quantity] = -1 * track.[Next Item Application Entry Quantity]
				   or (ve.[Entry Type] = 1 and ve.[Partial Revaluation] = 0)	
				   )
			   or
			    (ve.[Company ID] = next_ile_min_ve.[Company ID]
				and
			      (not (next_ile_min_ve.[Min Value Entry No] < ve.[Entry No_]
				        and track.[Next Item Ledger Entry Posting Date] <= ve.[Valuation Date] )
				  )
                 )
			   )
------------------------------------
	inner join [Analysis].[Item] as item
		  on ile.[Item No_] = item.No_

	inner join [Analysis].[Location] as location
		  on ile.[Location Code] = location.Code

    left join [Analysis].[Track Calculate - ILE]  as ile_prev
		  on track.[Previous Item Ledger Entry No] = ile_prev.[Entry No_]
		  and track.[Previous Item Ledger Company ID] = ile_prev.[Company ID]

    left join [Analysis].[Purch_ Rcpt_ Line] as rcpt_line
		  on ile_step0.[Document Type] = 5
		  and ile_step0.[Document No_] = rcpt_line.[Document No_]
		  and ile_step0.[Document Line No_] = rcpt_line.[Line No_]
		  AND ile_step0.[Company ID] = rcpt_line.[Company ID]

    left join [Analysis].[Sales Shipment Line] as ship_line
		  on ile.[Document Type] = 1
		  and ile.[Document No_] = ship_line.[Document No_]
		  and ile.[Document Line No_] = ship_line.[Line No_]
		  AND ile.[Company ID] = ship_line.[Company ID]

    left join [Analysis].[Sales Shipment Line] as ship_line_prev
		  on ile_prev.[Document Type] = 1
		  and ile_prev.[Document No_] = ship_line_prev.[Document No_]
		  and ile_prev.[Document Line No_] = ship_line_prev.[Line No_]
		  AND ile_prev.[Company ID] = ship_line_prev.[Company ID]

    left join [Analysis].[Sales Invoice Line] as sal_inv_line
		  on ve.[Document Type] = 2
		  and ve.[Document No_] = sal_inv_line.[Document No_]
		  and ve.[Document Line No_] = sal_inv_line.[Line No_]
		  AND ve.[Company ID] = sal_inv_line.[Company ID]

    left join [Analysis].[Sales Cr_Memo Line] as sal_crm_line
		  on ve.[Document Type] = 4
		  and ve.[Document No_] = sal_crm_line.[Document No_]
		  and ve.[Document Line No_] = sal_crm_line.[Line No_]
		  AND ve.[Company ID] = sal_crm_line.[Company ID]


	left join 
		(select    [Item No_]
					,[code]
					,[Qty_ per Unit of Measure] 
		from [Analysis].[Item Unit of Measure]
		where [code] = 'MT') as uom_mt
	      on uom_mt.[Item No_] = ile.[Item No_]

	left join [Analysis].[Operation Entry (Table)] as old_operation
	on old_operation.[Track ID] = track.[Track ID]
	and old_operation.[Value Entry No] = ve.[Entry No_]
	and old_operation.[Item Ledger Company ID] = track.[Item Ledger Company ID]
	and old_operation.[Item Ledger Entry No] = track.[Item Ledger Entry No]


	where old_operation.[Track ID] is null

create table Men(
  id integer not null,
  name varchar2(240 char) not null,
  parent_id integer,
  constraint Men_pk primary key(id),
  constraint Men_Men_fk foreign key(parent_id) references Men(id));