FA Mass Additions Delete - draft

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