ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1B63869E053B46B63588994 Select AD.ASSET_NUMBER ASSET_NUMBER, AD.DESCRIPTION ASSET_DESC, AD.SERIAL_NUMBER S_NUMBER, AD.TAG_NUMBER T_NUMBER, LU.MEANING TRAN_TYPE, TH.TRANSACTION_HEADER_ID TRAN_ID, TH.TRANSACTION_DATE_ENTERED TRAN_DATE, DP.PERIOD_NAME PERIOD_NAME FROM FA_TRANSACTION_HEADERS TH, FA_ADDITIONS AD, FA_DEPRN_PERIODS DP, FA_LOOKUPS LU WHERE TH.BOOK_TYPE_CODE = UPPER(:P_BOOK) AND TH.ASSET_ID = AD.ASSET_ID AND LU.LOOKUP_TYPE = 'FAXOLTRX' AND LU.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE AND AD.ASSET_NUMBER >= nvl(:P_start_asset,AD.ASSET_NUMBER) AND AD.ASSET_NUMBER <= nvl(:P_end_asset,AD.ASSET_NUMBER) AND TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE AND nvl(DP.PERIOD_CLOSE_DATE, SYSDATE) AND TH.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE order by AD.ASSET_NUMBER, TH.TRANSACTION_HEADER_ID OFA FAS530_XML AR FA تقرير تاريخ الحركة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير تاريخ الحركة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS530_XML DB package: FA_FAS530_XMLP_PKG D FA Transaktionshistorie- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Transaktionshistorie (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS530_XML DB package: FA_FAS530_XMLP_PKG F FA Etat de l'historique des transactions- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat de l'historique des transactions (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS530_XML DB package: FA_FAS530_XMLP_PKG US FA Transaction History - draft Application: Assets Source: Transaction History Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS530_XML DB package: FA_FAS530_XMLP_PKG ZHS FA 事务处理历史记录报表- 不支持：已保留供将来使用 Application: 资产 Source: 事务处理历史记录报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS530_XML DB package: FA_FAS530_XMLP_PKG BI Publisher :accounting_flex_structure :book_class :currency_code :distribution_source_book :from_asset_param :p_book :p_conc_request_id :p_end_asset :p_min_precision :p_start_asset :rp_company_name :rp_report_name :to_asset_param 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_start_asset LOV Oracle FA_ASSET_RANGE Y select asset_number id, asset_number value, null description from fa_additions fad where exists (select asset_id from fa_books fab where book_type_code=:$flex$.fa_book_type and fab.asset_id=fad.asset_id and fab.date_ineffective is null) order by value,description Y AR من رقم الأصل D Von Anlagen-Nr. F Numéro d'immobilisation - De US From Asset No ZHS 起始资产编号 3 30 :p_end_asset LOV Oracle FA_ASSET_RANGE_TO Y select asset_number id, asset_number value, null description from fa_additions fad where exists (select asset_id from fa_books fab where book_type_code=:$flex$.fa_book_type and fab.asset_id=fad.asset_id and fab.date_ineffective is null and fad.asset_number>=:$flex$.fa_asset_range) order by value,description Y AR إلى رقم الأصل D Bis Anlagen-Nr. F Numéro d'immobilisation - A US To Asset No ZHS 至资产编号 :$flex$.fa_asset_range From Asset No To Asset No :$flex$.fa_book_type Book From Asset No :$flex$.fa_book_type Book To Asset No