FA Asset Description Listing - draft
Description
Categories: BI Publisher
Application: Assets
Source: Asset Description Listing (XML) - Not Supported: Reserved For Future Use
Short Name: FAS730_XML
DB package: FA_FAS730_XMLP_PKG
Source: Asset Description Listing (XML) - Not Supported: Reserved For Future Use
Short Name: FAS730_XML
DB package: FA_FAS730_XMLP_PKG
Run
FA Asset Description Listing - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
