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

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