ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1DF3869E053B46B63588994 SELECT AD.ASSET_NUMBER ASSET_NO, TH.TRANSACTION_HEADER_ID THID, LU_SUB.MEANING TYPE, DECODE (TH.TRANSACTION_HEADER_ID, BK.TRANSACTION_HEADER_ID_OUT, 0, 1) FROM_TO, BK.DEPRN_METHOD_CODE METHOD, BK.LIFE_IN_MONTHS LIFE, BK.ADJUSTED_RATE ADJUSTED_RATE, NVL(DS.BONUS_RATE, 0) BONUS_RATE, BK.PRODUCTION_CAPACITY PRODUCTION, BK.BONUS_RULE BONUS_RULE, BK.CEILING_NAME CEIL_NAME, BK.SALVAGE_VALUE SAL_VAL, BK.COST COST, LU.MEANING DEPR, FA_FASFIADJ_XMLP_PKG.d_lifeformula(BK.LIFE_IN_MONTHS, BK.ADJUSTED_RATE, NVL(DS.BONUS_RATE, 0), BK.PRODUCTION_CAPACITY) D_LIFE --COMMENTED AS THE QUERY IS REPEATED /* FROM_TO, BK.DEPRN_METHOD_CODE METHOD, BK.LIFE_IN_MONTHS LIFE, BK.ADJUSTED_RATE ADJUSTED_RATE, NVL(DS.BONUS_RATE, 0) BONUS_RATE, BK.PRODUCTION_CAPACITY PRODUCTION, BK.BONUS_RULE BONUS_RULE, BK.CEILING_NAME CEIL_NAME, BK.SALVAGE_VALUE SAL_VAL, BK.COST COST, LU.MEANING DEPR */ FROM FA_ADDITIONS AD, FA_BOOKS BK, FA_LOOKUPS LU, FA_LOOKUPS LU_SUB, FA_TRANSACTION_HEADERS TH, FA_DEPRN_SUMMARY DS WHERE TH.DATE_EFFECTIVE BETWEEN :PERIOD1_POD AND :PERIOD1_PCD AND TH.BOOK_TYPE_CODE = :P_BOOK AND TH.TRANSACTION_TYPE_CODE = 'ADJUSTMENT' AND LU_SUB.LOOKUP_TYPE = 'TRANSACTION SUBTYPE' AND LU_SUB.LOOKUP_CODE = NVL(TH.TRANSACTION_SUBTYPE,'EXPENSED') AND AD.ASSET_ID = TH.ASSET_ID AND TH.TRANSACTION_HEADER_ID IN (BK.TRANSACTION_HEADER_ID_IN, BK.TRANSACTION_HEADER_ID_OUT) AND BK.BOOK_TYPE_CODE =:P_BOOK AND BK.ASSET_ID = TH.ASSET_ID AND LU.LOOKUP_TYPE = 'YESNO' AND LU.LOOKUP_CODE = BK.DEPRECIATE_FLAG AND DS.BOOK_TYPE_CODE(+) = :P_BOOK AND DS.ASSET_ID(+) = TH.ASSET_ID AND DS.PERIOD_COUNTER(+) = :PERIOD1_PC ORDER BY 1,2,3,4 Y OFA FASFIADJ_XML AR FA تقرير التعديلات المالية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير التعديلات المالية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASFIADJ_XML DB package: FA_FASFIADJ_XMLP_PKG D FA Finanzberichtigungen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Finanzberichtigungen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASFIADJ_XML DB package: FA_FASFIADJ_XMLP_PKG F FA Etat des ajustements financiers- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des ajustements financiers (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASFIADJ_XML DB package: FA_FASFIADJ_XMLP_PKG US FA Financial Adjustments - draft Application: Assets Source: Financial Adjustments Report (XML) - Not Supported: Reserved For Future Use Short Name: FASFIADJ_XML DB package: FA_FASFIADJ_XMLP_PKG ZHS FA 财务调整报表- 不支持：已保留供将来使用 Application: 资产 Source: 财务调整报表 (XML) - 不支持：已保留供将来使用 Short Name: FASFIADJ_XML DB package: FA_FASFIADJ_XMLP_PKG BI Publisher :p_book :p_conc_request_id :p_min_precision :p_period1 :period1_fy :period1_pc :period1_pcd :period1_pod :rp_bal_lprompt :rp_company_name :rp_report_name 1 10 :p_book LOV Oracle FA_NOBUD_BOOK Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class!='BUDGET' order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿 2 20 :p_period1 LOV Oracle FA_PERIOD_NAME_NOBUD Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_nobud_book and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_nobud_book) order by period_counter Y AR الفترة D Periode F Période US Period ZHS 期间