FA Transaction History - draft

Select
	AD.ASSET_NUMBER			ASSET_NUMBER,
	AD.DESCRIPTION 				ASSET_DESC,
	AD.SERIAL_NUMBER			S_NUMBER,
	AD.TAG_NUMBER				T_NUMBER,
	LU.MEANING 				TRAN_TYPE,
	TH.TRANSACTION_HEADER_ID		TRAN_ID,
	TH.TRANSACTION_DATE_ENTERED  TRAN_DATE,
	DP.PERIOD_NAME				PERIOD_NAME
FROM
	FA_TRANSACTION_HEADERS	TH,
	FA_ADDITIONS		AD,
	FA_DEPRN_PERIODS	DP,
	FA_LOOKUPS	   	LU
WHERE
	TH.BOOK_TYPE_CODE		=  UPPER(:P_BOOK)		AND
	TH.ASSET_ID			=  AD.ASSET_ID
AND
	LU.LOOKUP_TYPE			= 'FAXOLTRX'			AND
	LU.LOOKUP_CODE			= TH.TRANSACTION_TYPE_CODE
AND
	AD.ASSET_NUMBER  >= nvl(:P_start_asset,AD.ASSET_NUMBER) AND 
	AD.ASSET_NUMBER  <= nvl(:P_end_asset,AD.ASSET_NUMBER)
AND
	TH.DATE_EFFECTIVE		BETWEEN	DP.PERIOD_OPEN_DATE
					AND	nvl(DP.PERIOD_CLOSE_DATE,
						SYSDATE)		AND
	TH.BOOK_TYPE_CODE		=  DP.BOOK_TYPE_CODE
order by 
AD.ASSET_NUMBER,
TH.TRANSACTION_HEADER_ID