FA Journal Entry Reserve Ledger - draft

Description
Categories: BI Publisher
Application: Assets
Source: Journal Entry Reserve Ledger Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS400_XML
DB package: FA_FAS400_XMLP_PKG
SELECT
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE')	COMP_CODE,
	decode(TRANSACTION_TYPE,'B',RSV.RESERVE_ACCT, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') )	GL_ACCOUNT,
	RSV.DEPRN_RESERVE_ACCT	RSV_ACCOUNT,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE')	COST_CENTER,
	AD.ASSET_NUMBER || '-' || AD.DESCRIPTION		
		ASSET_NUMBER,
	DATE_PLACED_IN_SERVICE		START_DATE,
	METHOD_CODE			METHOD,
	RSV.LIFE				LIFE,
	RSV.RATE			ADJ_RATE,
	DS.BONUS_RATE			BONUS_RATE,
	RSV.CAPACITY			PROD,
	SUM(decode(transaction_type,'B',NULL,COST))			COST,
	SUM(RSV.DEPRN_AMOUNT)	    DEPRN_AMOUNT,
	SUM(RSV.YTD_DEPRN)		YTD_DEPRN,
	SUM(RSV.DEPRN_RESERVE)          DEPRN_RESERVE,
	sum(decode(transaction_type,'B',NULL,nvl(PERCENT,0)))		PERCENT,
	TRANSACTION_TYPE		T_TYPE, 
	FA_FAS400_XMLP_PKG.d_lifeformula(RSV.LIFE, RSV.RATE, DS.BONUS_RATE, RSV.CAPACITY) D_LIFE
FROM
	FA_RESERVE_LEDGER_GT	RSV,
	FA_ADDITIONS		AD,
	GL_CODE_COMBINATIONS	CC,
	&lp_fa_deprn_summary	DS
WHERE
	RSV.ASSET_ID		= AD.ASSET_ID
AND
	RSV.DH_CCID		= CC.CODE_COMBINATION_ID
AND
	DS.PERIOD_COUNTER (+)	= RSV.PERIOD_COUNTER	AND
	DS.BOOK_TYPE_CODE (+)	= :P_Book  AND
	DS.ASSET_ID (+)		= RSV.ASSET_ID
GROUP BY
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'),
	decode(transaction_type,'B', RSV.RESERVE_ACCT,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE')),
	RSV.DEPRN_RESERVE_ACCT,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE'),
	AD.ASSET_NUMBER,
	AD.DESCRIPTION,
	DATE_PLACED_IN_SERVICE,
	METHOD_CODE,
	RSV.LIFE,
 	RSV.RATE,
	RSV.CAPACITY,
	DS.BONUS_RATE, 
	TRANSACTION_TYPE
ORDER BY
--	1, 2, 3, 4, 5
	1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 8, 12, 13, 14, 15, 16, 17
Parameter Name SQL text Validation
Period
 
LOV Oracle
Set of Books Currency
 
LOV Oracle
Book
 
LOV Oracle