PERTALIFE

ALTER PROCEDURE PDSCOMBOASSETIDRPT

(

	@AssetType VARCHAR(20)

	,@AssetClass VARCHAR(20)

	,@AssetCode  VARCHAR(20)

)

AS

--DECLARE @AssetType VARCHAR(20) = 'AST0004'

--DECLARE @AssetClass VARCHAR(20) = ''

--DECLARE @AssetCode VARCHAR(20) = ''

SELECT DISTINCT assetid.AssetID, assetid.AssetName, assetid.AssetCode, assetcode.AssetType, fixasset.AssetClass

FROM PMDAST0002 AS assetid

LEFT JOIN pmdast0001 AS assetcode

	ON assetid.AssetCode = assetcode.AssetCode

LEFT JOIN PCMFILOFIXASSET as fixasset

	ON fixasset.AssetType = assetcode.AssetType

WHERE (assetcode.AssetType = @AssetType OR @AssetType = '')

	AND (fixasset.AssetClass = @AssetClass OR @AssetClass = '')

	AND (assetid.AssetCode = @AssetCode OR @AssetCode = '')