ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1A63869E053B46B63588994 SELECT &ACCT_FLEX_BAL_SEG COMPANY, FALU.MEANING ASSET_TYPE, DECODE(FAAH.ASSET_TYPE, 'CIP', FACB.CIP_COST_ACCT, FACB.ASSET_COST_ACCT) ACCOUNT, &ACCT_FLEX_COST_SEG COST_CENTER, FAAD.ASSET_NUMBER || ' - ' || FAAD.DESCRIPTION ASSET, FATH.TRANSACTION_HEADER_ID TR_NUMBER, DECODE(FADJ.DEBIT_CREDIT_FLAG, 'CR', 0, 'DR', 1) IN_OUT, FATH.TRANSACTION_DATE_ENTERED TR_DATE_ENT, FADJ.ADJUSTMENT_AMOUNT * DECODE(FADJ.DEBIT_CREDIT_FLAG, 'DR', 1, 'CR', -1, 0) COST, FATH.DATE_EFFECTIVE FATH_DATE, fnd_flex_xml_publisher_apis.process_kff_combination_1('company_dsp', 'SQLGL', 'GL#', DHCC.CHART_OF_ACCOUNTS_ID, NULL, DHCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMPANY_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_center_dsp', 'SQLGL', 'GL#', DHCC.CHART_OF_ACCOUNTS_ID, NULL, DHCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') COST_CENTER_DSP FROM FA_TRANSACTION_HEADERS FATH, FA_ADJUSTMENTS FADJ, FA_DISTRIBUTION_HISTORY FADH, FA_CATEGORY_BOOKS FACB, GL_CODE_COMBINATIONS DHCC, FA_ASSET_HISTORY FAAH, FA_ADDITIONS FAAD, FA_LOOKUPS FALU WHERE FATH.TRANSACTION_TYPE_CODE in ('TRANSFER','UNIT ADJUSTMENT') AND FATH.BOOK_TYPE_CODE = :P_BOOK AND FATH.DATE_EFFECTIVE BETWEEN :PERIOD1_POD AND nvl(:PERIOD2_PCD, SYSDATE) AND FADJ.TRANSACTION_HEADER_ID = FATH.TRANSACTION_HEADER_ID AND FADJ.ASSET_ID = FATH.ASSET_ID AND FADJ.BOOK_TYPE_CODE = FATH.BOOK_TYPE_CODE AND FADJ.SOURCE_TYPE_CODE = 'TRANSFER' AND FADJ.ADJUSTMENT_TYPE in ('COST', 'CIP COST') AND (fadh.distribution_id in (select dh1.distribution_id from fa_distribution_history dh1 WHERE (DH1.TRANSACTION_HEADER_ID_OUT = FATH.TRANSACTION_HEADER_ID OR DH1.TRANSACTION_HEADER_ID_IN = FATH.TRANSACTION_HEADER_ID) AND 1 < (SELECT count( distinct dh2.code_combination_id) FROM FA_DISTRIBUTION_HISTORY DH2 WHERE (DH2.TRANSACTION_HEADER_ID_OUT = FATH.TRANSACTION_HEADER_ID OR DH2.TRANSACTION_HEADER_ID_IN = FATH.TRANSACTION_HEADER_ID))) OR FATH.TRANSACTION_TYPE_CODE = 'UNIT ADJUSTMENT') AND FADH.DISTRIBUTION_ID = FADJ.DISTRIBUTION_ID AND DHCC.CODE_COMBINATION_ID = FADH.CODE_COMBINATION_ID AND FAAH.ASSET_ID = FATH.ASSET_ID AND FATH.DATE_EFFECTIVE >= FAAH.DATE_EFFECTIVE AND FATH.DATE_EFFECTIVE < NVL(FAAH.DATE_INEFFECTIVE,SYSDATE) AND FACB.CATEGORY_ID = FAAH.CATEGORY_ID AND FACB.BOOK_TYPE_CODE = FATH.BOOK_TYPE_CODE AND FAAD.ASSET_ID = FAAH.ASSET_ID AND FALU.LOOKUP_CODE = FAAH.ASSET_TYPE AND FALU.LOOKUP_TYPE = 'ASSET TYPE' order by ASSET Y OFA FAS431_XML AR FA تقرير تسوية تحويل الأصل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير تسوية تحويل الأصل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS431_XML DB package: FA_FAS431_XMLP_PKG D FA Anlagenneuzuordnung - Abstimmung- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Anlagenneuzuordnung - Abstimmung (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS431_XML DB package: FA_FAS431_XMLP_PKG F FA Etat de rapprochement des transferts d'immobilisations- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat de rapprochement des transferts d'immobilisations (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS431_XML DB package: FA_FAS431_XMLP_PKG US FA Asset Transfer Reconciliation - draft Application: Assets Source: Asset Transfer Reconciliation Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS431_XML DB package: FA_FAS431_XMLP_PKG ZHS FA 资产转移调节报表- 不支持：已保留供将来使用 Application: 资产 Source: 资产转移调节报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS431_XML DB package: FA_FAS431_XMLP_PKG BI Publisher &acct_flex_bal_seg &acct_flex_cost_seg :acct_bal_aprompt :acct_cc_aprompt :cat_maj_rprompt :p_book :p_conc_request_id :p_min_precision :p_period1 :p_period2 :period1_fy :period1_pcd :period1_pod :period2_fy :period2_pcd :period2_pod :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_period1 LOV Oracle FA_PERIOD_NAME Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter>(select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type) order by period_counter Y AR من الفترة D Von Periode F De la période US From Period ZHS 自期间 3 30 :p_period2 LOV Oracle FA_PERIOD_TO Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter>=(select period_counter from fa_deprn_periods where book_type_code= :$flex$.fa_book_type and period_name= :$flex$.fa_period_name) order by period_counter Y AR إلى الفترة D Bis Periode F A la période US To Period ZHS 至期间