ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4726F51A9E05362FB09050512Y select &FLEX_SELECT_ALL_LOW FLEX_DATA_ALL_LOW, &FLEX_SELECT_ALL_HIGH FLEX_DATA_ALL_HIGH, gbv.budget_name BUDGET_NAME, gbv.status STATUS, decode( gbv.status, 'F', gl1.meaning, gl2.meaning ) FROZEN1, gbe.name BUDGET_ORGANIZATION, geb.frozen_flag FROZEN_FLAG, gl3.meaning FROZEN2, GL_GLXRLFBL_XMLP_PKG.flex_field_all_lowformula(:FLEX_FIELD_ALL_LOW) FLEX_FIELD_ALL_LOW, GL_GLXRLFBL_XMLP_PKG.flex_field_all_highformula(:FLEX_FIELD_ALL_HIGH) FLEX_FIELD_ALL_HIGH from gl_lookups gl1, gl_lookups gl2, gl_lookups gl3, gl_budget_frozen_ranges gbfr, gl_entity_budgets geb, gl_budget_entities gbe, gl_budget_versions gbv where gbe.ledger_id = :P_LEDGER_ID and gbe.budget_entity_id = geb.budget_entity_id and gbv.budget_version_id = geb.budget_version_id and gbfr.budget_version_id (+) = geb.budget_version_id and gbfr.budget_entity_id (+) = geb.budget_entity_id and gl1.lookup_type = 'YES/NO' and gl1.lookup_code = 'Y' and gl2.lookup_type = 'YES/NO' and gl2.lookup_code = 'N' and gl3.lookup_type(+) = 'YES/NO' and gl3.lookup_code(+) = geb.frozen_flag order by gbv.budget_name, gbv.status, gbe.name, geb.frozen_flag SQLGL GLXRLFBL_XML AR GL موازنة - قائمة حسابات الموازنات المجمدة (بتنسيق XML) Imported from BI Publisher Description: كل الموازنات المجمدة. تنظيمات وحسابات Application: الأستاذ العام Source: موازنة - قائمة حسابات الموازنات المجمدة (بتنسيق XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG D GL Budget - Liste verabschiedeter Budgetkonten Imported from BI Publisher Description: Alle verabschiedeten Budgets mit zugehörigen Budgetorganisationen und Konten Application: Rechnungswesen Source: Budget - Liste verabschiedeter Budgetkonten (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG E GL Presupuesto - Listado de Cuentas de Presupuestos Congelados Imported from BI Publisher Description: Todos los presupuestos congelados, organizaciones y cuentas Application: General Ledger Source: Presupuesto - Listado de Cuentas de Presupuestos Congelados (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG F GL Budget - Liste des comptes budgétaires gelés Imported from BI Publisher Description: Tous budgets, organisations et comptes gelés Application: General Ledger Source: Budget - Liste des comptes budgétaires gelés (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG I GL Budget - Elenco conti budget congelati Imported from BI Publisher Description: Tutti i budget, le organizzazioni e i conti congelati Application: General Ledger Source: Budget - Elenco conti budget congelati (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG JA GL 予算 - 予算科目リスト確定 Imported from BI Publisher Description: 確定予算。組織と勘定 Application: General Ledger Source: 予算 - 予算科目リスト確定 (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG KO GL 예산 - 동결 예산 계정 목록 Imported from BI Publisher Description: 모든 동결 예산, 조직 및 계정 Application: General Ledger Source: 예산 - 동결 예산 계정 목록(XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG PTB GL Orçamento - Lista de Contas de Orçamentos Congeladas Imported from BI Publisher Description: Todos os orçamentos, organizações e contas congelados. Application: General Ledger Source: Orçamento - Lista de Contas de Orçamentos Congeladas (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG RU GL Бюджет - список замороженных бюджетных счетов Imported from BI Publisher Description: Все замороженные бюджеты, организации и счета Application: Главная книга Source: Бюджет - список замороженных бюджетных счетов (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG S GL Budget - Lista över frysta budgetkonton Imported from BI Publisher Description: Alla frysta budgetar, organisationer och konton Application: General Ledger Source: Budget - Lista över frysta budgetkonton (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG TR GL Bütçe - Dondurulmuş Bütçe Hesapları Listesi Imported from BI Publisher Description: Tüm dondurulmuş bütçeler, organizasyonlar ve hesaplar Application: Genel Muhasebe Source: Bütçe - Dondurulmuş Bütçe Hesapları Listesi (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG US GL Budget - Frozen Budgets Accounts Listing Imported from BI Publisher Description: All frozen budgets. organizations and accounts Application: General Ledger Source: Budget - Frozen Budgets Accounts Listing (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG ZHS GL 预算 - 冻结预算账户列表 Imported from BI Publisher Description: 所有冻结预算、组织和账户 Application: 总帐管理系统 Source: 预算 - 冻结预算账户列表 (XML) Short Name: GLXRLFBL_XML DB package: GL_GLXRLFBL_XMLP_PKG BI Publisher &flex_select_all_high &flex_select_all_low :access_set_name :flex_field_all_high :flex_field_all_low :flex_select_all_high :flex_select_all_low :ledger_name :p_access_set_id :p_conc_request_id :p_ledger_id :struct_num 1 -20 :p_access_set_id Number fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف مجموعة صلاحيات الوصول معرف مجموعة صلاحيات الوصول D ZugriffsSet-Kennung ZugriffsSet-Kennung E Id Juego de Accesos Id Juego de Accesos F ID jeu d'accès ID jeu d'accès I Id serie di accesso Id serie di accesso JA アクセス・セットID アクセス・セットID KO 액세스 세트 ID 액세스 세트 ID PTB Id do Conjunto de Acesso Id do Conjunto de Acesso RU Идент. набора доступа Идент. набора доступа S Åtkomstuppsättnings-id Åtkomstuppsättnings-id TR Erişim Kümesi No Erişim Kümesi No US Access Set Id Access Set Id ZHS 访问权限集标识 访问权限集标识 2 10 :p_ledger_id LOV Oracle GL_SRS_LEDGER_NO_SETS_STORE_ID Y select led.ledger_id id, led.name value, led.description description from gl_access_set_ledgers ac,gl_ledgers led where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and led.ledger_id=ac.ledger_id and led.object_type_code='L' order by name 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 Buch E Libro Mayor Libro Mayor F Livre Livre I Libro contabile Libro contabile JA 元帳 元帳 KO 원장 원장 PTB Razão Razão RU Книга Книга S Huvudbok Huvudbok TR Defter Defter US Ledger Ledger ZHS 分类账 分类账