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
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