Reports2017-11-18T12:27:27+00:00

FA Mass Additions Delete - draft

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 Name SQL text Validation
Book
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept