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 |
