ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1713869E053B46B63588994 select jb.name BATCH_NAME, jc.user_je_category_name CATEGORY, &C_Acct_Flex C_FLEXDATA, aj.code_combination_id CCID, jl1.je_line_num LINE, ad.asset_number||' - '||ad.description ASSET, 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('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 jl1, GL_JE_HEADERS jh, GL_JE_CATEGORIES jc, GL_JE_BATCHES jb, FA_ADDITIONS ad, 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 jl1.je_header_id = jh.je_header_id and RTRIM(NVL(jl1.reference_2, ' ')) = to_char(nvl(aj.sequence_line,0)) and aj.posting_flag = 'C' and jc.je_category_name = jh.je_category and jb.je_batch_id = jh.je_batch_id and ad.asset_id = aj.asset_id and cc.code_combination_id = aj.code_combination_id &c_dynamic_where_clause group by &C_Acct_Flex, aj.code_combination_id, jb.name, jc.user_je_category_name, jl1.je_line_num, ad.asset_number, ad.description, aj.transaction_header_id, 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, 2, 3, 4, 5, 6 Y JL JLCOFDDR_XML US JL Colombian Fixed Assets Inflation Adjusted Drill Down - draft Application: Latin America Localizations Source: Colombian Fixed Assets Inflation Adjusted Drill Down Report (XML) - Not Supported: Reserved For Future Use Short Name: JLCOFDDR_XML DB package: JL_JLCOFDDR_XMLP_PKG BI Publisher &c_acct_flex &c_dynamic_where_clause :accounting_flex_structure :book_class :c_dynamic_where_clause :currency_code :distribution_source_book :p_acct_ccid :p_batch_id :p_book :p_conc_request_id :p_line_num :p_min_precision :p_period1 :period1_fy :period1_pc :period1_pcd :period1_pod :rp_company_name 1 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 2 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 3 30 :p_batch_id LOV Oracle JLCO_FA_JE_BATCHES Y select je_batch_id id, name value, description description from gl_je_batches where description like :$flex$.jlco_fa_books_inf_adjust || '/' || :$flex$.jlco_fa_tax_period_name || '%' order by je_batch_id US Batch Name 4 40 :p_line_num LOV Oracle JLCO_FA_JE_LINES Y select je_line_num id, je_line_num value, null description from gl_je_lines where je_header_id in (select h.je_header_id from gl_je_headers h where h.je_batch_id=:$flex$.jlco_fa_je_batches) order by je_line_num US Line