FA Asset Description Listing - draft

SELECT 
        faad.description 	adescription,
        faad.asset_number,
        &CAT_FLEX_ALL_SEG	category,
        faad.tag_number, 
--	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_Flexfield
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_Flexfield1
FROM
        fa_additions                  faad,
        fa_categories                cat,
        fa_books                       bk,         fa_book_controls_sec    bc WHERE   cat.category_id         =       faad.asset_category_id 
AND     bk.asset_id                  =       faad.asset_id 
AND     bk.transaction_header_id_out is null 
AND     bc.book_type_code      =       bk.book_type_code
AND     bc.book_class              =       'CORPORATE'
order by
        faad.description,
        faad.asset_number