ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4726D51A9E05362FB09050512Y select null C_FLEXDATA, be.name org_name, be.description org_description, l6.meaning org_password, be.start_date, be.end_date, l1.meaning entry_code, ba.currency_code, l3.meaning funds_check_level_code, l4.meaning amount_type, l5.meaning boundary_code, bv.budget_name funding_budget_name, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_acct_seg', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') C_DESC_ACCT_SEG from gl_budget_assignments ba, gl_code_combinations cc, gl_budget_entities be, gl_budorg_bc_options bc, gl_lookups l1, gl_lookups l3, gl_lookups l4, gl_lookups l5, gl_lookups l6, gl_budget_versions bv /*where cc.code_combination_id = ba.code_combination_id and ba.budget_entity_id = decode(:P_BUDGET_ENTITY_ID, '-1', ba.budget_entity_id, to_number(:P_BUDGET_ENTITY_ID))*/ where cc.code_combination_id = ba.code_combination_id and ba.budget_entity_id = decode(:P_BUDGET_ENTITY_ID_NEW, '-1', ba.budget_entity_id, to_number(:P_BUDGET_ENTITY_ID_NEW)) and ba.ledger_id = :P_LEDGER_ID and be.budget_entity_id = ba.budget_entity_id and bc.range_id(+) = ba.range_id and l1.lookup_code = ba.entry_code and l1.lookup_type = 'ENTRY_CODE' and l3.lookup_code(+) = bc.funds_check_level_code and l3.lookup_type(+) = 'FUNDS_CHECK_LEVEL' and l6.lookup_code = be.budget_password_required_flag and l6.lookup_type = 'YES/NO' and l4.lookup_code(+) = bc.amount_type and l4.lookup_type(+) = 'PTD_YTD' and l5.lookup_code(+) = bc.boundary_code and l5.lookup_type(+) = 'BOUNDARY_TYPE' and bv.budget_version_id(+) = bc.funding_budget_version_id and decode(be.security_flag,'Y', decode(fnd_data_security.check_function(1.0, 'GL_DAS_BUDGET_ORG_V','GL_DAS_BUDGET_ORG', to_char(be.budget_entity_id),null,null,null,null, fnd_global.user_name),'T','Y','N'),'Y') = 'Y' order by be.name, ba.ordering_value, &P_ORDERBY, ba.currency_code, bv.budget_name SQLGL GLXRLBOL_XML AR GL الموازنة - قائمة التنظيمات (بتنسيق XML) Imported from BI Publisher Description: قائمة تنظيم الموازنة Application: الأستاذ العام Source: الموازنة - قائمة التنظيمات (بتنسيق XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG D GL Budget - Organisation Imported from BI Publisher Description: Budgetorganisationen Application: Rechnungswesen Source: Budget - Organisation (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG E GL Presupuesto - Listado de Organizaciones Imported from BI Publisher Description: Listado de Organizaciones Presupuestarias Application: General Ledger Source: Presupuesto - Listado de Organizaciones (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG F GL Budget - Liste des organisations Imported from BI Publisher Description: Clés comptables par organisation Application: General Ledger Source: Budget - Liste des organisations (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG I GL Budget - Elenco organizzazioni Imported from BI Publisher Description: Elenco dati organizzazione budget Application: General Ledger Source: Budget - Elenco organizzazioni (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG JA GL 予算 - 組織リスト Imported from BI Publisher Description: 予算組織リスト Application: General Ledger Source: 予算 - 組織リスト (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG KO GL 예산 - 조직 목록 Imported from BI Publisher Description: 예산 조직 목록 Application: General Ledger Source: 예산 - 조직 목록(XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG PTB GL Orçamento - Lista de Organizações Imported from BI Publisher Description: Lista de Organizações Orçamentárias Application: General Ledger Source: Orçamento - Lista de Organizações (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG RU GL Бюджет - список организаций Imported from BI Publisher Description: Список бюджетных организаций Application: Главная книга Source: Бюджет - список организаций (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG S GL Budget - Lista över budgetenheter Imported from BI Publisher Description: Lista över budgetenheter Application: General Ledger Source: Budget - Lista över budgetenheter (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG TR GL Bütçe - Organizasyon Listesi Imported from BI Publisher Description: Bütçe Organizasyon Listesi Application: Genel Muhasebe Source: Bütçe - Organizasyon Listesi (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG US GL Budget - Organization Listing Imported from BI Publisher Description: Budget Organization Listing Application: General Ledger Source: Budget - Organization Listing (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG ZHS GL 预算 - 组织列表 Imported from BI Publisher Description: 预算组织列表 Application: 总帐管理系统 Source: 预算 - 组织列表 (XML) Short Name: GLXRLBOL_XML DB package: GL_GLXRLBOL_XMLP_PKG BI Publisher &p_orderby :budgetary_control_flag :das_name :enddate :ledger_name :orgdesc :orgname :orgpass :p_budget_entity_id :p_budget_entity_id_new :p_conc_request_id :p_das_id :p_flexdata :p_ledger_id :p_orderby :startdate :struct_num 1 -20 :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 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 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 分类账 分类账 3 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 Organisationsbezeichnung E Organización Presupuestaria Nombre de Organización F Organisation budgétaire Nom de l'organisation I Organizzazione budget Nome dell'organizzazione JA 予算組織 組織名 KO 예산 조직 조직명 PTB Organização Orçamentária Nome da Organização RU Бюджетная организация Организация S Budgetenhet Organisation TR Bütçe Organizasyonu Organizasyon Adı US Budget Organization Organization Name ZHS 预算组织 组织名