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

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
By continuing to use the site, you agree to the use of cookies. Accept