PROJECT_ID	SEGMENT1	NAME	INVENTORY_ITEM_ID	SEGMENT1_1	PROJECT_ID INVENTORY_ITEM_ID_1 PROJECT_NUMBER	TASK_ID	PROJECT_ID_2	TASK_NAME	    TASK_NUMBER	PROJECT_ID_3 PROJECT_NUMBER_1	PROJECT_NAME
165003	1018101	LCS-HULL 	156200	A1018101531	165003	156200	       	1018101	1240800	165003	Wireways, Cableways	32120000	165003	1018101		LCS-HULL 
165003	1018101	LCS-HULL 	156200	A1018101531	165003	156200			1018101	1240900	165003	Replenishment at Se	57120000	165003	1018101		LCS-HULL 
165003	1018101	LCS-HULL 	156200	A1018101531	165003	156200			1018101	1241000	165003	Integrated Logistic	89520000	165003	1018101		LCS-HULL 
165003	1018101	LCS-HULL 	156200	A1018101531	165003	156200			1018101	1244000	165003	Test Procedure Deve	84013000	165003	1018101		LCS-HULL 
165003	1018101	LCS-HULL 	156200	A1018101531	165003	156200			1018101	1240723	165003	Weld Electrodes & G	10110000	165003	1018101		LCS-HULL 
165003	1018101	LCS-HULL 	156200	A1018101531	165003	156200			1018101	1240724	165003	Weld Electrodes & G	10120000	165003	1018101		LCS-HULL 
165003	1018101	LCS-HULL 	156200	A1018101531	165003	156200			1018101	1240725	165003	Allocated Stock Inv	10410000	165003	1018101		LCS-HULL 


UNION RESULTS
INVENTORY_ITEM_ID	PROJECT_ID	SEGMENT1	PROJECT_NUMBER
156164		165003	A101810162		1018101
156166		165003	A101810163		1018101
156169		165003	A1018101637		1018101
156171		165003	A10181016441	1018101
156172		165003	A10181016511	1018101
156180		165003	A10181017801	1018101