FA Bulgarian Reserve Ledger

Description
Categories: BI Publisher
Application: Assets
Source: Bulgarian Reserve Ledger Report
Short Name: FARESLDG
DB package: FA_RES_LDG_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
		,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
		,SUM(decode(RSV.transaction_type,'B',NULL,RSV.COST))								COST
		,SUM(RSV.DEPRN_AMOUNT)	    														DEPRN_AMOUNT
		,SUM(RSV.YTD_DEPRN)																	YTD_DEPRN
		,SUM(RSV.DEPRN_RESERVE)          													DEPRN_RESERVE
		,sum(decode(RSV.transaction_type,'B',NULL,nvl(RSV.PERCENT,0)))						PERCENT
		,RSV.TRANSACTION_TYPE																T_TYPE
		,FA_RES_LDG_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
		,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(RSV.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
		,RSV.DATE_PLACED_IN_SERVICE
		,RSV.METHOD_CODE
		,RSV.LIFE
		,RSV.RATE
		,RSV.CAPACITY
		,DS.BONUS_RATE
		,RSV.TRANSACTION_TYPE
ORDER BY
	1, 2, 3, 4, 5
Parameter Name SQL text Validation
Period
 
LOV Oracle
Set of Books Currency
 
LOV Oracle
Book
 
LOV Oracle