FA Mass Additions Delete - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Assets
Source: Mass Additions Delete Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS829_XML
DB package: FA_FAS829_XMLP_PKG
SELECT
	FAMA.MASS_ADDITION_ID	 		ASSET,
	FAMA.DESCRIPTION 			DESCRIPTION,
	FAMA.FIXED_ASSETS_COST 			COST,
	FAMA.REVIEWER_COMMENTS			COMMENTS
--Added during DT Fixes
	,FA_FAS829_XMLP_PKG.D_COSTFormula Temp_RP_DATA_FOUND
--End of DT Fixes
FROM	
	FA_MASS_ADDITIONS FAMA
WHERE	
	POSTING_STATUS = 'DELETE'		AND	
	BOOK_TYPE_CODE = :P_BOOK 
union
SELECT
	fama.MASS_ADDITION_ID	 		ASSET,
	fama.DESCRIPTION 			DESCRIPTION,
	fama.FIXED_ASSETS_COST 			COST,
	fama.REVIEWER_COMMENTS			COMMENTS
--Added during DT Fixes
	,FA_FAS829_XMLP_PKG.D_COSTFormula Temp_RP_DATA_FOUND
--End of DT Fixes
FROM	
	FA_MASS_ADDITIONS ma2, fa_mass_additions fama
WHERE	
	ma2.POSTING_STATUS = 'DELETE'		AND	
	fama.BOOK_TYPE_CODE = :P_BOOK                          AND
	fama.MERGE_PARENT_MASS_ADDITIONS_ID = ma2.mass_ADDITION_ID AND
	fama.MERGED_CODE = 'MC'
ORDER BY 
--	1,2
1, 2, 3, 4
Parameter NameSQL textValidation
Book
 
LOV Oracle
Download
Related Blitz Reports
FA Asset Book Details FA Cost Clearing Reconciliation - draft FA Asset Transfers - draft FA Cost Adjustments by Source - draft FA Mass Change Preview - draft FA Asset Book Details 11i JA Australian Assets Revaluation Report- Not Supported: Reserved For Future Use - Not Supported: Reserved For Future Use FA Mass Retirements - draft FA Additions By Source
Blitz Report™