ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4726051A9E05362FB09050512Y select bar.budget_entity_id budget_entity_id1, bar.sequence_number LINE, &SELECT_FLEX_LOW FLEXDATA_LOW, &SELECT_FLEX_HIGH FLEXDATA_HIGH, lec.description TYPE, bar.currency_code CURRENCY, lst.meaning STATUS, lfcl.meaning FUNDS_CHECK_LEVEL, lat.meaning AMOUNT_TYPE, lbc.meaning BOUNDARY, bv.budget_name FUNDING_BUDGET, GL_GLXBOR_XMLP_PKG.flexfield_lowformula(&SELECT_FLEX_LOW) FLEXFIELD_LOW, GL_GLXBOR_XMLP_PKG.flexfield_highformula(&SELECT_FLEX_HIGH) FLEXFIELD_HIGH from gl_lookups lec, gl_lookups lst, gl_lookups lfcl, gl_lookups lat, gl_lookups lbc, gl_budget_versions bv, gl_budorg_bc_options bc, gl_budget_assignment_ranges bar where bar.ledger_id = :P_LEDGER_ID /*and bar.budget_entity_id = decode(:P_BUDGET_ENTITY_ID, '-1', bar.budget_entity_id, to_number(:P_BUDGET_ENTITY_ID))*/ and bar.budget_entity_id = decode(:P_BUDGET_ENTITY_ID1, '-1', bar.budget_entity_id, to_number(:P_BUDGET_ENTITY_ID1)) and bc.range_id(+) = bar.range_id and lec.lookup_type(+) = 'ENTRY_CODE' and lec.lookup_code(+) = bar.entry_code and lst.lookup_type(+) = 'GLBAAR_STATUSES' and lst.lookup_code(+) = bar.status and lfcl.lookup_type(+) = 'FUNDS_CHECK_LEVEL' and lfcl.lookup_code(+) = bc.funds_check_level_code and lat.lookup_type(+) = 'PTD_YTD' and lat.lookup_code(+) = bc.amount_type and lbc.lookup_type(+) = 'BOUNDARY_TYPE' and lbc.lookup_code(+) = bc.boundary_code and bv.budget_version_id(+) = bc.funding_budget_version_id and bar.budget_entity_id=:budget_entity_id --and bar.budget_entity_id=:P_BUDGET_ENTITY_ID1 order by bar.sequence_number, bv.budget_name SQLGL GLXBOR_XML AR GL الموازنة - قائمة مدى التنظيمات (بتنسيق XML) Imported from BI Publisher Description: قائمة مدى تنظيم الموازنة Application: الأستاذ العام Source: الموازنة - قائمة مدى التنظيمات (بتنسيق XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG D GL Budget - Organisationsbereiche Imported from BI Publisher Description: Budget - Organisationsbereiche Application: Rechnungswesen Source: Budget - Organisationsbereiche (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG E GL Presupuesto - Listado de Rangos de Organizaciones Imported from BI Publisher Description: Listado de Rangos de Organizaciones Presupuestarias Application: General Ledger Source: Presupuesto - Listado de Rangos de Organizaciones (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG F GL Budget - Fourchettes de comptes/organisation Imported from BI Publisher Description: Organisations budgétaires par fourchettes Application: General Ledger Source: Budget - Fourchettes de comptes/organisation (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG I GL Budget - Elenco intervalli organizzazione Imported from BI Publisher Description: Elenco dati organizzazione budget per intervalli numeri di conto Application: General Ledger Source: Budget - Elenco intervalli organizzazione (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG JA GL 予算 - 組織範囲リスト Imported from BI Publisher Description: 予算組織範囲リスト Application: General Ledger Source: 予算 - 組織範囲リスト (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG KO GL 예산 - 조직범위 목록 Imported from BI Publisher Description: 예산 조직 범위 목록 Application: General Ledger Source: 예산 - 조직범위 목록(XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG PTB GL Orçamento - Lista de Faixas de Organizações Imported from BI Publisher Description: Lista de Faixas de Organizações Orçamentárias Application: General Ledger Source: Orçamento - Lista de Faixas de Organizações (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG RU GL Бюджет - список диапазонов организации Imported from BI Publisher Description: Список диапазонов бюджетной организации Application: Главная книга Source: Бюджет - список диапазонов организации (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG S GL Budget - Lista över enhetsintervall Imported from BI Publisher Description: Lista över budgetenhetsintervall Application: General Ledger Source: Budget - Lista över enhetsintervall (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG TR GL Bütçe - Organizasyon Aralığı Listesi Imported from BI Publisher Description: Bütçe Organizasyon Aralığı Listesi Application: Genel Muhasebe Source: Bütçe - Organizasyon Aralığı Listesi (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG US GL Budget - Organization Range Listing Imported from BI Publisher Description: Budget Organization Range Listing Application: General Ledger Source: Budget - Organization Range Listing (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG ZHS GL 预算 - 组织范围列表 Imported from BI Publisher Description: 预算组织范围列表 Application: 总帐管理系统 Source: 预算 - 组织范围列表 (XML) Short Name: GLXBOR_XML DB package: GL_GLXBOR_XMLP_PKG BI Publisher &select_flex_high &select_flex_low :budget_entity_id :c_delimiter :das_name :ledger_name :p_budget_entity_id :p_budget_entity_id1 :p_conc_request_id :p_das_id :p_funds_check_on :p_ledger_id :select_flex_high :select_flex_low :struct_num 1 -30 :p_das_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة الوصول للبيانات معرف مجموعة الوصول للبيانات D Kennung DatenzugriffsSet Kennung DatenzugriffsSet E Id Juego de Accesos a Datos Id juego de accesos a datos F ID jeu d'accès aux données ID jeu d'accès aux données I Id serie di accesso dati Id della serie di accesso ai dati JA データ・アクセス・セットID データ・アクセス・セットID KO 데이터 액세스 세트 ID 데이터 액세스 세트 ID PTB Id do Conjunto de Acesso a Dados Id do Conjunto de Acesso a Dados RU Идент. набора доступа к данным Идент. набора доступа к данным S Id för dataåtkomstuppsättning Id för dataåtkomstuppsättning TR Veri Erişim Kümesi No Veri Erişim Kümesi No US Data Access Set Id Data Access Set Id ZHS 数据访问权限集标识 数据访问权限集标识 2 -20 :p_funds_check_on Char SELECT enable_budgetary_control_flag from gl_ledgers WHERE ledger_id = :$flex$.ledger AR فحص الأموال في فحص الأموال في D Mittelprüfung für Mittelprüfung für E Comprobación de Fondos Activada Comprobación de Fondos Activada F Contrôle du disponible activé Contrôle du disponible activé I Controllo fondi attivato Controllo dei fondi attivato JA 残余予算チェック 残余予算チェック KO 자금 점검 일자 자금 점검 일자 PTB Checagem de Fundos Ativada Checagem de Fundos Ativada RU Дата проверки фондов Дата проверки фондов S Kontroll av medel Kontroll av medel TR Fon Kontrolü Açık Fon Kontrolü Açık US Funds Check On Funds Check On ZHS 资金检查 资金检查 3 10 :p_ledger_id LOV Oracle GL_SRS_LEDGERS_BY_COA Y select l.ledger_id id, l.name value, l.description description from gl_access_sets ac,gl_ledgers l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.chart_of_accounts_id=ac.chart_of_accounts_id and object_type_code='L' and ledger_category_code<>'NONE' and nvl(complete_flag,'Y')='Y' order by value,description select name from gl_ledgers where ledger_id = gl_access_set_security_pkg.get_default_ledger_id(fnd_profile.value('GL_ACCESS_SET_ID'), 'R') Y AR الأستاذ معرف الأستاذ D Buch Buchkennung E Libro Mayor Id Libro Mayor F Livre ID livre I Libro contabile Id sezionale JA 元帳 元帳ID KO 원장 원장 ID PTB Razão ID do Razão RU Книга Идентификатор книги S Huvudbok Huvudboks-id TR Defter Defter No US Ledger Ledger ID ZHS 分类账 分类账标识 4 20 :p_budget_entity_id LOV Oracle GL_SRS_BUDORGS_ALL_W_ID Y select budget_entity_id id, name value, description description from gl_budget_entities where (ledger_id=:$flex$.gl_srs_ledgers_by_coa or ledger_id=-1) and decode(security_flag,'Y', decode(fnd_data_security.check_function(1.0, 'GL_DAS_BUDGET_ORG_V','GL_DAS_BUDGET_ORG', to_char(budget_entity_id),null,null,null,null, fnd_global.user_name),'T','Y','N'),'Y')='Y' order by upper(name),description Y AR تنظيم الموازنة تنظيم الموازنة D Budgetorganisation Budgetorganisation E Organización Presupuestaria Organización Presupuestaria F Organisation budgétaire Organisation budgétaire I Organizzazione budget Organizzazione budget JA 予算組織 予算組織 KO 예산 조직 예산 조직 PTB Organização Orçamentária Organização Orçamentária RU Бюджетная организация Бюджетная организация S Budgetenhet Budgetenhet TR Bütçe Organizasyonu Bütçe Organizasyonu US Budget Organization Budget Organization ZHS 预算组织 预算组织