FA Tax Reserve Ledger - draft

Description
Categories: BI Publisher
Application: Assets
Source: Tax Reserve Ledger Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS480_XML
DB package: FA_FAS480_XMLP_PKG
SELECT
	--&ACCT_FLEX_BAL_SEG		COMP_CODE,
	FY.FISCAL_YEAR			FISCAL_YEAR,
	CB.ASSET_COST_ACCT		GL_ACCOUNT,
	RSV.DEPRN_RESERVE_ACCT		RSV_ACCOUNT,
	AD.ASSET_NUMBER ||' - '|| AD.DESCRIPTION	ASSET_NUMBER,
	RSV.DATE_PLACED_IN_SERVICE	START_DATE,
	RSV.METHOD_CODE		METHOD,
	RSV.LIFE				LIFE,
	RSV.RATE			ADJ_RATE,
	DS.BONUS_RATE			BONUS_RATE,
	RSV.CAPACITY			PROD,
	ROUND(SUM(RSV.COST),:P_MIN_PRECISION)			COST,
	ROUND(SUM(RSV.DEPRN_AMOUNT),:P_MIN_PRECISION)	   	DEPRN_AMOUNT,
	ROUND(SUM(RSV.YTD_DEPRN),:P_MIN_PRECISION)		YTD_DEPRN,
	ROUND(SUM(RSV.DEPRN_RESERVE),:P_MIN_PRECISION)		DEPRN_RESERVE,
	RSV.TRANSACTION_TYPE		T_TYPE, 
	--fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP1, 
	FA_FAS480_XMLP_PKG.d_lifeformula(RSV.LIFE, RSV.RATE, DS.BONUS_RATE, RSV.CAPACITY) D_LIFE
FROM
	FA_DEPRN_SUMMARY	DS,
	FA_ADDITIONS		AD,
	FA_ASSET_HISTORY	AH,
	FA_FISCAL_YEAR		FY,
	FA_CATEGORY_BOOKS	CB,
	GL_CODE_COMBINATIONS	DHCC,
	FA_RESERVE_LEDGER_GT	RSV
WHERE
	RSV.ASSET_ID		= AD.ASSET_ID
AND
	RSV.DH_CCID		= DHCC.CODE_COMBINATION_ID
AND
	DS.PERIOD_COUNTER 	= RSV.PERIOD_COUNTER	AND
	DS.BOOK_TYPE_CODE 	= :Book  AND
	DS.ASSET_ID   		= RSV.ASSET_ID
AND
	CB.CATEGORY_ID =  AH.CATEGORY_ID		AND
	CB.BOOK_TYPE_CODE =  :P_Book
AND
	AH.ASSET_ID =  AD.ASSET_ID			AND
	AH.DATE_EFFECTIVE < RSV.DATE_EFFECTIVE	AND
	nvl(AH.DATE_INEFFECTIVE, SYSDATE) >= RSV.DATE_EFFECTIVE
AND
	FY.FISCAL_YEAR_NAME = :FISCAL_YEAR_NAME  AND
	RSV.DATE_PLACED_IN_SERVICE BETWEEN FY.START_DATE
		AND FY.END_DATE
AND	:C_DO_INSERT = 1
GROUP BY
	--&ACCT_FLEX_BAL_SEG,
--Added during DT Fix
	fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'),
--End of DT Fix
	FY.FISCAL_YEAR,
	CB.ASSET_COST_ACCT,
	RSV.DEPRN_RESERVE_ACCT,
	AD.ASSET_NUMBER ||' - '|| AD.DESCRIPTION,
	RSV.DATE_PLACED_IN_SERVICE,
	RSV.METHOD_CODE,
	RSV.LIFE,
	RSV.RATE,
	DS.BONUS_RATE,
	RSV.CAPACITY,
	RSV.TRANSACTION_TYPE
ORDER BY 
16, 1, 2, 3, 4
Parameter Name SQL text Validation
Period
 
LOV Oracle
Set of Books Currency
 
LOV Oracle
Book
 
LOV Oracle
Ask a question