ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470B051A9E05362FB09050512 select &cf_asset_cat_flex ASSET_CATEGORY, &cf_acct_flex C_FLEXDATA, ad.asset_number ASSET_NUMBER, ad.asset_number||' - '||ad.description ASSET, jc.user_je_category_name TRANSACTION_TYPE, aj.code_combination_id CCID, sum(decode(decode(aj.debit_credit_flag,'DR', 1, 'CR', -1, 0) *sign (aj.adjustment_amount),1, abs (aj.adjustment_amount),null)) DR_AMT, sum(decode(decode(aj.debit_credit_flag,'DR', 1, 'CR', -1, 0) *sign (aj.adjustment_amount),-1, abs (aj.adjustment_amount),null)) CR_AMT, aj.transaction_header_id THID, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_asset_category', 'OFA', 'CAT#', 101, NULL, ac.CATEGORY_ID, 'ALL', 'Y', 'VALUE') CF_asset_category, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_display', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_Flex_Display from JL_CO_FA_ADJUSTMENTS aj, GL_JE_LINES jl, GL_JE_HEADERS jh, GL_JE_CATEGORIES jc, GL_JE_BATCHES jb, FA_ADDITIONS ad, FA_CATEGORIES ac, GL_CODE_COMBINATIONS cc where aj.book_type_code = :P_BOOK and aj.period_counter_created = :PERIOD1_PC and aj.adjustment_amount <> 0 and jb.description like :p_book||'/'||:p_period1||'%' and jb.je_batch_id = jh.je_batch_id and jh.je_category = jc.je_category_name and jh.je_header_id = jl.je_header_id and RTRIM(NVL(jl.reference_2,' ')) = to_char(nvl(aj.sequence_line,0)) and aj.asset_id = ad.asset_id and ad.asset_category_id = ac.category_id and aj.code_combination_id = cc.code_combination_id and ac.category_id = nvl(:P_ASSET_CATEGORY_ID, ac.category_id) and ad.asset_number = nvl(:P_ASSET_NUMBER, ad.asset_number) group by &cf_asset_cat_flex, ad.asset_number, ad.description, jc.user_je_category_name , aj.transaction_header_id , aj.code_combination_id , &cf_acct_flex, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_asset_category', 'OFA', 'CAT#', 101, NULL, ac.CATEGORY_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_display', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') ORDER BY 1 ASC,3 ASC,4 ASC,9 ASC,5 ASC , 1 , 3 , 4 , 9 , 5 JL JLCOFITR_XML US JL Colombian Inflation Adjusted Fixed Assets Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Colombian Inflation Adjusted Fixed Assets Report Application: Latin America Localizations Source: Colombian Inflation Adjusted Fixed Assets Report (XML) - Not Supported: Reserved For Future Use Short Name: JLCOFITR_XML DB package: JL_JLCOFITR_XMLP_PKG BI Publisher &cf_acct_flex &cf_asset_cat_flex :accounting_flex_structure :book_class :currency_code :distribution_source_book :p_acct_ccid :p_asset_category_id :p_asset_number :p_batch_id :p_book :p_category_id :p_conc_request_id :p_line_num :p_min_precision :p_period1 :period1_fy :period1_pc :period1_pcd :period1_pod :rp_company_name :rp_report_name 1 -20 :not_used_in_report Number SELECT category_flex_structure FROM fa_system_controls Y US Category Flex Structure Category Flex Structure 2 10 :p_book LOV Oracle JLCO_FA_BOOKS_INF_ADJUST Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls where book_class='TAX' and global_attribute1='Y' order by book_type_code Y US Book Book Type Code 3 20 :p_period1 LOV Oracle JLCO_FA_TAX_PERIOD_NAME Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.jlco_fa_books_inf_adjust and period_counter>(select min (dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.jlco_fa_books_inf_adjust) order by period_counter Y US Period Period Name 4 30 :p_asset_category_id Char US Asset Category Asset Category 5 40 :p_asset_number Char US Asset Number Asset Number :$flex$.jlco_fa_books_inf_adjust Book Period