JL Colombian Inflation Adjusted Fixed Assets - draft

Description
Categories: BI Publisher
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
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
Parameter Name SQL text Validation
Category Flex Structure
 
Number
Asset Number
 
Asset Category
 
Period
 
LOV Oracle
Book
 
LOV Oracle