ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1EB3869E053B46B63588994 SELECT P_AD.ASSET_NUMBER || ' - ' || P_AD.DESCRIPTION PARENT_ASSET, P_AD.SERIAL_NUMBER PARENT_SERIAL, P_BOOK.COST PARENT_COST, C_AD.ASSET_NUMBER || ' - ' || C_AD.DESCRIPTION CHILD_ASSET, C_AD.SERIAL_NUMBER CHILD_SERIAL, C_BOOK.COST CHILD_COST FROM FA_BOOKS C_BOOK, FA_BOOKS P_BOOK, FA_ADDITIONS C_AD, FA_ADDITIONS P_AD WHERE C_AD.PARENT_ASSET_ID IS NOT NULL AND P_AD.ASSET_ID = C_AD.PARENT_ASSET_ID AND ( P_AD.ASSET_NUMBER BETWEEN NVL( :P_FROM_ASSET, P_AD.ASSET_NUMBER ) AND NVL( :P_TO_ASSET, P_AD.ASSET_NUMBER)) AND C_BOOK.ASSET_ID = C_AD.ASSET_ID AND C_BOOK.BOOK_TYPE_CODE = :P_BOOK AND C_BOOK.TRANSACTION_HEADER_ID_OUT IS NULL and c_book.period_counter_fully_retired is null AND P_BOOK.ASSET_ID = P_AD.ASSET_ID AND P_BOOK.BOOK_TYPE_CODE = :P_BOOK AND P_BOOK.TRANSACTION_HEADER_ID_OUT IS NULL and P_book.period_counter_fully_retired is null ORDER BY P_AD.ASSET_NUMBER, C_AD.ASSET_NUMBER OFA FASPARAS_XML AR FA تقرير الأصول الرئيسية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير الأصول الرئيسية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASPARAS_XML DB package: FA_FASPARAS_XMLP_PKG D FA Übergeordnete Anlagen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Übergeordnete Anlagen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASPARAS_XML DB package: FA_FASPARAS_XMLP_PKG F FA Etat des immobilisations parent- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des immobilisations parent (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASPARAS_XML DB package: FA_FASPARAS_XMLP_PKG US FA Parent Asset - draft Application: Assets Source: Parent Asset Report (XML) - Not Supported: Reserved For Future Use Short Name: FASPARAS_XML DB package: FA_FASPARAS_XMLP_PKG ZHS FA 父资产报表- 不支持：已保留供将来使用 Application: 资产 Source: 父资产报表 (XML) - 不支持：已保留供将来使用 Short Name: FASPARAS_XML DB package: FA_FASPARAS_XMLP_PKG BI Publisher :p_book :p_conc_request_id :p_from_asset :p_min_precision :p_to_asset :rp_company_name :rp_report_name 1 10 :p_book LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿 2 20 :p_from_asset Char AR من رقم الأصل D Von Anlagennummer F Du numéro d'immobilisation US From Asset Number ZHS 起始资产编号 3 30 :p_to_asset Char AR إلى رقم الأصل D Bis Anlagennummer F Au numéro d'immobilisation US To Asset Number ZHS 终止资产编号