FA Assets By Category Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Assets By Category Report
Application: Assets
Source: Assets By Category Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS780_XML
DB package: FA_FAS780_XMLP_PKG
Description: Assets By Category Report
Application: Assets
Source: Assets By Category Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS780_XML
DB package: FA_FAS780_XMLP_PKG
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
SELECT NVL(&ACCT_FLEX_BAL_SEG,'None') COMP_CODE, &CAT_FLEX_ALL_SEG category, ad.asset_number || ' - ' || ad_tl.description adescription, ad.serial_number s_num, ad.tag_number t_num, sum(bk.cost) cost, bk.date_placed_in_service dpis, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.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 FROM fa_additions_tl ad_tl, fa_additions_b ad, fa_asset_history ah, fa_books bk, fa_categories cat, fa_distribution_history dh, gl_Code_Combinations cc WHERE ad.asset_category_id = cat.category_id AND bk.date_effective >= ah.date_effective AND bk.date_effective < nvl(ah.date_ineffective, sysdate) AND bk.asset_id = ah.asset_id AND cat.category_id = NVL(:P_CATEGORY_ID,CAT.CATEGORY_ID) AND bk.book_type_code = :P_BOOK AND bk.asset_id = ad.asset_id AND bk.period_counter_fully_retired is NULL AND bk.date_ineffective IS NULL AND ad.asset_id = ah.asset_id AND dh.asset_id(+) = ad.asset_id AND dh.book_type_Code(+) = :DISTRIBUTION_SOURCE_BOOK AND dh.date_ineffective is null AND dh.code_combination_id = cc.code_combination_id(+) AND ad.asset_id = ad_tl.asset_id AND ad_tl.language = userenv ('LANG') group by NVL(&ACCT_FLEX_BAL_SEG,'None'), &CAT_FLEX_ALL_SEG, ad.asset_number , ad_tl.description, ad.serial_number, ad.tag_number, bk.date_placed_in_service, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.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 NVL(&ACCT_FLEX_BAL_SEG,'None'),&CAT_FLEX_ALL_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.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'), adescription, s_num, t_num, cost, dpis |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book |
|
LOV Oracle | |
Asset Category |
|
Char |