FA Assets By Category - draft

Description
Categories: BI Publisher
Application: Assets
Source: Assets By Category Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS780_XML
DB package: FA_FAS780_XMLP_PKG
SELECT  NVL(&ACCT_FLEX_BAL_SEG,'None')                  COMP_CODE,
        &CAT_FLEX_ALL_SEG                               category,
        ad.asset_number || ' - ' || ad_tl.description      adescription,
        ad.serial_number                                s_num,
        ad.tag_number                                   t_num,
        sum(bk.cost) cost,
        bk.date_placed_in_service       dpis, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') d_comp_code, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY
FROM   
        fa_additions_tl            ad_tl,
        fa_additions_b            ad,
        fa_asset_history        ah,
        fa_books                bk,
        fa_categories           cat,
        fa_distribution_history dh,
        gl_Code_Combinations    cc
		WHERE
             ad.asset_category_id    =       cat.category_id 
AND     bk.date_effective       >= ah.date_effective
AND     bk.date_effective       < nvl(ah.date_ineffective, sysdate)
AND     bk.asset_id             = ah.asset_id
AND
             cat.category_id = NVL(:P_CATEGORY_ID,CAT.CATEGORY_ID)
			 AND
             bk.book_type_code = :P_BOOK AND
			 bk.asset_id             =       ad.asset_id                     AND
             bk.period_counter_fully_retired is NULL                         AND
             bk.date_ineffective IS  NULL
AND
        ad.asset_id = ah.asset_id 		AND
        dh.asset_id(+)          =       ad.asset_id                     AND
        dh.book_type_Code(+) = :DISTRIBUTION_SOURCE_BOOK AND
		dh.date_ineffective is null
AND
        dh.code_combination_id =        cc.code_combination_id(+)
AND ad.asset_id = ad_tl.asset_id
AND ad_tl.language = userenv ('LANG')
group by
        NVL(&ACCT_FLEX_BAL_SEG,'None'),
        &CAT_FLEX_ALL_SEG,
        ad.asset_number ,
        ad_tl.description,
        ad.serial_number,
        ad.tag_number,
        bk.date_placed_in_service,
		fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') , 	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') 
order by
NVL(&ACCT_FLEX_BAL_SEG,'None'),&CAT_FLEX_ALL_SEG,
fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE'),     adescription, s_num,
                   t_num, cost,          dpis
Parameter Name SQL text Validation
Dummy
 
Number
Asset Category
 
Book
 
LOV Oracle