JL Colombian Fixed Assets Inflation Adjusted Account Drill Down Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Colombian Fixed Assets Inflation Adjusted Account Drill Down Report
Application: Latin America Localizations
Source: Colombian Fixed Assets Inflation Adjusted Account Drill Down Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLCOFADR_XML
DB package: JL_JLCOFADR_XMLP_PKG
Description: Colombian Fixed Assets Inflation Adjusted Account Drill Down Report
Application: Latin America Localizations
Source: Colombian Fixed Assets Inflation Adjusted Account Drill Down Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLCOFADR_XML
DB package: JL_JLCOFADR_XMLP_PKG
Run
JL Colombian Fixed Assets Inflation Adjusted Account Drill Down Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
select jb.name BATCH_NAME, jc.user_je_category_name CATEGORY, &ACCT_FLEX_ALL_SEG ACCT, jl_1.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('d_acct', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') D_ACCT from JL_CO_FA_ADJUSTMENTS aj, GL_JE_LINES jl_1, 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 jl_1.je_header_id = jh.je_header_id and RTRIM(NVL(jl_1.reference_2,' ')) = to_char(nvl(aj.sequence_line,0)) 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 &CP_OPTIONAL_PARAMETERS group by &ACCT_FLEX_ALL_SEG, jb.name, jc.user_je_category_name, jl_1.je_line_num, ad.asset_number, ad.description, aj.transaction_header_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_acct', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') order by 9,1, 2, 4, 5,6,7 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book |
|
LOV Oracle | |
Period |
|
LOV Oracle | |
FA_ACCT_NUMBER |
|
Char | |
Batch |
|
LOV Oracle | |
Line |
|
LOV Oracle |
Blitz Report™