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

FA CIP Detail - draft

Description
Categories: BI Publisher
Application: Assets
Source: CIP Detail Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASWIPDR_XML
DB package: FA_FASCOSTD_XMLP_PKG
SELECT
	--&ACCT_FLEX_BAL_SEG					COMP_CODE,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMP_CODE1,
	--NVL(&ACCT_FLEX_ACCT_SEG, BAL.Category_Books_Account)	ACCOUNT,
	NVL(fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), BAL.Category_Books_Account)	D_ACCOUNT1,
	BAL.Category_Books_Account D_ACCOUNT2,
	--&ACCT_FLEX_COST_SEG					COST_CTR,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') D_COST_CTR1,
	AD.Asset_Number						ASSET,
	NVL(SUM (DECODE (BAL.Source_Type_Code,
		'BEGIN', NVL(BAL.Amount,0), NULL)), 0)			BEGIN,
	SUM (DECODE (BAL.Source_Type_Code,
		DECODE(:P_REPORT_TYPE, 'COST', 'ADDITION',
		'CIP ADDITION'), NVL(BAL.Amount,0), NULL)) 			ADDITION,
	SUM (DECODE (BAL.Source_Type_Code,
		DECODE(:P_REPORT_TYPE, 'CIP COST', 'ADDITION'),
		-NVL(BAL.Amount,0), NULL)) 				CAPITALIZATION,
	SUM (DECODE (BAL.Source_Type_Code,
		DECODE(:P_REPORT_TYPE, 'COST', 'ADJUSTMENT',
		'CIP ADJUSTMENT'), NVL(BAL.Amount,0), NULL)) 		ADJUSTMENT,
	SUM (DECODE (BAL.Source_Type_Code,
		'RECLASS', NVL(BAL.Amount,0), NULL)) 			RECLASS,
	SUM (DECODE (BAL.Source_Type_Code,
		DECODE(:P_REPORT_TYPE, 'COST', 'RETIREMENT',
		'CIP RETIREMENT'), -NVL(BAL.Amount,0), NULL))		RETIREMENT,
	SUM (DECODE (BAL.Source_Type_Code,
		'REVALUATION', NVL(BAL.Amount,0), NULL)) 			REVALUATION,
	SUM (DECODE (BAL.Source_Type_Code,
		'TRANSFER', NVL(BAL.Amount,0), NULL)) 			TRANSFER,
	NVL(SUM (DECODE (BAL.Source_Type_Code,
		'END', NVL(BAL.Amount,0), NULL)), 0)				END,
	--fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') d_comp_code,
	FA_FASCOSTD_XMLP_PKG.bal_out_of_balanceformula(:BAL_BEGIN, :BAL_ADD, :BAL_REVAL, :BAL_RECLASS, :BAL_RETIRE, :BAL_ADJUST, :BAL_TRANS, :BAL_CAPITAL, :BAL_END) BAL_OUT_OF_BALANCE,
	--fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') d_account,
	FA_FASCOSTD_XMLP_PKG.acct_out_of_balanceformula(:ACCT_BEGIN, :ACCT_ADD, :ACCT_REVAL, :ACCT_RECLASS, :ACCT_RETIRE, :ACCT_ADJUST, :ACCT_TRANS, :ACCT_CAPITAL, :ACCT_END) ACCT_OUT_OF_BALANCE,
	--fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') d_cost_ctr,
	FA_FASCOSTD_XMLP_PKG.ctr_out_of_balanceformula(:CTR_BEGIN, :CTR_ADD, :CTR_REVAL, :CTR_RECLASS, :CTR_RETIRE, :CTR_ADJUST, :CTR_TRANS, :CTR_CAPITAL, :CTR_END) CTR_OUT_OF_BALANCE,
	FA_FASCOSTD_XMLP_PKG.caprevalformula(SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'CIP COST' , 'ADDITION' ) , - NVL ( BAL.Amount , 0 ) , NULL ) )) CAPREVAL,
	FA_FASCOSTD_XMLP_PKG.out_of_balanceformula(NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'BEGIN' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'COST' , 'ADDITION' , 'CIP ADDITION' ) , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'REVALUATION' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'RECLASS' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'COST' , 'RETIREMENT' , 'CIP RETIREMENT' ) , - NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'COST' , 'ADJUSTMENT' , 'CIP ADJUSTMENT' ) , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , 'TRANSFER' , NVL ( BAL.Amount , 0 ) , NULL ) ), SUM ( DECODE ( BAL.Source_Type_Code , DECODE ( :P_REPORT_TYPE , 'CIP COST' , 'ADDITION' ) , - NVL ( BAL.Amount , 0 ) , NULL ) ), NVL ( SUM ( DECODE ( BAL.Source_Type_Code , 'END' , NVL ( BAL.Amount , 0 ) , NULL ) ) , 0 )) OUT_OF_BALANCE
FROM
	FA_BALANCES_REPORT_GT BAL,
	FA_ADDITIONS AD,
	GL_CODE_COMBINATIONS DHCC,
	GL_CODE_COMBINATIONS AJCC
WHERE
	AD.Asset_ID	= BAL.Asset_ID
AND
	DHCC.Code_Combination_ID	= BAL.Distribution_CCID
AND
	AJCC.Code_Combination_ID (+) = BAL.Adjustment_CCID
AND
	:DO_INSERT = 1
GROUP BY
	--&ACCT_FLEX_BAL_SEG,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'),
	--NVL(&ACCT_FLEX_ACCT_SEG, BAL.Category_Books_Account),
	NVL(fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', ajcc.CHART_OF_ACCOUNTS_ID, NULL, ajcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), BAL.Category_Books_Account),
	--&ACCT_FLEX_COST_SEG,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE'),
	AD.ASSET_NUMBER,
	BAL.Category_Books_Account
ORDER BY
	1, 2, 3, 4
Parameter Name SQL text Validation
Report Type
 
To Period
 
LOV Oracle
From Period
 
LOV Oracle
Ledger Currency
 
LOV Oracle
Book
 
LOV Oracle
By continuing to use the site, you agree to the use of cookies. Accept