FA Asset Tag Listing - draft

SELECT 
        faad.tag_number,
        faad.asset_number,
        faad.description                        adescription,
        &CAT_FLEX_ALL_SEG                       category, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_Flexfield
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.book_type_code = bc.book_type_code
AND     bk.asset_id = faad.asset_id
AND     bk.transaction_header_id_out is null
AND     bc.book_class = 'CORPORATE'
order by
        faad.tag_number
		--added
		,faad.asset_number,adescription,category