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 |