FA Transaction History - draft

Description
Categories: BI Publisher
Application: Assets
Source: Transaction History Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS530_XML
DB package: FA_FAS530_XMLP_PKG
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
Parameter Name SQL text Validation
To Asset No
 
LOV Oracle
From Asset No
 
LOV Oracle
Book
 
LOV Oracle