ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1AB3869E053B46B63588994 SELECT --NVL(&ACCT_FLEX_BAL_SEG,'NONE') COMP_CODE, NVL(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'),'NONE') D_COMP_CODE1, DECODE(AH.ASSET_TYPE,'CIP',CB.CIP_COST_ACCT, CB.ASSET_COST_ACCT) ACCOUNT, AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ASSET_NUM, AD.PROPERTY_TYPE_CODE TYPE, RET.DATE_RETIRED DATE_RETIRED FROM FA_DEPRN_PERIODS DP, FA_RETIREMENTS RET, FA_ADDITIONS AD, FA_ASSET_HISTORY AH, FA_CATEGORY_BOOKS CB, FA_TRANSACTION_HEADERS TH, FA_DISTRIBUTION_HISTORY DH, GL_CODE_COMBINATIONS DHCC, FA_BOOK_CONTROLS BC WHERE DP.BOOK_TYPE_CODE = :P_BOOK AND DP.PERIOD_COUNTER >= :PERIOD1_PC AND DP.PERIOD_COUNTER <= :PERIOD2_PC AND TH.DATE_EFFECTIVE >= DP.PERIOD_OPEN_DATE AND TH.DATE_EFFECTIVE <= NVL(DP.PERIOD_CLOSE_DATE,SYSDATE)AND TH.BOOK_TYPE_CODE = :P_BOOK AND TH.TRANSACTION_TYPE_CODE IN ('FULL RETIREMENT', 'PARTIAL RETIREMENT') AND RET.TRANSACTION_HEADER_ID_IN = TH.TRANSACTION_HEADER_ID AND AD.ASSET_ID = TH.ASSET_ID AND AD.PROPERTY_1245_1250_CODE IS NULL AND CB.CATEGORY_ID = AH.CATEGORY_ID AND CB.BOOK_TYPE_CODE = :P_BOOK AND AH.ASSET_ID = AD.ASSET_ID AND TH.TRANSACTION_HEADER_ID >= AH.TRANSACTION_HEADER_ID_IN AND TH.TRANSACTION_HEADER_ID < NVL(AH.TRANSACTION_HEADER_ID_OUT, TH.TRANSACTION_HEADER_ID + 1) AND BC.BOOK_TYPE_CODE = :P_BOOK AND DH.BOOK_TYPE_CODE = BC.DISTRIBUTION_SOURCE_BOOK AND DH.ASSET_ID = TH.ASSET_ID AND ( DH.RETIREMENT_ID = RET.RETIREMENT_ID OR (RET.DATE_EFFECTIVE >= DH.DATE_EFFECTIVE AND RET.DATE_EFFECTIVE <= NVL(DH.DATE_INEFFECTIVE,SYSDATE) AND RET.UNITS IS NULL)) AND DHCC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID --ORDER BY 1,2,3 ORDER BY 1,2,3,4,5 OFA FAS444_XML AR FA تقرير الأصول المستبعدة بدون طبقات الملكية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير الأصول المستبعدة بدون طبقات الملكية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS444_XML DB package: FA_FAS444_XMLP_PKG D FA Anlagenabgänge ohne Vermögensklasse- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Anlagenabgänge ohne Vermögensklasse (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS444_XML DB package: FA_FAS444_XMLP_PKG F FA Etat des cessions d'immobilisations non rattachées à une classe de biens (USA)- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des cessions d'immobilisations non rattachées à une classe de biens (USA) (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS444_XML DB package: FA_FAS444_XMLP_PKG US FA Retired Assets Without Property Classes - draft Application: Assets Source: Retired Assets Without Property Classes Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS444_XML DB package: FA_FAS444_XMLP_PKG ZHS FA 无财产分类的已报废资产报表- 不支持：已保留供将来使用 Application: 资产 Source: 无财产分类的已报废资产报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS444_XML DB package: FA_FAS444_XMLP_PKG BI Publisher &acct_flex_bal_seg :acct_bal_aprompt :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 :rp_bal_lprompt :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 至期间 :$flex$.fa_book_type Book From Period :$flex$.fa_book_type Book To Period :$flex$.fa_period_name From Period To Period