SELECT
FR.COMP_CODE COMP_CODE,
FR.DEPRN_METHOD FED_METHOD,
FR.ASSET_ACCOUNT ASSET_ACCOUNT,
fnd_flex_xml_publisher_apis.process_kff_combination_1('cat_flex_all_seg', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') CATEGORY,
AD.ASSET_NUMBER ASSET_NUMBER,
FR.FED_YTD_DEPRN FED_YTD_DEPRN,
SUM(DD_CORP.DEPRN_AMOUNT) CORP_YTD_DEPRN,
DECODE(SIGN(FR.FED_YTD_DEPRN - SUM(DD_CORP.DEPRN_AMOUNT)), -1, 0,
FR.FED_YTD_DEPRN - SUM(DD_CORP.DEPRN_AMOUNT)) DIFFERENCE,
--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,
--fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY
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,
fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY1
FROM
FA_TAX_REPORT FR,
FA_DEPRN_PERIODS DP,
FA_DEPRN_DETAIL DD_CORP,
FA_ASSET_HISTORY AH,
FA_CATEGORY_BOOKS CB_CORP,
FA_CATEGORIES CAT,
FA_ADDITIONS AD,
FA_DISTRIBUTION_HISTORY DH,
GL_CODE_COMBINATIONS DHCC
WHERE FR.REQUEST_ID = :P_CONC_REQUEST_ID
AND FR.ASSET_ID = DD_CORP.ASSET_ID
and fr.asset_id = ah.asset_id
and AH.DATE_EFFECTIVE <= DP.PERIOD_CLOSE_DATE
and NVL(AH.DATE_INEFFECTIVE, DP.PERIOD_CLOSE_DATE+1) > DP.PERIOD_CLOSE_DATE
and CB_CORP.CATEGORY_ID = AH.CATEGORY_ID
AND DD_CORP.BOOK_TYPE_CODE = :DISTRIBUTION_SOURCE_BOOK
AND DD_CORP.PERIOD_COUNTER BETWEEN :min_corp_pc
AND :corp_end_pc
AND CB_CORP.BOOK_TYPE_CODE = DD_CORP.BOOK_TYPE_CODE
AND CB_CORP.ASSET_COST_ACCT BETWEEN NVL(:P_FROM_ACCT, CB_CORP.ASSET_COST_ACCT)
AND NVL(:P_TO_ACCT, CB_CORP.ASSET_COST_ACCT)
AND CB_CORP.CATEGORY_ID = CAT.CATEGORY_ID
AND DP.BOOK_TYPE_CODE = :P_BOOK
AND DP.PERIOD_COUNTER = :max_fed_pc
AND FR.ASSET_ID = AD.ASSET_ID
and DH.ASSET_ID = DD_CORP.ASSET_ID AND
DH.DISTRIBUTION_ID = DD_CORP.DISTRIBUTION_ID AND
DH.CODE_COMBINATION_ID = DHCC.CODE_COMBINATION_ID(+) and
fr.comp_code =fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE')
GROUP BY
FR.COMP_CODE,
FR.DEPRN_METHOD,
FR.ASSET_ACCOUNT,
fnd_flex_xml_publisher_apis.process_kff_combination_1('cat_flex_all_seg', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE'),
AD.ASSET_NUMBER,
FR.FED_YTD_DEPRN
--Added during DT Fix
,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')
,fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE')
order by 1, 2, 3, 4, 5, 6, 7, 8
--End of DT Fix |
