ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725F51A9E05362FB09050512Y select null FLEXDATA1_H, (nvl(bal.period_net_dr,0) - nvl(bal.period_net_cr,0)) Detail_Bal, b.name Batch_Name, h.name Header_Name, l.je_line_num Line_Num, h.posted_date Header_Post_Date, decode(:P_CURRENCY_CODE,'STAT', decode(h.currency_code, 'STAT', decode(sign(nvl(l.stat_amount,0)), '1', nvl(l.entered_dr,0)+nvl(l.stat_amount,0), nvl(l.entered_dr,0)), decode(sign(nvl(l.stat_amount,0)), '1', nvl(l.stat_amount,0),0)), nvl(l.entered_dr,0)) Line_Debits, decode(:P_CURRENCY_CODE,'STAT', decode(h.currency_code,'STAT', decode(sign(nvl(l.stat_amount,0)),'-1', nvl(l.entered_cr,0)-nvl(l.stat_amount,0), nvl(l.entered_cr,0)), decode(sign(nvl(l.stat_amount,0)),'-1', abs(l.stat_amount), 0)), nvl(l.entered_cr,0)) Line_Credits, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata1_dsp', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA1_DSP from gl_je_batches b, gl_je_headers h, gl_je_lines l, gl_code_combinations cc, gl_balances bal, gl_account_hierarchies hi where b.status = 'P' AND b.actual_flag = 'B' AND b.je_batch_id = h.je_batch_id AND h.ledger_id = :P_LEDGER_ID AND h.period_name||'' = :P_PERIOD_NAME AND (h.currency_code = DECODE(:P_CURRENCY_CODE,'STAT', DECODE(L.STAT_AMOUNT,NULL,'****',h.currency_code),:P_CURRENCY_CODE) OR h.currency_code = :P_CURRENCY_CODE) AND h.status = 'P' AND h.actual_flag = 'B' AND h.budget_version_id = :P_BUDGET_VERSION_ID AND h.je_header_id = l.je_header_id AND l.ledger_id = :P_LEDGER_ID AND l.status = 'P' AND l.period_name = :P_PERIOD_NAME AND l.code_combination_id = bal.code_combination_id AND cc.code_combination_id = hi.detail_code_combination_id AND bal.ledger_id = :P_LEDGER_ID AND bal.currency_code = :P_CURRENCY_CODE AND bal.actual_flag = 'B' AND bal.budget_version_id = :P_BUDGET_VERSION_ID AND bal.period_name = :P_PERIOD_NAME AND bal.code_combination_id = hi.detail_code_combination_id AND nvl(bal.translated_flag, 'R') = 'R' AND hi.ledger_id = :P_LEDGER_ID AND hi.summary_code_combination_id = :SUMMARY_CODE_COMBINATION_ID &DAS_WHERE order by &FLEX_ORDERBY, b.name, h.name, l.je_line_num SQLGL GLXBCSD_XML AR GL الموازنة - إجمالية/تفصيلية (بتنسيق XML) Imported from BI Publisher Description: تقرير الموازنة إجمالي/تفصيلي Application: الأستاذ العام Source: الموازنة - إجمالية/تفصيلية (بتنسيق XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG D GL Budget - Summen/Einzel Imported from BI Publisher Description: Budget - Summen/Einzel Application: Rechnungswesen Source: Budget - Summen/Einzel (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG E GL Presupuesto - Resumen/Detalle Imported from BI Publisher Description: Informe Presupuesto Resumen/Parcial Application: General Ledger Source: Presupuesto - Resumen/Detalle (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG F GL Budget - Synthèse/détail Imported from BI Publisher Description: Budget de synthèse/détail Application: General Ledger Source: Budget - Synthèse/détail (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG I GL Budget - Sintetico/Dettagli Imported from BI Publisher Description: Rapporto Budget sintetico/dettagli Application: General Ledger Source: Budget - Sintetico/Dettagli (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG JA GL 予算 - 要約/詳細 Imported from BI Publisher Description: 要約/詳細予算レポート Application: General Ledger Source: 予算 - 要約/詳細 (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG KO GL 예산 - 요약/상세 Imported from BI Publisher Description: 요약/상세 예산 보고서 Application: General Ledger Source: 예산 - 요약/상세(XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG PTB GL Orçamento - Resumido/Detalhado Imported from BI Publisher Description: Relatório de Orçamento Sumariado/Detalhado Application: General Ledger Source: Orçamento - Resumido/Detalhado (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG RU GL Бюджет - сводный/подробный Imported from BI Publisher Description: Отчет по сводному/подробному бюджету Application: Главная книга Source: Бюджет - сводный/подробный (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG S GL Budget - Summering/detalj Imported from BI Publisher Description: Budget - översikt/detalj Application: General Ledger Source: Budget - Summering/detalj (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG TR GL Bütçe - Özet/Detay Imported from BI Publisher Description: Özet/Detay Bütçe Raporu Application: Genel Muhasebe Source: Bütçe - Özet/Detay (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG US GL Budget - Summary/Detail Imported from BI Publisher Description: Summary/Detail Budget Report Application: General Ledger Source: Budget - Summary/Detail (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG ZHS GL 预算 - 汇总/明细 Imported from BI Publisher Description: 汇总/明细预算报表 Application: 总帐管理系统 Source: 预算 - 汇总/明细 (XML) Short Name: GLXBCSD_XML DB package: GL_GLXBCSD_XMLP_PKG BI Publisher &das_where &flex_orderby :access_set_name :budget_name :das_where :flex_orderby :flex_where :flexdata :funct_curr_code :ledger_name :p_access_set_id :p_budget_version_id :p_conc_request_id :p_currency_code :p_ledger_id :p_period_name :p_segment_values :struct_num :summary_code_combination_id 1 -30 :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 -20 :gl_chart_of_accounts_id Number SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id piano dei conti JA 勘定体系ID 勘定体系ID KO 계정 코드집 ID 계정 코드집 ID PTB Id do Plano de Contas Id do Plano de Contas RU Идент. плана счетов Идент. плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart of Accounts Id Chart of Accounts Id ZHS 科目表标识 科目表标识 3 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 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_version_id LOV Oracle GL_SRS_BUDGETS Y select bv.budget_version_id id, b.budget_name value, b.description description from gl_budget_versions bv,gl_budgets b where bv.budget_name=b.budget_name and b.ledger_id=:$flex$.gl_srs_ledger_no_sets_store_id order by upper(b.budget_name) Y AR الموازنة اسم الموازنة D Budget Budgetbezeichnung E Presupuesto Nombre del presupuesto F Budgétaire Nom du budget I Budget Nome budget JA 予算 予算名 KO 예산 예산명 PTB Orçamento Nome do Orçamento RU Бюджет Имя бюджета S Budget Budget TR Bütçe Bütçe Adı US Budget Budget Name ZHS 预算 预算名称 5 30 :p_segment_values Char Y AR الحساب الإجمالي الحساب الإجمالي D Summenkonto Summenkonto E Cuenta Resumen Cuenta Resumen F Compte de synthèse Compte de synthèse I Conto sintetico Conto sintetico JA 要約勘定 要約勘定 KO 요약 계정 요약 계정 PTB Conta Sumária Conta Sumária RU Сводный счет Сводный счет S Summeringskonto Summeringskonto TR Özet Hesap Özet Hesap US Summary Account Summary Account ZHS 汇总账户 汇总账户 6 40 :p_currency_code LOV Oracle GL_SRS_CURRENCIES Y select currency_code id, currency_code value, null description from fnd_currencies_vl where enabled_flag in ('Y','N') order by currency_code Y AR العملة رمز العملة D Währung Währungsschlüssel E Divisa Código de Divisa F Devise Code devise I Divisa Codice divisa JA 通貨 通貨コード KO 통화 통화 코드 PTB Moeda Cód. da Moeda RU Валюта Код валюты S Valuta Valutakod TR Para Birimi Para Birimi Kodu US Currency Currency Code ZHS 币种 币种代码 7 50 :p_period_name LOV Oracle GL_SRS_BUDGET_PERIODS Y select ps.period_name id, ps.period_name value, null description from gl_period_statuses ps,gl_budget_period_ranges bpr where bpr.budget_version_id=:$flex$.gl_srs_budgets and bpr.open_flag='O' and ps.application_id=101 and ps.ledger_id=:$flex$.gl_srs_ledger_no_sets_store_id and ps.period_year=bpr.period_year and ps.period_num between bpr.start_period_num and bpr.end_period_num order by ps.period_year desc,ps.period_num desc Y AR الفترة اسم الفترة D Periode Periodenbezeichnung E Período Nombre del Período F Période Nom de la période I Periodo Nome del periodo JA 期間 期間名 KO 기간 기간명 PTB Período Nome do Período RU Период Имя периода S Period Periodnamn TR Dönem Dönem Adı US Period Period Name ZHS 期间 期间名称