ALTER PROCEDURE [dbo].[sp_RetrieveRecordGenealogy]
	@BarcodeUID NVARCHAR(50),
	@Err_Description AS NVARCHAR(100) OUTPUT	
AS
BEGIN
	SET NOCOUNT ON;

	SET @Err_Description = ''

	IF @BarcodeUID = '' OR @BarcodeUID IS NULL
	BEGIN
		SELECT @Err_Description = '001 # ' + ErrMessage FROM Tbl_ErrMessages WHERE ErrNumber = 1
		RETURN
	END

	ELSE IF NOT EXISTS (SELECT BarcodeUID FROM Tbl_RawMaterial WHERE BarcodeUID = @BarcodeUID) AND
			NOT EXISTS (SELECT BarcodeUID FROM Tbl_BagsPallet WHERE BarcodeUID = @BarcodeUID) AND
			NOT EXISTS (SELECT BarcodeUID FROM Tbl_Rolls WHERE BarcodeUID = @BarcodeUID)
	BEGIN
		SELECT @Err_Description = '015 # ' + ErrMessage FROM Tbl_ErrMessages WHERE ErrNumber = 15
		RETURN
	END
	

	IF OBJECT_ID('TMP','U') IS NULL
		CREATE TABLE TMP (
			[BarcodeUID] [nvarchar](50) NULL,
			[TimeStamp] [datetime] NULL,
			[TransactionType] [nvarchar](50) NULL,
			[Weight] [real] NULL,
			[Remarks] [nvarchar](50) NULL,
			[WIPID] [nvarchar](50) NULL,
			[WIPSID] [nvarchar](50) NULL,
			[ReceivingBarcodeUID] [nvarchar](50) NULL,
			[WarehouseID] [nvarchar](50) NULL,
			[LocationID] [nvarchar](50) NULL,
			[IssuingStationID] [nvarchar](50) NULL,
			[Meters] [real] NULL)

	INSERT INTO TMP 
	SELECT --DISTINCT
	  BarcodeUID
	  ,[TimeStamp]
	  ,TransactionType
	  ,Weight
	  ,Remarks
	  ,WIPID
	  ,WIPSID
	  ,ReceivingBarcodeUID 
	  ,WarehouseID
	  ,LocationID
	  ,IssuingStationID
	  ,Meters
	FROM Tbl_BarcodeTransactions
	WHERE ReceivingBarcodeUID = @BarcodeUID 

	DECLARE @ReceivingBarcodeUID AS NVARCHAR(50),
			@ERR AS NVARCHAR(100),
			@Barcode NVARCHAR(50)

--	SELECT @Barcode = BarcodeUID 
--	FROM Tbl_BarcodeTransactions
--	WHERE ReceivingBarcodeUID = @BarcodeUID

	DECLARE Cursor1 SCROLL CURSOR FOR SELECT BarcodeUID FROM TMP
	OPEN Cursor1 
	FETCH FIRST FROM Cursor1 INTO @Barcode

	WHILE @@FETCH_STATUS = 0
	BEGIN

		--IF (@BarcodeUID IS NOT NULL) AND (@BarcodeUID <> '')
		IF EXISTS (SELECT * FROM Tbl_BarcodeTransactions WHERE ReceivingBarcodeUID = @Barcode)
			EXEC sp_RetrieveRecordGenealogy @Barcode,
						@Err_Description = @Err OUTPUT

		FETCH NEXT FROM Cursor1 INTO @Barcode

--		ELSE
--		BEGIN
--			SELECT * FROM TMP
--			DROP TABLE TMP
--		END
	END

	CLOSE Cursor1;
	DEALLOCATE Cursor1;

	SELECT * FROM TMP
	DROP TABLE TMP

END