ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4727151A9E05362FB09050512Y select gll2.meaning line_type, glafl.amount amount, decode(glafl.amount, NULL, null, NULL) C_FLEXDATA, glafl.ledger_action_code ledger_action_code, glafl.segment_types_key segment_types_key, glafl.ledger_currency ledger_currency, gll8.meaning currency_type, glafl.entered_currency entered_currency, glafl.amount_type amount_type, gll3.meaning relative_period, gll5.description balance_type, decode(glafl.actual_flag, 'E', glet.encumbrance_type, glbv.budget_name) budget_encumbrance_type, --glafl.allocation_formula_id, glafl.allocation_formula_id allocation_formula_id1, --fnd_flex_xml_publisher_apis.process_kff_combination_1('accountingflexfield', 'SQLGL', 'GLLE', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') AccountingFlexfield, GL_GLXRLMAB_XMLP_PKG.account_action_codeformula(glafl.amount, glafl.ledger_action_code, glafl.segment_types_key) Account_Action_Code from gl_alloc_formula_lines glafl, gl_encumbrance_types glet, gl_budget_versions glbv, gl_lookups gll2, gl_lookups gll3, gl_lookups gll5, gl_lookups gll8, gl_ledgers glled, gl_ledger_relationships gllr where glafl.budget_version_id = glbv.budget_version_id (+) and glafl.encumbrance_type_id = glet.encumbrance_type_id (+) and gll2.lookup_type = 'ALLOCATION_LINE_TYPE' and gll2.lookup_code = to_char(glafl.line_number) and gll3.lookup_type (+) = 'PERIOD CODE' and glafl.relative_period = gll3.lookup_code (+) and gll5.lookup_type (+) = 'BATCH_TYPE' and glafl.actual_flag = gll5.lookup_code (+) and gll8.lookup_type (+) = 'GL_CURRENCY_TYPE' and gll8.lookup_code (+) = glafl.currency_type and glled.ledger_id (+) = glafl.ledger_id and gllr.target_ledger_id (+) = glafl.ledger_id and gllr.source_ledger_id (+) = glafl.ledger_id and gllr.target_currency_code (+) = glafl.ledger_currency and glafl.allocation_formula_id=:allocation_formula_id order by glafl.line_number SQLGL GLXRLMAB_XML AR GL أخرى - قائمة صيغ التخصيص المجمع (بتنسيق XML) Imported from BI Publisher Description: تقرير قائمة صيغ التخصيصات المجمعة Application: الأستاذ العام Source: أخرى - قائمة صيغ التخصيص المجمع (بتنسيق XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG D GL Sonstiges - Umlageformeln Imported from BI Publisher Description: Umlageformeln Application: Rechnungswesen Source: Sonstiges - Umlageformeln (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG E GL Otros - Listado de Fórmulas de Reparto Masivo Imported from BI Publisher Description: Listado de Fórmulas de Reparto Masivo Application: General Ledger Source: Otros - Listado de Fórmulas de Reparto Masivo (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG F GL Autres - Liste formules de répartitions HV Imported from BI Publisher Description: Liste des formules de répartition en haut volume Application: General Ledger Source: Autres - Liste formules de répartitions HV (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG I GL Altro - Elenco formule allocazione di massa Imported from BI Publisher Description: Rapporto Elenco formule allocazione di massa Application: General Ledger Source: Altro - Elenco formule allocazione di massa (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG JA GL その他 - 一括配賦算式一覧表 Imported from BI Publisher Description: 一括配賦算式リストレポート Application: General Ledger Source: その他 - 一括配賦算式一覧表 (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG KO GL 기타 - 일괄 배부 공식 목록 Imported from BI Publisher Description: 일괄 배부 공식 목록 보고서 Application: General Ledger Source: 기타 - 일괄 배부 공식 목록(XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG PTB GL Outro - Lista de Fórmulas de Alocação em Massa Imported from BI Publisher Description: Relatório de Lista de Fórmulas de Rateios Application: General Ledger Source: Outro - Lista de Fórmulas de Alocação em Massa (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG RU GL Другое - список формул масс-размещения Imported from BI Publisher Description: Список формул масс-размещения Application: Главная книга Source: Другое - список формул масс-размещения (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG S GL Övrigt - Lista över massallokeringsformler Imported from BI Publisher Description: Massallokeringsformler - listrapport Application: General Ledger Source: Övrigt - Lista över massallokeringsformler (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG TR GL Diğer - Toplu Paylaştırma Formül Listesi Imported from BI Publisher Description: Toplu Paylaştırmalar Formül Liste Raporu Application: Genel Muhasebe Source: Diğer - Toplu Paylaştırma Formül Listesi (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG US GL Other - MassAllocation Formula Listing Imported from BI Publisher Description: Mass Allocations Formula Listing Report Application: General Ledger Source: Other - MassAllocation Formula Listing (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG ZHS GL 其它 - 成批分配公式列表 Imported from BI Publisher Description: 成批分配公式列表报表 Application: 总帐管理系统 Source: 其它 - 成批分配公式列表 (XML) Short Name: GLXRLMAB_XML DB package: GL_GLXRLMAB_XMLP_PKG BI Publisher :allocation_formula_id :delimiter :p_alloc_batch_name :p_conc_request_id :p_struct_num :sel_flexdata 1 -20 :p_struct_num Number SELECT chart_of_accounts_id FROM GL_ACCESS_SETS WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR GL_SRS_COA_UNVALIDATED معرف جدول تصنيف الحسابات D GL_SRS_COA_UNVALIDATED Kontenplankennung E GL_SRS_COA_UNVALIDATED Id Plan de Cuentas F GL_SRS_COA_UNVALIDATED ID plan de comptes I GL_SRS_COA_UNVALIDATED Id del piano dei conti JA GL_SRS_COA_UNVALIDATED 勘定体系ID KO GL_SRS_COA_UNVALIDATED 계정 코드집 ID PTB GL_SRS_COA_UNVALIDATED ID do Plano de Contas RU GL_SRS_COA_UNVALIDATED Идент. плана счетов S GL_SRS_COA_UNVALIDATED Kontoplans-id TR GL_SRS_COA_UNVALIDATED Hesap Planı No US GL_SRS_COA_UNVALIDATED Chart of Accounts ID ZHS GL_SRS_COA_UNVALIDATED 科目表标识 2 10 :p_alloc_batch_name LOV Oracle GL_SRS_MASS_ALLOC_BATCHES Y select name id, name value, description description from gl_alloc_batches where chart_of_accounts_id=:$flex$.gl_srs_coa_unvalidated and decode(security_flag,'Y',decode(fnd_data_security.check_function(1.0,'GL_DAS_MASSALLOCATION_V','GL_DAS_MASSALLOCATION',to_char(allocation_batch_id),null,null,null,null,fnd_global.user_name),'T','Y','N'),'Y')='Y' order by name AR اسم مجموعة التخصيص اسم مجموعة التخصيص D Umlagestapel Umlagestapel E Nombre del Lote de Reparto Nombre del Lote de Reparto F Nom du lot de répartitions Nom du lot de répartitions I Nome batch allocazioni Nome del batch di allocazioni JA 一括配賦バッチ名 一括配賦バッチ名 KO 배부 뱃치명 배부 뱃치명 PTB Nome do Lote de Alocação Nome do Lote de Alocação RU Имя пакета размещений Имя пакета размещений S Tilldelningsbunt Tilldelningsbunt TR Paylaştırma İşlem Grup Adı Paylaştırma İşlem Grup Adı US Allocation Batch Name Allocation Batch Name ZHS 分配批名 分配批名