FA Transaction History - draft

➜ Back to Library
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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Book 
 
 LOV Oracle
From Asset No 
 
 LOV Oracle
To Asset No 
 
 LOV Oracle
Download
 
Related Blitz Reports
FA Asset Additions - draft FA CIP Statistics for the Central Statistical Office (KSH) (Hungary) FA Reinstated Assets - draft FA Cost Adjustments - draft FA Asset Additions FA Form 4797 - Gain From Disposition of 1245 Property - draft FA Asset Retirements FA Cost Adjustments FA Additions By Source FA Asset Book Details
Blitz Report™

Blitz Report™ provides multiple benefits: