ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4727951A9E05362FB09050512 SELECT track.system_id SYSTEM_ID, track.group_id GROUP_ID, track.status_code STATUS_CODE, track.original_first_period ORIGINAL_FIRST_PERIOD, track.xfer_request_id REQUEST_ID, :P_BI_TRANSFER_MODE TRANSFER_MODE, rel.target_ledger_name FROM_LEDGER_NAME, elgr.chart_of_accounts_id FROM_COA_ID, flgr.name TO_LEDGER_NAME, :P_BI_FROM_PERIOD_NAME FROM_PERIOD_NAME, nvl(pmap.to_period_name, :P_BI_FROM_PERIOD_NAME) TO_PERIOD_NAME, rel.target_currency_code LEDGER_CURRENCY, coamap.name COA_MAPPING_NAME, calmap.name CALENDAR_MAPPING_NAME FROM gl_xfr_tracking track, gl_ledger_relationships rel, gl_xfr_ledger_mappings lmap, gl_ledgers elgr, gl_xfr_ledgers flgr, gl_coa_mappings coamap, gl_xfr_calendar_mappings calmap, gl_xfr_period_mappings pmap WHERE track.xfer_request_id = &g_request_id_str AND track.system_id = &g_system_id_str AND rel.target_ledger_short_name = :P_BI_FROM_LEDGER_SHORTNAME AND rel.application_id = 101 AND rel.target_ledger_id = rel.source_ledger_id AND lmap.from_ledger_id = rel.target_ledger_id AND lmap.from_ledger_currency = rel.target_currency_code AND elgr.ledger_id = rel.target_ledger_id AND flgr.ledger_id = track.ledger_id AND coamap.coa_mapping_id(+) = lmap.coa_mapping_id AND calmap.calendar_mapping_id(+) = lmap.calendar_mapping_id AND pmap.calendar_mapping_id(+) = lmap.calendar_mapping_id AND pmap.from_period_name(+) = :P_BI_FROM_PERIOD_NAME Y SQLGL GL_FUSION_TRANSFER_FULL AR GL تحويل رصيد فيوجن - كامل Imported from BI Publisher Application: الأستاذ العام Source: تحويل رصيد فيوجن - كامل Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG D GL Fusion-Saldentransfer - Vollständig Imported from BI Publisher Application: Rechnungswesen Source: Fusion-Saldentransfer - Vollständig Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG E GL Transferencia de Saldos a Fusion - Completa Imported from BI Publisher Application: General Ledger Source: Transferencia de Saldos a Fusion - Completa Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG F GL Transfert des soldes vers Fusion - Complet Imported from BI Publisher Application: General Ledger Source: Transfert des soldes vers Fusion - Complet Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG I GL Trasferimento saldo Fusion - Completo Imported from BI Publisher Application: General Ledger Source: Trasferimento saldo Fusion - Completo Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG JA GL Fusion残高振替 - 全部 Imported from BI Publisher Application: General Ledger Source: Fusion残高振替 - 全部 Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG KO GL Fusion 잔액 이전 - 전체 Imported from BI Publisher Application: General Ledger Source: Fusion 잔액 이전 - 전체 Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG PTB GL Transferência de Saldo do Fusion - Total Imported from BI Publisher Application: General Ledger Source: Transferência de Saldo do Fusion - Total Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG RU GL Перенос сальдо Fusion - полный Imported from BI Publisher Application: Главная книга Source: Перенос сальдо Fusion - полный Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG S GL Överföring av fusionssaldo - fullständig Imported from BI Publisher Application: General Ledger Source: Överföring av fusionssaldo - fullständig Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG TR GL Fusion Bakiye Transferi - Tam Imported from BI Publisher Application: Genel Muhasebe Source: Fusion Bakiye Transferi - Tam Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG US GL Fusion Balance Transfer - Full Imported from BI Publisher Application: General Ledger Source: Fusion Balance Transfer - Full Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG ZHS GL Fusion 余额传送 - 全部 Imported from BI Publisher Application: 总帐管理系统 Source: Fusion 余额传送 - 全部 Short Name: GL_FUSION_TRANSFER_FULL DB package: GL_FUSION_TRANSFER_PKG BI Publisher &g_request_id_str &g_system_id_str :g_request_id_str :g_system_id_str :p_bi_access_set_id :p_bi_debug_mode :p_bi_from_ledger_id :p_bi_from_ledger_shortname :p_bi_from_period_name :p_bi_retcode :p_bi_transfer_mode :p_conc_request_id 1 -40 :p_bi_from_ledger_id Number SELECT target_ledger_id FROM gl_ledger_relationships WHERE target_ledger_short_name = :$flex$.from_ledger AND application_id = 101 AND target_ledger_id = source_ledger_id Y US GL_SRS_LEDGER_ID_UNVALIDATED 2 -30 :p_bi_transfer_mode Char F Y AR طور التحويل D Transfermodus E Modo de Transferencia F Mode de transfert I Modalità trasferimento JA 転送モード KO 이전 모드 PTB Modo de Transferência RU Режим переноса S Överföringsläge TR Transfer Modu US Transfer Mode ZHS 传送模式 3 -20 :p_bi_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة صلاحيات الوصول D ZugriffsSet-Kennung E Id Juego de Accesos F ID jeu d'accès I Id serie di accesso JA アクセス・セットID KO 액세스 세트 ID PTB Id do Conjunto de Acesso RU Идент. набора доступа S Åtkomstuppsättnings-id TR Erişim Kümesi No US Access Set Id ZHS 访问权限集标识 4 10 :p_bi_from_ledger_shortname LOV Oracle GL_SRS_TRANSFER_LEDGERS Y select l.target_ledger_short_name id, l.target_ledger_name value, null description from gl_access_set_ledgers ac,gl_ledger_relationships l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and ac.access_privilege_code='F' and l.target_ledger_id=ac.ledger_id and l.application_id=101 and exists (select 'transfer ledger' from gl_xfr_ledger_mappings map where map.from_ledger_id=l.target_ledger_id and map.from_ledger_currency =l.target_currency_code) order by l.target_ledger_name select name from gl_ledgers L where ledger_id = gl_access_set_security_pkg.get_default_ledger_id(fnd_profile.value('GL_ACCESS_SET_ID'), 'F') and EXISTS (SELECT 'transfer ledger' FROM gl_xfr_ledger_mappings map WHERE map.from_ledger_id = L.LEDGER_ID and map.from_ledger_currency = L.currency_code) Y AR من دفتر الأستاذ D Von Buch E De Libro Mayor F Livre d'origine I Libro contabile - Da JA 元帳:自 KO From 원장 PTB Razão - De RU Книга с S Från bokföringsbok TR İlk Defter US From Ledger ZHS 自分类帐 5 20 :p_bi_from_period_name LOV Oracle GL_SRS_TRANSFER_PERIODS Y select period_name id, period_name value, null description from gl_period_statuses ps where application_id=101 and ledger_id=:$flex$.gl_srs_ledger_id_unvalidated and closing_status in ('O','C','P') and exists (select 'good period' from gl_ledger_relationships rel, gl_xfr_ledger_mappings lgr where rel.target_ledger_short_name =:$flex$.gl_srs_transfer_ledgers and rel.application_id=101 and rel.target_ledger_id=rel.source_ledger_id and lgr.from_ledger_id=rel.target_ledger_id and lgr.from_ledger_currency=rel.target_currency_code and ( lgr.calendar_mapping_id is null or exists (select 'matching period' from gl_xfr_period_mappings per where per.calendar_mapping_id=lgr.calendar_mapping_id and per.from_period_name=ps.period_name))) order by effective_period_num desc Y AR من الفترة D Von Periode E De Período F Période - De I Periodo - Da JA 期間:自 KO 기간: 부터 PTB Período - De RU Начальный период S Från period TR İlk Dönem US From Period ZHS 自期间 :$flex$.from_ledger From Ledger GL_SRS_LEDGER_ID_UNVALIDATED :$flex$.gl_srs_ledger_id_unvalidated GL_SRS_LEDGER_ID_UNVALIDATED From Period :$flex$.gl_srs_transfer_ledgers From Ledger From Period