ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2043869E053B46B63588994 SELECT &ACCT_FLEX_BAL_SEG COMP_CODE, FACB.CIP_COST_ACCT ACCOUNT, &ACCT_FLEX_COST_SEG COST_CTR, FACB.ASSET_COST_ACCT ASSET_ACCOUNT, FADD.ASSET_NUMBER||' - '||FADD.DESCRIPTION ASSET, FABKS.DATE_PLACED_IN_SERVICE DATE_IN_SERVICE, FABKS.DEPRN_METHOD_CODE DEPRN_METHOD, FABKS.LIFE_IN_MONTHS LIFE, FABKS.PRODUCTION_CAPACITY CAPACITY, FABKS.ADJUSTED_RATE ADJ_RATE, ROUND(DECODE(FATRANS.TRANSACTION_TYPE_CODE,'CIP REVERSE',-1*(FABKS.COST), FABKS.COST)*(SUM(FADH.UNITS_ASSIGNED)/FAHIST.UNITS),:PRECISION) COST, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMP_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') D_COST_CTR, FA_FASWIPCR_XMLP_PKG.d_lifeformula(FABKS.LIFE_IN_MONTHS, FABKS.ADJUSTED_RATE, FABKS.PRODUCTION_CAPACITY) D_LIFE FROM GL_CODE_COMBINATIONS DHCC, FA_DISTRIBUTION_HISTORY FADH, FA_CATEGORY_BOOKS FACB, FA_ASSET_HISTORY FAHIST, FA_ADDITIONS FADD, FA_BOOKS FABKS, FA_TRANSACTION_HEADERS FATRANS WHERE FATRANS.TRANSACTION_TYPE_CODE = 'ADDITION' AND FATRANS.BOOK_TYPE_CODE = :P_BOOK AND FATRANS.DATE_EFFECTIVE BETWEEN :PERIOD1_POD AND :PERIOD2_PCD AND EXISTS (SELECT NULL FROM FA_ASSET_HISTORY AH WHERE AH.ASSET_ID = FATRANS.ASSET_ID AND AH.ASSET_TYPE = 'CIP') AND FATRANS.ASSET_ID = FADH.ASSET_ID AND FATRANS.BOOK_TYPE_CODE = FADH.BOOK_TYPE_CODE AND FATRANS.DATE_EFFECTIVE >= FADH.DATE_EFFECTIVE AND FATRANS.DATE_EFFECTIVE < NVL(FADH.DATE_INEFFECTIVE, SYSDATE) AND FADH.CODE_COMBINATION_ID = DHCC.CODE_COMBINATION_ID AND FATRANS.TRANSACTION_HEADER_ID = FABKS.TRANSACTION_HEADER_ID_IN AND FABKS.ASSET_ID = FADD.ASSET_ID AND FATRANS.TRANSACTION_HEADER_ID = FAHIST.TRANSACTION_HEADER_ID_IN AND FATRANS.ASSET_ID = FAHIST.ASSET_ID AND FAHIST.CATEGORY_ID = FACB.CATEGORY_ID AND FACB.BOOK_TYPE_CODE = :P_BOOK GROUP BY &ACCT_FLEX_BAL_SEG, FACB.CIP_COST_ACCT, &ACCT_FLEX_COST_SEG, FACB.ASSET_COST_ACCT, FADD.ASSET_NUMBER, FADD.DESCRIPTION, FABKS.DATE_PLACED_IN_SERVICE, FABKS.DEPRN_METHOD_CODE, FABKS.LIFE_IN_MONTHS, FABKS.PRODUCTION_CAPACITY, FABKS.ADJUSTED_RATE, FATRANS.TRANSACTION_TYPE_CODE, FABKS.COST, FAHIST.UNITS, FATRANS.ASSET_ID, FABKS.DATE_EFFECTIVE --added ,fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') ORDER BY &ACCT_FLEX_BAL_SEG, FACB.CIP_COST_ACCT, &ACCT_FLEX_COST_SEG, FACB.ASSET_COST_ACCT, FATRANS.ASSET_ID, FABKS.DATE_EFFECTIVE Y OFA FASWIPCR_XML AR FA تقرير رسملة مشروعات تحت التنفيذ (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير رسملة مشروعات تحت التنفيذ (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASWIPCR_XML DB package: FA_FASWIPCR_XMLP_PKG D FA Im Bau befindliche Anlagen - Aktivierung- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Im Bau befindliche Anlagen - Aktivierung (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASWIPCR_XML DB package: FA_FASWIPCR_XMLP_PKG F FA Etat des productions à soi-même amortissables- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des productions à soi-même amortissables (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASWIPCR_XML DB package: FA_FASWIPCR_XMLP_PKG US FA CIP Capitalization - draft Application: Assets Source: CIP Capitalization Report (XML) - Not Supported: Reserved For Future Use Short Name: FASWIPCR_XML DB package: FA_FASWIPCR_XMLP_PKG ZHS FA CIP 资本化报表- 不支持：已保留供将来使用 Application: 资产 Source: CIP 资本化报表 (XML) - 不支持：已保留供将来使用 Short Name: FASWIPCR_XML DB package: FA_FASWIPCR_XMLP_PKG BI Publisher &acct_flex_bal_seg &acct_flex_cost_seg :accounting_flex_structure :acct_bal_aprompt :acct_cc_aprompt :currency_code :p_book :p_conc_request_id :p_min_precision :p_period1 :p_period2 :period1_fy :period1_pc :period1_pcd :period1_pod :period2_fy :period2_pc :period2_pcd :period2_pod :precision :rp_bal_lprompt :rp_cc_lprompt :rp_company_name :rp_report_name 1 10 :p_book LOV Oracle FA_CORP_BOOK Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='CORPORATE' order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿 2 20 :p_period1 LOV Oracle FA_PERIOD_NAME_CORP Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_corp_book and period_counter>(select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_corp_book) 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_CORP Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_corp_book and period_counter>=(select period_counter from fa_deprn_periods where book_type_code= :$flex$.fa_corp_book and period_name= :$flex$.fa_period_name_corp) order by period_counter Y AR إلى الفترة D Bis Periode F A la période US To Period ZHS 至期间