ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470D751A9E05362FB09050512 SELECT --&ACCT_FLEX_COST_SEG Cost_Ctr, 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_CTR1, --&ACCT_FLEX_BAL_SEG Comp_Code, 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_CODE1, EMP.FULL_Name Name, --&LOC_FLEX_ALL_SEG Location, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, loc.LOCATION_ID, 'ALL', 'Y', 'VALUE') D_LOCATION1, AD.Description Asset_Desc, abs(DH.Transaction_Units) Units, AD.Serial_Number S_Number, AD.Tag_Number T_Number, AD.Asset_Number Asset_Number, min(ROUND(decode(TH.Transaction_Type_Code,'TRANSFER',(BOOKS.COST * abs(DH.Transaction_Units) / AH.Units), (NVL(MC.Cost_Retired,RET.Cost_Retired) / RET.Units * abs(DH.Transaction_Units))),:PRECISION)) D_Cost, min(ROUND(decode(TH.Transaction_Type_Code,'TRANSFER',((BOOKS.COST * abs(DH.Transaction_Units) / Ah.Units - (nvl(DD.Deprn_Reserve,0) * abs(DH.Transaction_Units) / DH.Units_Assigned))), (NVL(MC.NBV_Retired,nvl(RET.NBV_Retired,0))/ RET.Units * abs(DH.Transaction_Units))),:PRECISION)) NBV, min(ROUND(decode(TH.Transaction_Type_Code,'TRANSFER', (-1 * (BOOKS.COST * abs(DH.Transaction_Units) / Ah.Units - (nvl(DD.Deprn_Reserve,0) * abs(DH.Transaction_Units) / DH.Units_Assigned))), (NVL(MC.Gain_Loss_Amount,nvl(RET.Gain_Loss_Amount,0)) / RET.Units * abs(DH.Transaction_Units))),:PRECISION)) Gain_Loss, min(decode( TH.Transaction_Type_Code,'TRANSFER OUT', (decode(RET.TRANSACTION_HEADER_ID_OUT, NULL,'P', '*')), 'TRANSFER','T', (decode(RET.TRANSACTION_HEADER_ID_OUT, NULL, NULL, '*'))) ) Type FROM FA_MC_RETIREMENTS MC, FA_RETIREMENTS_BAS RET, FA_ADDITIONS AD, GL_CODE_COMBINATIONS DHCC, FA_BOOKS BOOKS, FA_ASSET_HISTORY AH, FA_DISTRIBUTION_HISTORY DH, FA_DISTRIBUTION_HISTORY DH2, FA_TRANSACTION_HEADERS TH, PER_ALL_PEOPLE_F EMP, FA_LOCATIONS LOC, FA_DEPRN_DETAIL DD WHERE &ACCT_FLEX_COST_SEG_W AND TH.DATE_EFFECTIVE >= :PERIOD1_POD AND TH.DATE_EFFECTIVE <= :PERIOD1_PCD AND TH.BOOK_TYPE_CODE = :P_BOOK AND TH.TRANSACTION_TYPE_CODE in ('FULL RETIREMENT','TRANSFER', 'TRANSFER OUT') AND AH.ASSET_ID = TH.ASSET_ID AND TH.TRANSACTION_HEADER_ID BETWEEN AH.TRANSACTION_HEADER_ID_IN AND NVL(AH.TRANSACTION_HEADER_ID_OUT, TH.TRANSACTION_HEADER_ID) AND DH.ASSET_ID = TH.ASSET_ID AND DH.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE AND NVL(DH.TRANSACTION_HEADER_ID_OUT,0) = decode(TH.TRANSACTION_TYPE_CODE, 'FULL RETIREMENT', nvl(DH.TRANSACTION_HEADER_ID_OUT,0), TH.TRANSACTION_HEADER_ID) AND nvl(DH.TRANSACTION_UNITS,0) < 0 AND RET.DATE_EFFECTIVE >= :PERIOD1_POD AND RET.DATE_EFFECTIVE <= :PERIOD1_PCD AND DH.RETIREMENT_ID = RET.RETIREMENT_ID(+) AND MC.RETIREMENT_ID(+) = DECODE(:MRC_SOB_TYPE_CODE,'R',RET.RETIREMENT_ID,NULL) AND MC.SET_OF_BOOKS_ID(+) = :SET_OF_BOOKS_ID AND DH.DISTRIBUTION_ID = DD.DISTRIBUTION_ID(+) AND DD.PERIOD_COUNTER(+) = :PERIOD1_PC - 1 AND DD.BOOK_TYPE_CODE(+) = :P_BOOK AND DH2.TRANSACTION_HEADER_ID_IN (+)= DH.TRANSACTION_HEADER_ID_OUT AND (DH2.CODE_COMBINATION_ID != DH.CODE_COMBINATION_ID OR TH.TRANSACTION_TYPE_CODE != 'TRANSFER') AND AD.ASSET_ID = DH.ASSET_ID AND TH.TRANSACTION_HEADER_ID > BOOKS.TRANSACTION_HEADER_ID_IN AND TH.TRANSACTION_HEADER_ID <= NVL(BOOKS.TRANSACTION_HEADER_ID_OUT, TH.TRANSACTION_HEADER_ID) AND BOOKS.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE AND BOOKS.ASSET_ID = TH.ASSET_ID AND LOC.LOCATION_ID = DH.LOCATION_ID AND EMP.PERSON_ID(+) = DH.ASSIGNED_TO AND TRUNC(SYSDATE) BETWEEN EMP.EFFECTIVE_START_DATE(+) AND EMP.EFFECTIVE_END_DATE(+) AND DHCC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID GROUP BY --&ACCT_FLEX_BAL_SEG, --&ACCT_FLEX_COST_SEG, 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'), EMP.FULL_NAME, --&LOC_FLEX_ALL_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, loc.LOCATION_ID, 'ALL', 'Y', 'VALUE'), AD.ASSET_NUMBER, AD.DESCRIPTION, ABS(DH.TRANSACTION_UNITS), AD.SERIAL_NUMBER, AD.TAG_NUMBER --Added during DT Fix order by 2, 1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13 --End of DT Fix Y OFA FAS500_XML AR FA تقرير مسئولية تصرف في الأصل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير مسئولية تصرف في الأصل Application: الأصول Source: تقرير مسئولية تصرف في الأصل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG D FA Anlagenabgänge/-neuzuordnungen nach Kostenstelle- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Anlagenabgänge/-neuzuordnungen nach Kostenstelle Application: Anlagen Source: Anlagenabgänge/-neuzuordnungen nach Kostenstelle (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG E FA Informe Responsabilidad en Enajenación de Activos: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de responsabilidad en enajenación de activos Application: Assets Source: Informe Responsabilidad en Enajenación de Activos (XML): No Admitido, Reservado para Uso Futuro Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG F FA Etat des cessions et transferts d'immobilisations par centres de coûts- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Etat des cessions et transferts d'immobilisations par centres de coûts Application: Assets Source: Etat des cessions et transferts d'immobilisations par centres de coûts (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG I FA Rapporto Responsabilità alienazione cespiti- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Responsabilità alienazione cespiti Application: Assets Source: Rapporto Responsabilità alienazione cespiti (XML) - non supportato: riservato per usi futuri Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG JA FA 職責別資産除却レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 職責別資産除却レポート Application: Assets Source: 職責別資産除却レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG KO FA 자산처분 권한 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 자산처분 권한 보고서 Application: Assets Source: 자산처분 권한 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG PTB FA Relatório de Responsabilidade sobre Alienações do Ativo- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Responsabilidade de Disposições de Ativo Application: Assets Source: Relatório de Responsabilidade sobre Alienações do Ativo (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG RU FA Инвентарный отчет о ликвидациях активов- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Инвентарный отчет о ликвидациях активов Application: Активы Source: Инвентарный отчет о ликвидациях активов (XML) - не поддерживается: зарезервировано для будущего использования Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG S FA Anläggningskasseringar per ansvarsområde - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Anläggningskasseringar per ansvarsområde - rapport Application: Assets Source: Anläggningskasseringar per ansvarsområde - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG TR FA Varlık Elden Çıkarmaları Sorumluluk Raporu- Desteklenmiyor: İleride Kullanılmak Üzere Ayrılmıştır Imported from BI Publisher Description: Varlık Elden Çıkarma Sorumluluk Raporu Application: Duran Varlıklar Source: Varlık Elden Çıkarmaları Sorumluluk Raporu (XML) - Desteklenmiyor: İleride Kullanılmak Üzere Ayrılmıştır Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG US FA Asset Disposals Responsibility Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Asset Disposals Responsibility Report Application: Assets Source: Asset Disposals Responsibility Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG ZHS FA 资产处置责任报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 资产处置责任报表 Application: 资产 Source: 资产处置责任报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS500_XML DB package: FA_FAS500_XMLP_PKG BI Publisher &acct_flex_bal_seg &acct_flex_cost_seg &acct_flex_cost_seg_w &loc_flex_all_seg :acct_bal_aprompt :acct_cc_aprompt :cat_maj_rprompt :mrc_sob_type_code :p_book :p_conc_request_id :p_end_cc :p_min_precision :p_period1 :p_start_cc :period1_fy :period1_pc :period1_pcd :period1_pod :precision :set_of_books_id 1 -20 :p_not_used_in_report Number select Accounting_Flex_Structure from FA_BOOK_CONTROLS where Book_Type_Code = :$flex$.book AR هيكل محاسبي مرن هيكل محاسبي مرن D Konto-FlexFeld-Struktur Konto-FlexFeld-Struktur E Estructura Contable Tipo de Estructura Contable F Structure clé comptable flexible Structure de clé comptable flexible I Struttura flexfield contabile Struttura del flexfield contabile JA 会計フレックスフィールド体系 会計フレックスフィールド体系 KO 회계 가변 구조 회계 가변 구조 PTB Estrutura de Flexfield Contábil Estrutura de Flexfield Contábil RU Структура ГП плана счетов Структура ГП плана счетов S Kodsträngsstruktur Kodsträngsstruktur TR Hesap Esnek Yapısı Hesap Esnekalanı Yapısı US Acct Flex Structure Accounting Flex Structure ZHS 会计科目弹性域结构 会计弹性结构 2 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 Basis-AfA-Buch E Libro Nombre del Libro Corporativo F Livre Nom du livre comptable I Registro Nome del registro aziendale JA 台帳 会計用資産台帳名 KO 장부 법인 장부명 PTB Livro Nome do Livro Corporativo RU Книга Имя корпоративной книги S Bok Namn på bolagsbok TR Defter Yardımcı Defter Adı US Book Corporate Book Name ZHS 帐簿 公司帐簿名称 3 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 Periode Periodenbezeichnung E Período Nombre del Período F Période Nom de la période I Periodo Nome del periodo JA 期間 期間名 KO 기간 기간명 PTB Período Nome do Período RU Период Имя периода S Period Periodnamn TR Dönem Dönem Adı US Period Period Name ZHS 期间 期间名称 4 30 :p_start_cc Char AR من مركز التكلفة مركز تكلفة البداية D Von Kostenstelle Von Kostenstelle E De Centro de Coste Centro de Coste Inicial F Du centre de coûts Centre de coûts de départ I Centro di costo - Da Centro di costo iniziale JA コスト・センター:自 コスト・センター:自 KO 비용 부서: 부터 시작 비용 부서 PTB Do Centro de Custo Centro de Custo Inicial RU Начальное МВЗ Начальное место возникновения затрат S Från kostnadsställe Första kostnadsställe TR İlk Maliyet Merkezi Başlangıç Maliyeti Merkezi US From Cost Center Start Cost Center ZHS 自成本中心 起始成本中心 5 40 :p_end_cc Char AR إلى مركز تكلفة إلى مركز تكلفة D Bis Kostenstelle Bis Kostenstelle E A Centro de Coste A Centro de Coste F Au centre de coûts Au centre de coûts I Centro di costo - A Centro di costo - A JA コスト・センター:至 コスト・センター:至 KO 비용 부서: 까지 비용 부서: 까지 PTB Centro de Custo - Até Centro de Custo - Até RU Конечное МВЗ Конечное МВЗ S Till kostnadsställe Till kostnadsställe TR Son Maliyet Merkezi Son Maliyet Merkezi US To Cost Center To Cost Center ZHS 至成本中心 至成本中心