FA Property Tax Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Property Tax Report
Application: Assets
Source: Property Tax Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS460_XML
DB package: FA_FAS460_XMLP_PKG
Description: Property Tax Report
Application: Assets
Source: Property Tax Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS460_XML
DB package: FA_FAS460_XMLP_PKG
Run
FA Property Tax Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT null LOCATION, null COMPANY, cb.asset_cost_acct account, to_char(bk.date_placed_in_service, 'YYYY') year, ad.asset_number asset, ad.description descr, lpad(to_char(sum(di.units_assigned)),6) units, bk.date_placed_in_service date_installed, round(sum(bk.cost * (di.units_assigned/ah.units)),:precision) orig_cost, fnd_flex_xml_publisher_apis.process_kff_combination_1('company_dsp', 'SQLGL', 'GL#', COMCC.CHART_OF_ACCOUNTS_ID, NULL, COMCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMPANY_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, LO.LOCATION_ID, 'ALL', 'Y', 'VALUE') D_LOCATION FROM fa_system_controls sc, fa_locations lo, fa_books bk, fa_asset_history ah, fa_additions ad, fa_distribution_history di, gl_Code_combinations comcc, fa_category_books cb, fa_book_controls bc WHERE &LOC_FLEX_WHERE AND :P_END_DATE_ACQ between bk.date_effective and nvl(bk.date_ineffective,sysdate) AND bk.book_type_code = :P_BOOK AND bk.asset_id = ad.asset_id and nvl(bk.period_counter_fully_retired,:P_Per_Ctr+1) >= :P_Per_Ctr and AD.OWNED_LEASED = 'OWNED' AND :P_END_DATE_ACQ between ah.date_effective and nvl(ah.date_ineffective,sysdate) AND ah.asset_id = ad.asset_id AND ah.category_id = cb.category_id AND cb.book_type_code= bk.book_type_code AND bc.book_type_code = bk.book_type_code and di.book_type_code = bc.distribution_source_book AND di.location_id = lo.location_id AND di.asset_id = bk.asset_id AND di.code_combination_id= comcc.code_combination_id AND di.transaction_header_id_in <= (select max(th.transaction_header_id) from fa_transaction_headers th where th.asset_id = di.asset_id AND th.book_type_code = di.book_type_code AND th.date_effective <= :P_END_DATE_ACQ) AND (di.transaction_header_id_out >= (select min(th.transaction_header_id) from fa_transaction_headers th where th.asset_id = di.asset_id AND th.book_type_code = di.book_type_code AND th.date_effective > :P_END_DATE_ACQ) OR di.transaction_header_id_out is null) GROUP BY bk.book_type_code, &ACCT_FLEX_BAL_SEG, &LOC_FLEX_ALL_SEG, to_char(bk.date_placed_in_service, 'YYYY'), cb.asset_cost_acct, ad.asset_number, ad.description, bk.date_placed_in_service, --ADDED fnd_flex_xml_publisher_apis.process_kff_combination_1('company_dsp', 'SQLGL', 'GL#', COMCC.CHART_OF_ACCOUNTS_ID, NULL, COMCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, LO.LOCATION_ID, 'ALL', 'Y', 'VALUE') ORDER BY --ADDED COMPANY,D_LOCATION,ACCOUNT,YEAR,ASSET,descr,UNITS,DATE_INSTALLED,ORIG_COST /* &ACCT_FLEX_BAL_SEG, &LOC_FLEX_ALL_SEG, cb.asset_cost_acct, to_char(bk.date_placed_in_service, 'YYYY'), asset_number */ |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book |
|
LOV Oracle | |
State |
|
Char | |
End Date Acquired |
|
Date |