FA Recoverable Cost - draft

Description
Categories: BI Publisher
Application: Assets
Source: Recoverable Cost Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASRCOST_XML
DB package: FA_FASRCOST_XMLP_PKG
SELECT	NVL(&ACCT_FLEX_BAL_SEG, 'NONE')	 			COMP_CODE,
	AD.ASSET_NUMBER						ASSET_NUMBER,
	ROUND(SUM(NVL(MC.COST,BK_CORP.COST) * 
		NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS) ,:PRECISION)	CORP_COST,
	ROUND(SUM(NVL(MC.SALVAGE_VALUE,BK_CORP.SALVAGE_VALUE) * 
		NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION)	CORP_SALV_VALUE,	
ROUND(SUM(NVL(MC.ADJUSTED_RECOVERABLE_COST,NVL(BK_CORP.adjusted_recoverable_cost,0)) * 
		NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION)	CORP_RECOV_COST,
	DECODE(SIGN(ROUND(SUM(NVL(MC.COST,BK_CORP.COST) * 
		NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS)
	   	- SUM(BK_CORP.SALVAGE_VALUE * 
		NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION)
		- 
          ROUND(SUM(NVL(MC.ADJUSTED_RECOVERABLE_COST,NVL(BK_CORP.adjusted_recoverable_cost,0)) * 
		NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION)),
		'0',NULL,'*') 					CORP_CHECK,
	ROUND(SUM(BK_TAX.COST * 
		NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION)	TAX_COST,
	ROUND