ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725B51A9E05362FB09050512Y SELECT &P_HINT_CLAUSE LGR.NAME LEDGER_NAME, LGR.CURRENCY_CODE LEDGER_CURRENCY, LGR.LEDGER_ID LEDGER_ID, GLB.JE_BATCH_ID BATCH_ID, GLB.NAME BATCH_NAME, GLB.DESCRIPTION BATCH_DESC, GLB.STATUS BATCH_STATUS_CODE, GLB.POSTED_DATE BATCH_POSTED_DATE, GLB.DEFAULT_PERIOD_NAME BATCH_PERIOD_NAME, GLB.DEFAULT_EFFECTIVE_DATE BATCH_EFFECTIVE_DATE, GLB.ACTUAL_FLAG ACTUAL_FLAG, GLB.AVERAGE_JOURNAL_FLAG AVERAGE_JOURNAL_FLAG, GLB.APPROVAL_STATUS_CODE APPROVAL_STATUS_CODE, GLB.BUDGETARY_CONTROL_STATUS BUD_CONTROL_STATUS, GLB.RUNNING_TOTAL_DR BATCH_TOT_DR, GLB.RUNNING_TOTAL_CR BATCH_TOT_CR, GLB.RUNNING_TOTAL_ACCOUNTED_DR BATCH_TOT_ACC_DR, GLB.RUNNING_TOTAL_ACCOUNTED_CR BATCH_TOT_ACC_CR, GLB.DATE_CREATED BATCH_DATE_CREATED, GLH.JE_HEADER_ID HDR_ID, GLH.NAME HDR_NAME, GLH.DESCRIPTION HDR_DESC, GLH.TAX_STATUS_CODE TAX_STATUS_CODE, GLH.RUNNING_TOTAL_DR HDR_TOT_DR, GLH.RUNNING_TOTAL_CR HDR_TOT_CR, GLH.RUNNING_TOTAL_ACCOUNTED_DR HDR_TOT_ACC_DR, GLH.RUNNING_TOTAL_ACCOUNTED_CR HDR_TOT_ACC_CR, GLH.CURRENCY_CODE HDR_CURR_CODE, GLH.CURRENCY_CONVERSION_DATE CONVERSION_DATE, GLH.CURRENCY_CONVERSION_RATE CONVERSION_RATE, DCT.USER_CONVERSION_TYPE CONVERSION_TYPE, GLH.BUDGET_VERSION_ID BUDGET_VERSION_ID, GLH.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, GLH.EXTERNAL_REFERENCE HDR_EXTREFERENCE, GLH.LAST_UPDATE_DATE HDR_LAST_UPDATE_DATE, GLH.DEFAULT_EFFECTIVE_DATE HDR_EFF_DATE, GLH.DOC_SEQUENCE_ID DOC_SEQ_ID, DOCSEQ.NAME DOC_SEQ_NAME, GLH.DOC_SEQUENCE_VALUE DOC_SEQ_VALUE, FU.USER_NAME HDR_LAST_UPDATED_BY, GJS.USER_JE_SOURCE_NAME HDR_SOURCE, GJC.USER_JE_CATEGORY_NAME HDR_CATEGORY, GLL.JE_LINE_NUM JE_LINE_NUM, GLL.TAX_CODE_ID TAX_CODE_ID, GLL.TAX_TYPE_CODE TAX_TYPE_CODE, GLL.DESCRIPTION LINE_DESC, GLL.ENTERED_DR ENTERED_DR, GLL.ENTERED_CR ENTERED_CR, GLL.ACCOUNTED_DR ACCOUNTED_DR, GLL.ACCOUNTED_CR ACCOUNTED_CR, GLL.STAT_AMOUNT STAT_AMOUNT, GLL.EFFECTIVE_DATE EFFECTIVE_DATE, GLL.REFERENCE_1 REFERENCE1, GLL.REFERENCE_2 REFERENCE2, GLL.REFERENCE_3 REFERENCE3, GLL.REFERENCE_4 REFERENCE4, GLL.REFERENCE_5 REFERENCE5, GLL.REFERENCE_6 REFERENCE6, GLL.REFERENCE_7 REFERENCE7, GLL.REFERENCE_8 REFERENCE8, GLL.REFERENCE_9 REFERENCE9, GLL.REFERENCE_10 REFERENCE10, SUBDOCSEQ.NAME SUB_DOC_SEQ_NAME, GLL.SUBLEDGER_DOC_SEQUENCE_ID SUB_DOC_SEQ_ID, GLL.SUBLEDGER_DOC_SEQUENCE_VALUE SUB_DOC_SEQ_VAL, &SELECT_ACCOUNT ACCOUNT, &SELECT_BAL_SEGMENT BAL_SEG_VAL, &SELECT_ACCT_SEGMENT ACCT_SEG_VAL, fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_seg_val', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') COST_CTR_SEG_VAL, &SELECT_SECONDARY_SEGMENT ADDITIONAL_SEGMENT_VALUE, GL_GLWACCTR_XMLP_PKG.batch_typeformula(GLB.ACTUAL_FLAG) BATCH_TYPE, GL_GLWACCTR_XMLP_PKG.batch_statusformula(GLB.STATUS) BATCH_STATUS, GL_GLWACCTR_XMLP_PKG.approval_statusformula(GLB.APPROVAL_STATUS_CODE) APPROVAL_STATUS, GL_GLWACCTR_XMLP_PKG.budget_ctrl_statusformula(GLB.BUDGETARY_CONTROL_STATUS) BUDGET_CTRL_STATUS, GL_GLWACCTR_XMLP_PKG.jrnl_typeformula(GLB.AVERAGE_JOURNAL_FLAG) JRNL_TYPE, GL_GLWACCTR_XMLP_PKG.budget_nameformula(GLH.BUDGET_VERSION_ID) BUDGET_NAME, GL_GLWACCTR_XMLP_PKG.encumbrance_typeformula(GLH.ENCUMBRANCE_TYPE_ID) ENCUMBRANCE_TYPE, GL_GLWACCTR_XMLP_PKG.tax_statusformula(GLH.TAX_STATUS_CODE) TAX_STATUS, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_dsp', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') ACCOUNT_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') ACCOUNT_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('bal_seg_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'DESCRIPTION') BAL_SEG_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_seg_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'DESCRIPTION') ACCT_SEG_DESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_seg_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'DESCRIPTION') COST_CTR_SEG_DESC, &ADDITIONAL_SEGMENT_DESC ADDITIONAL_SEGMENT_DESC, GL_GLWACCTR_XMLP_PKG.tax_typeformula(GLL.TAX_TYPE_CODE) TAX_TYPE, GL_GLWACCTR_XMLP_PKG.tax_codeformula(GLL.TAX_CODE_ID, GLL.TAX_TYPE_CODE) TAX_CODE, GL_GLWACCTR_XMLP_PKG.contra_acct_valueformula(GLH.JE_HEADER_ID, GLL.SUBLEDGER_DOC_SEQUENCE_ID, GLL.SUBLEDGER_DOC_SEQUENCE_VALUE, GLL.ACCOUNTED_DR, GLL.ACCOUNTED_CR) CONTRA_ACCT_VALUE, fnd_flex_xml_publisher_apis.process_kff_combination_1('contra_acct_desc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'DESCRIPTION') CONTRA_ACCT_DESC, GL_GLWACCTR_XMLP_PKG.cf_line_balanceformula(cc.segment1, cc.segment3, cc.segment4, LGR.LEDGER_ID, GLB.STATUS) CF_LINE_BALANCE, GL_GLWACCTR_XMLP_PKG.cf_gl_balanceformula(cc.segment1, cc.segment3, cc.segment4, LGR.LEDGER_ID, GLB.STATUS) CF_GL_BALANCE -- GL_GLWACCTR_XMLP_PKG.begin_balanceformula(:CF_LINE_BALANCE, :CF_GL_BALANCE) BEGIN_BALANCE FROM &P_PERF_FROM &P_JOURNAL_FROM_CLAUSE &P_LEDGER_FROM WHERE GLH.LEDGER_ID = LGR.LEDGER_ID &P_LEDGER_WHERE AND GLH.JE_SOURCE = GJS.JE_SOURCE_NAME AND GLH.JE_CATEGORY = GJC.JE_CATEGORY_NAME AND GLH.LAST_UPDATED_BY = FU.USER_ID AND GLB.JE_BATCH_ID = GLH.JE_BATCH_ID AND GLH.DOC_SEQUENCE_ID = DOCSEQ.DOC_SEQUENCE_ID(+) AND GLL.SUBLEDGER_DOC_SEQUENCE_ID = SUBDOCSEQ.DOC_SEQUENCE_ID(+) AND DCT.CONVERSION_TYPE (+) = GLH.CURRENCY_CONVERSION_TYPE &P_POSTING_STATUS &P_HEADER_POSTING_STATUS &P_DAS_WHERE &P_CURRENCY_WHERE &P_ACTUAL_TYPE_WHERE &P_BATCH_WHERE &P_SOURCE_WHERE &P_CATEGORY_WHERE and &P_BAL_WHERE &P_DOC_ID_WHERE &P_DOC_VAL_WHERE &P_SUB_DOC_ID_WHERE &P_SUB_DOC_VAL_WHERE &P_NOT_ZERO_LINE_WHERE &P_PERIOD_WHERE &P_CONTRA_ACCOUNT_WHERE &P_JOURNAL_DATE_WHERE &P_JOURNAL_UPD_DATE_WHERE &P_JOURNAL_LAST_UPD_WHERE and &P_AFF_WHERE &P_AMOUNT_WHERE &P_JOURNAL_WHERE_CLAUSE SQLGL GLRXVCJ_XML AR GL اليوميات - الإيصال (بتنسيق XML) Imported from BI Publisher Description: اليوميات - الإيصال Application: الأستاذ العام Source: اليوميات - الإيصال (بتنسيق XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG D GL Buchungsbelege Imported from BI Publisher Description: Buchungsbelege Application: Rechnungswesen Source: Buchungsbelege (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG E GL Asientos - Justificante Imported from BI Publisher Description: Asientos - Justificante Application: General Ledger Source: Asientos - Justificante (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG F GL Pièces - Pièces justificatives Imported from BI Publisher Description: Pièces - Pièces justificatives Application: General Ledger Source: Pièces - Pièces justificatives (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG I GL Scritture contabili - Giustificativo Imported from BI Publisher Description: Scritture contabili - giustificativo Application: General Ledger Source: Scritture contabili - Giustificativo (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG JA GL 仕訳 - 証憑 Imported from BI Publisher Description: 仕訳 - 証憑 Application: General Ledger Source: 仕訳 - 証憑 (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG KO GL 분개 - 전표 Imported from BI Publisher Description: 분개 - 전표 Application: General Ledger Source: 분개 - 전표(XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG PTB GL Lançamentos - Voucher Imported from BI Publisher Description: Lançamentos - Voucher Application: General Ledger Source: Lançamentos - Voucher (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG RU GL Журналы - квитанции Imported from BI Publisher Description: Журналы - квитанции Application: Главная книга Source: Журналы - квитанции (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG S GL Verifikationer - Verifikat Imported from BI Publisher Description: Verifikationer - verifikat Application: General Ledger Source: Verifikationer - Verifikat (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG TR GL Fişler - Makbuz Imported from BI Publisher Description: Fişler - Makbuz Application: Genel Muhasebe Source: Fişler - Makbuz (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG US GL Journals - Voucher Imported from BI Publisher Description: Journals - Voucher Application: General Ledger Source: Journals - Voucher (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG ZHS GL 日记账 - 凭证 Imported from BI Publisher Description: 日记账 - 凭证 Application: 总帐管理系统 Source: 日记账 - 凭证 (XML) Short Name: GLRXVCJ_XML DB package: GL_GLWACCTR_XMLP_PKG BI Publisher &additional_segment_desc &p_actual_type_where &p_aff_where &p_amount_where &p_bal_where &p_batch_where &p_category_where &p_contra_account_where &p_currency_where &p_das_where &p_doc_id_where &p_doc_val_where &p_header_posting_status &p_hint_clause &p_journal_date_where &p_journal_from_clause &p_journal_last_upd_where &p_journal_upd_date_where &p_journal_where_clause &p_ledger_from &p_ledger_where &p_not_zero_line_where &p_perf_from &p_period_where &p_posting_status &p_source_where &p_sub_doc_id_where &p_sub_doc_val_where &select_account &select_acct_segment &select_bal_segment &select_secondary_segment :access_set_name :acct_seg_name_dsp :bal_seg_name_dsp :c_date_format :c_param_end_date :c_param_start_date :chart_of_accounts_id :h_end_date :h_end_update_date :h_set_of_books_id :h_start_date :h_start_update_date :no_contra_account :p_acc_segment_select :p_acc_segment_where :p_access_set_id :p_actual_flag :p_actual_type_where :p_aff_from :p_aff_to :p_aff_where :p_aff_where_jrl :p_amount_from :p_amount_to :p_amount_where :p_amt_flag :p_bal_seg_val :p_bal_where :p_batch_name :p_batch_where :p_category :p_category_where :p_coa :p_conc_request_id :p_contra_account :p_contra_account_where :p_contra_acct :p_contra_flag :p_currency :p_currency_where :p_das_where :p_debug :p_doc_id :p_doc_id_where :p_doc_val_where :p_doc_value :p_end_date :p_end_doc_value :p_end_update_date :p_header_posting_status :p_hint_clause :p_journal_date_where :p_journal_date_where_2 :p_journal_date_where_3 :p_journal_from_clause :p_journal_last_upd_where :p_journal_upd_date_where :p_journal_where_clause :p_journals_line_flag :p_last_update_date :p_last_updated_by :p_ledger_from :p_ledger_id :p_ledger_where :p_not_zero_line_where :p_pagebreak :p_perf_from :p_perf_from_cluase :p_period_name :p_period_where :p_posting_status :p_report_name :p_sec_seg_num :p_sec_segment_where :p_source :p_source_where :p_start_date :p_start_doc_value :p_start_update_date :p_status :p_sub_doc_id :p_sub_doc_id_where :p_sub_doc_val_where :p_sub_doc_value :p_use_date_col :param_acct_from :param_acct_to :param_amount_high :param_amount_low :param_amt_flag :param_balancing_segment :param_basis :param_batch_name :param_category :param_contra_acct :param_currency_code :param_doc_seq_name :param_doc_seq_value :param_end_date :param_end_doc_seq_value :param_last_updated_by :param_ledger_name :param_period_name :param_posting_status :param_sec_seg_name :param_source :param_start_date :param_start_doc_seq_value :param_sub_doc_seq_name :param_sub_doc_seq_value :prev_acct_seg_val :prev_bal_seg_val :prev_gl_bal :prev_led_id :prev_line_bal :prev_sec_seg_val :select_account :select_acct_segment :select_bal_segment :select_cost_ctr_segment :select_secondary_segment 1 -70 :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 -60 :p_actual_flag LOV Oracle GL_SRS_BALANCE_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='BATCH_TYPE' order by upper(meaning) select meaning from gl_lookups where lookup_type='BATCH_TYPE' and lookup_code='A' Y AR علامة الفعلي علامة الفعلي D Betragsart Betragsart E Tipo de Saldo Tipo de Saldo F Indicateur Réel Indicateur Réel I Flag Consuntivo Flag Consuntivo JA 実績フラグ 実績フラグ KO 실적 플래그 실적 플래그 PTB Indicador Real Indicador Real RU Фактический флаг Фактический флаг S Faktisk-flagga Faktisk-flagga TR Fiili İşareti Fiili İşareti US Actual Flag Actual Flag ZHS 实际标志 实际标志 3 -50 :p_coa 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 科目表标识 4 -40 :p_pagebreak LOV Oracle GL_SRS_PAGEBREAK_SEGS Y select segment_num id, segment_name value, s.description description from fnd_id_flex_segments_vl s,fnd_segment_attribute_values v where s.id_flex_code='GL#' and v.id_flex_code='GL#' and s.id_flex_num=:$flex$.gl_srs_coa_unvalidated and v.id_flex_num=:$flex$.gl_srs_coa_unvalidated and s.enabled_flag='Y' and s.application_column_name=v.application_column_name and s.application_id=101 and v.application_id=101 and v.segment_attribute_type='GL_ACCOUNT' and v.attribute_value='N' order by segment_num Select segment_name from FND_ID_FLEX_SEGMENTS_VL S, FND_SEGMENT_ATTRIBUTE_VALUES AT Where S.ID_FLEX_CODE = 'GL#' and AT.ID_FLEX_CODE = 'GL#' and S.id_flex_num = :$FLEX$.GL_SRS_COA_UNVALIDATED and AT.id_flex_num = :$FLEX$.GL_SRS_COA_UNVALIDATED and S.enabled_flag = 'Y' and S.application_column_name = AT.application_column_name and S.application_id = 101 and AT.application_id = 101 and AT.segment_attribute_type = 'GL_BALANCING' and AT.attribute_value = 'Y' AR GL_SRS_PAGEBREAK_SEGS مقطع فاصل الصفحات D GL_SRS_PAGEBREAK_SEGS Seitenumbruch-Segment E GL_SRS_PAGEBREAK_SEGS Segmento de Salto de Página F GL_SRS_PAGEBREAK_SEGS Segment de saut de page I GL_SRS_PAGEBREAK_SEGS Segmento di interruzione di pagina JA GL_SRS_PAGEBREAK_SEGS 改ページ・セグメント KO GL_SRS_PAGEBREAK_SEGS 페이지 구분 세그먼트 PTB GL_SRS_PAGEBREAK_SEGS Segmento para Quebra de Página RU GL_SRS_PAGEBREAK_SEGS Сегмент разрыва страницы S GL_SRS_PAGEBREAK_SEGS Sidbrytningssegment TR GL_SRS_PAGEBREAK_SEGS Sayfa Sonu Segmenti US GL_SRS_PAGEBREAK_SEGS Pagebreak Segment ZHS GL_SRS_PAGEBREAK_SEGS 分页段 5 -30 :p_contra_flag LOV Oracle GL_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from FND_LOOKUPS where lookup_type='YES_NO' and lookup_code='N' AR الحساب المقابل الحساب المقابل D Gegenkonto Gegenkonto E Cuenta de Compensación Cuenta de Compensación F Compte de contrepartie Compte de contrepartie I Conto contropartita Conto contropartita JA 相手勘定 相手勘定 KO 상대 계정 상대 계정 PTB Conta de Contrapartida Conta de Contrapartida RU Счет погашения Счет погашения S Motkonto Motkonto TR Karşı Hesap Karşı Hesap US Contra Account Contra Account ZHS 抵销账户 抵销账户 6 -20 :p_report_name Char VOUCHER Y AR اسم التقرير اسم التقرير D Bericht Bericht E Nombre del Informe Nombre del Informe F Nom de l'état Nom de l'état I Nome rapporto Nome rapporto JA レポート名 レポート名 KO 보고서명 보고서명 PTB Nome do Relatório Nome do Relatório RU Имя отчета Имя отчета S Rapport Rapport TR Rapor Adı Rapor Adı US Report Name Report Name ZHS 报表名称 报表名称 7 10 :p_ledger_id LOV Oracle GL_SRS_LEDGER_WITH_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 order by name AR دفتر الأستاذ/مجموعة دفاتر الأستاذ دفتر الأستاذ/مجموعة دفاتر الأستاذ D Buch/BuchSet Buch/BuchSet E Libro Mayor/Juego de Libros Mayores Libro Mayor/Juego de Libros Mayores F Livre/jeu de livres Livre/jeu de livres I Libro contabile/serie libri contabili Libro contabile/serie libri contabili JA 元帳/元帳セット 元帳/元帳セット KO 원장/원장 세트 원장/원장 세트 PTB Razão/Conjunto de Razões Razão/Conjunto de Razões RU Книга/набор книг Книга/набор книг S Huvudbok/huvudboksgrupp Huvudbok/huvudboksgrupp TR Defter / Defter Kümesi Defter / Defter Kümesi US Ledger/Ledger Set Ledger/Ledger Set ZHS 分类账/分类账集 分类账/分类账集 8 20 :p_status LOV Oracle GL_SRS_JOURNAL_TYPE Y select lookup_code id, meaning value, description description from gl_lookups where lookup_type='JOURNAL_REPORT_TYPE' order by (meaning) Y AR موقف الترحيل موقف الترحيل D Verbuchungsstatus Verbuchungsstatus E Estado de Contabilización Estado de contabilización F Statut d'imputation Statut d'imputation I Stato contabilizzazione Stato della contabilizzazione JA 転記ステータス 転記ステータス KO 전기 상태 전기 상태 PTB Status da Contabilização Status da Contabilização RU Статус проводки Статус проводки S Postningsstatus Postningsstatus TR Muhasebeleşme Statüsü Muhasebeleşme Statüsü US Posting Status Posting Status ZHS 过账状态 过账状态 9 30 :p_currency LOV Oracle GL_SRS_DAS_LEDGER_CURRENCIES_AND_STAT Y select curr.currency_code id, curr.currency_code value, null description from fnd_currencies curr where curr.currency_code='STAT' or curr.currency_code in (select l.currency_code from gl_access_set_ledgers acc,gl_ledgers l where acc.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=acc.ledger_id and l.object_type_code='L') order by value,description Y AR العملة رمز أو موقف العملة الأساسية D Währung Bilanzwährung oder STAT E Divisa Código de Divisa Funcional o ESTADÍSTICA F Devise Code devise comptable ou STAT I Divisa Codice della moneta di conto o STAT JA 通貨 機能通貨コードまたは統計 KO 통화 기준 통화 코드 또는 통계 PTB Moeda Código de Moeda Funcional ou STAT RU Валюта Код функциональной валюты или СТАТ S Valuta Funktionell valutakod eller STAT TR Para Birimi Fonksiyonel Para Birimi Codu veya STAT US Currency Functional Currency Code or STAT ZHS 币种 本位币代码或 STAT 10 40 :p_start_date Date Y AR GL_SRS_STANDARD_DATE_LOW تاريخ البداية D GL_SRS_STANDARD_DATE_LOW Startdatum E GL_SRS_STANDARD_DATE_LOW Fecha de Inicio F GL_SRS_STANDARD_DATE_LOW Date de début I GL_SRS_STANDARD_DATE_LOW Data avvio JA GL_SRS_STANDARD_DATE_LOW 開始日 KO GL_SRS_STANDARD_DATE_LOW 시작 일자 PTB GL_SRS_STANDARD_DATE_LOW Data Inicial RU GL_SRS_STANDARD_DATE_LOW Начальная дата S GL_SRS_STANDARD_DATE_LOW Startdatum TR GL_SRS_STANDARD_DATE_LOW Başlangıç Tarihi US GL_SRS_STANDARD_DATE_LOW Start Date ZHS GL_SRS_STANDARD_DATE_LOW 起始日期 11 50 :p_end_date Date Y AR GL_SRS_STANDARD_DATE_HIGH تاريخ النهاية D GL_SRS_STANDARD_DATE_HIGH Enddatum E GL_SRS_STANDARD_DATE_HIGH Fecha de Finalización F GL_SRS_STANDARD_DATE_HIGH Date de fin I GL_SRS_STANDARD_DATE_HIGH Data fine JA GL_SRS_STANDARD_DATE_HIGH 日付:至 KO GL_SRS_STANDARD_DATE_HIGH 종료 일자 PTB GL_SRS_STANDARD_DATE_HIGH Data Final RU GL_SRS_STANDARD_DATE_HIGH Конечная дата S GL_SRS_STANDARD_DATE_HIGH Slutdatum TR GL_SRS_STANDARD_DATE_HIGH Bitiş Tarihi US GL_SRS_STANDARD_DATE_HIGH End Date ZHS GL_SRS_STANDARD_DATE_HIGH 终止日期 12 60 :p_source LOV Oracle GL_SRS_JOURNAL_SOURCE Y select je_source_name id, user_je_source_name value, description description from gl_je_sources order by user_je_source_name AR مصدر اليومية مصدر اليومية D Belegherkunft Belegherkunft E Origen Origen F Origine de pièce Origine de pièce I Origine scrittura contabile Origine della scrittura contabile JA 仕訳ソース 仕訳ソース KO 분개 출처 분개 출처 PTB Origem do Lançamento Origem do Lançamento RU Источник журнала Источник журнала S Verifikationskälla Verifikationskälla TR Fiş Kaynağı Fiş Kaynağı US Journal Source Journal Source ZHS 日记账来源 日记账来源 13 70 :p_batch_name LOV Oracle GL_SRS_RXI_BASE_BATCH Y select b.name id, b.name value, b.description description from gl_je_batches b where b.je_batch_id in (select max(b.je_batch_id) from gl_je_batches b where b.je_batch_id in (select h.je_batch_id from gl_je_headers h where h.ledger_id in (select nvl(ls.ledger_id,acc.ledger_id) from gl_access_set_ledgers acc,gl_ledger_set_assignments ls where acc.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and acc.ledger_id=nvl(:$flex$.gl_srs_ledger_with_sets_store_id:null,acc.ledger_id) and ls.ledger_set_id (+)=decode(acc.ledger_id,:$flex$.gl_srs_ledger_with_sets_store_id:null,acc.ledger_id,-1)) and h.period_name=:$flex$.gl_srs_jrn_period:null and :$flex$.gl_srs_jrn_period:null is not null and h.je_source=nvl(:$flex$.gl_srs_journal_source:null, h.je_source) and decode(h.currency_code,'STAT',1,0)= decode(:$flex$.gl_srs_das_ledger_currencies_and_stat,'STAT',1,0) and (trunc(h.default_effective_date) between decode(:$flex$.gl_srs_journal_type, 'P',trunc(h.default_effective_date), nvl(to_date(:$flex$.gl_srs_standard_date_low:null, 'YYYY/MM/DD HH24:MI:SS'), trunc(h.default_effective_date))) and decode(:$flex$.gl_srs_journal_type, 'P',trunc(h.default_effective_date), nvl(to_date(:$flex$.gl_srs_standard_date_high:null, 'YYYY/MM/DD HH24:MI:SS'), trunc(h.default_effective_date)))) union all select h.je_batch_id from gl_je_headers h where h.ledger_id in (select nvl(ls.ledger_id,acc.ledger_id) from gl_access_set_ledgers acc,gl_ledger_set_assignments ls where acc.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and acc.ledger_id=nvl(:$flex$.gl_srs_ledger_with_sets_store_id:null,acc.ledger_id) and ls.ledger_set_id (+)=decode(acc.ledger_id,:$flex$.gl_srs_ledger_with_sets_store_id:null,acc.ledger_id,-1)) and :$flex$.gl_srs_jrn_period:null is null and h.je_source=nvl(:$flex$.gl_srs_journal_source:null, h.je_source) and decode(h.currency_code,'STAT',1,0)= decode(:$flex$.gl_srs_das_ledger_currencies_and_stat,'STAT',1,0) and (trunc(h.default_effective_date) between decode(:$flex$.gl_srs_journal_type, 'P',trunc(h.default_effective_date), nvl(to_date(:$flex$.gl_srs_standard_date_low:null, 'YYYY/MM/DD HH24:MI:SS'), trunc(h.default_effective_date))) and decode(:$flex$.gl_srs_journal_type, 'P',trunc(h.default_effective_date), nvl(to_date(:$flex$.gl_srs_standard_date_high:null, 'YYYY/MM/DD HH24:MI:SS'), trunc(h.default_effective_date)))) ) and (trunc(nvl(b.posted_date,sysdate)) between decode(:$flex$.gl_srs_journal_type, 'P',nvl(to_date(:$flex$.gl_srs_standard_date_low:null, 'YYYY/MM/DD HH24:MI:SS'), trunc(nvl(b.posted_date,sysdate))), trunc(nvl(b.posted_date,sysdate))) and decode(:$flex$.gl_srs_journal_type, 'P',nvl(to_date(:$flex$.gl_srs_standard_date_high:null, 'YYYY/MM/DD HH24:MI:SS'), trunc(nvl(b.posted_date,sysdate))), trunc(nvl(b.posted_date,sysdate)))) and b.default_period_name =nvl(:$flex$.gl_srs_jrn_period:null, b.default_period_name) and b.status=decode(:$flex$.gl_srs_journal_type, 'P','P', 'U','U', 'E',decode(b.status, 'P',null,'U',null,'I',null,'S',null,b.status), null) group by b.name) order by value,description AR اسم المجموعة اسم المجموعة D Stapelbezeichnung Stapelbezeichnung E Nombre de Lote Nombre de Lote F Nom du lot Nom du lot I Nome batch Nome batch JA バッチ名 バッチ名 KO 뱃치명 뱃치명 PTB Nome do Lote Nome do Lote RU Имя пакета Имя пакета S Bunt Bunt TR İşlem Grubu Adı İşlem Grubu Adı US Batch Name Batch Name ZHS 批名 批名 14 80 :p_category LOV Oracle GL_SRS_JOURNAL_CATEGORY_2 Y select je_category_name id, user_je_category_name value, description description from gl_je_categories order by user_je_category_name AR الفئة الفئة D Kategorie Kategorie E Categoría Categoría F Catégorie Catégorie I Categoria Categoria JA カテゴリ カテゴリ KO 범주 범주 PTB Categoria Categoria RU Категория Категория S Kategori Kategori TR Kategori Kategori US Category Category ZHS 类别 类别 15 90 :p_doc_id LOV Oracle GL_SRS_SEQUENCES Y select doc_sequence_id id, name value, null description from fnd_document_sequences where doc_sequence_id in (select distinct doc_sequence_id from fnd_doc_sequence_assignments where application_id=101) and type in ('A','G') order by name AR اسم مسلسل المستند اسم مسلسل المستند D Bezeichnung Belegnummernfolge Bezeichnung Belegnummernfolge E Nombre de Secuencia de Documento Nombre de Secuencia de Documento F Nom séquence document Nom séquence document I Nome sequenza documenti Nome sequenza documenti JA 文書連番名 文書連番名 KO 문서 일련번호명 문서 일련번호명 PTB Nome da Sequência do Documento Nome da Sequência do Documento RU Имя последовательности документов Имя последовательности документов S Dokumentsekvens Dokumentsekvens TR Doküman Sıra Adı Doküman Sıra Adı US Document Sequence Name Document Sequence Name ZHS 单据序号名 单据序号名 16 100 :p_start_doc_value Number AR رقم بداية مسلسل المستند رقم بداية مسلسل المستند D Von Belegnummer Von Belegnummer E De Número de Secuencia de Documento De Número de Secuencia de Documento F Premier numéro de pièce Premier numéro de pièce I Numero sequenza documenti iniziale Numero sequenza documenti iniziale JA 文書連番 自 文書連番 自 KO 문서 시작 일련순서 번호 문서 시작 일련순서 번호 PTB Número Inicial da Sequência do Documento Número Inicial da Sequência do Documento RU Начальный порядковый номер документа Начальный порядковый номер документа S Från dokumentsekvensnummer Från dokumentsekvensnummer TR Başlangıç Doküman Sıra Numarası Başlangıç Doküman Sıra Numarası US Start Document Sequence Number Start Document Sequence Number ZHS 单据起始序号 单据起始序号 17 110 :p_end_doc_value Number AR رقم نهاية مسلسل المستند رقم نهاية مسلسل المستند D Bis Belegnummer Bis Belegnummer E A Número de Secuencia de Documento A Número de Secuencia de Documento F Dernier numéro de pièce Dernier numéro de pièce I Numero sequenza documenti finale Numero sequenza documenti finale JA 文書連番 至 文書連番 至 KO 문서 종료 일련순서 번호 문서 종료 일련순서 번호 PTB Número Final da Sequência do Documento Número Final da Sequência do Documento RU Конечный порядковый номер документа Конечный порядковый номер документа S Till dokumentsekvensnummer Till dokumentsekvensnummer TR Bitiş Doküman Sıra Numarası Bitiş Doküman Sıra Numarası US End Document Sequence Number End Document Sequence Number ZHS 单据终止序号 单据终止序号 18 120 :p_journals_line_flag LOV Oracle GL_SRS_SELECTION_BASE Y select lookup_code id, meaning value, null description from gl_lookups where lookup_type='SELECTION_BASE' order by value,description Select Meaning from GL_LOOKUPS WHERE LOOKUP_TYPE = 'SELECTION_BASE' and Lookup_code = 'L' Y AR اليوميات/السطور اليوميات/السطور D Buchungen/Positionen Buchungen/Positionen E Asientos/Líneas Asientos/Líneas F Pièces/Lignes Pièces/Lignes I Scritture contabili/linee Scritture contabili/linee JA 仕訳/明細 仕訳/明細 KO 분개/라인 분개/라인 PTB Lançamentos/Linhas Lançamentos/Linhas RU Журналы/строки Журналы/строки S Verifikationer/rader Verifikationer/rader TR Fişler/Satırlar Fişler/Satırlar US Journals/Lines Journals/Lines ZHS 日记账/行 日记账/行 19 130 :p_aff_from Char AR الحساب من الحساب من D Von Konto Von Konto E De Cuenta De Cuenta F Compte - De Compte - De I Conto - Da Conto - Da JA 勘定科目:自 勘定科目:自 KO 계정: 부터 계정: 부터 PTB Conta - De Conta - De RU Счет с Счет с S Från konto Från konto TR Hesap, İlk Hesap, İlk US Account From Account From ZHS 账户自 账户自 20 140 :p_aff_to Char AR حساب إلى حساب إلى D Bis Konto Bis Konto E A Cuenta A Cuenta F Compte - A Compte - A I Conto - A Conto - A JA 勘定科目:至 勘定科目:至 KO 계정: 까지 계정: 까지 PTB Conta - Até Conta - Até RU Счет по Счет по S Till konto Till konto TR Hesap, Son Hesap, Son US Account To Account To ZHS 账户至 账户至 21 150 :p_sec_seg_num LOV Oracle GL_SRS_SECONDARY_SEGS Y select segment_num id, segment_name value, description description from fnd_id_flex_segments_vl s,fnd_segment_attribute_values v where s.id_flex_code='GL#' and v.id_flex_code='GL#' and s.id_flex_num=:$flex$.gl_srs_coa_unvalidated and v.id_flex_num=:$flex$.gl_srs_coa_unvalidated and s.application_id=101 and v.application_id=101 and s.enabled_flag='Y' and s.application_column_name=v.application_column_name and v.segment_attribute_type='GL_ACCOUNT' and v.attribute_value='N' and s.segment_num!=:$flex$.gl_srs_pagebreak_segs order by segment_num AR المقطع الإضافي المقطع الثانوي D Weiteres Segment Sekundäres Segment E Segmento Adicional Segmento Secundario F Segment supplémentaire Segment secondaire I Segmento supplementare Segmento secondario JA 追加セグメント 副セグメント KO 추가 세그먼트 2차 세그먼트 PTB Segmento Adicional Segmento Secundário RU Дополнительный сегмент Вторичный сегмент S Ytterligare segment Andra segment TR Ek Segment İkincil Segment US Additional Segment Secondary Segment ZHS 附加段 辅助段 22 160 :p_amt_flag LOV Oracle GL_SRS_AMT_FLAG (DR/CR) Y select lookup_code id, meaning value, null description from gl_lookups where lookup_type='GL_DR_CR' order by value,description AR مدين/دائن مدين/دائن D Soll/Haben Soll/Haben E Debe/Haber Debe/Haber F Débit/Crédit Débit/Crédit I Dare/Avere Dare/Avere JA 借方/貸方 借方/貸方 KO 차변/대변 차변/대변 PTB Débito/Crédito Débito/Crédito RU Дебет/кредит Дебет/кредит S Debet/kredit Debet/kredit TR Borç/Alacak Borç/Alacak US Debit/Credit Debit/Credit ZHS 借/贷 借/贷 23 170 :p_amount_from Number AR المبلغ إلى المبلغ إلى D Von Betrag Von Betrag E De Importe De Importe F Montant - De Montant - De I Importo minimo Importo minimo JA 金額 自 金額 自 KO 금액 하한 금액 하한 PTB Quantia Inferior Quantia Inferior RU Сумма с Сумма с S Från belopp Från belopp TR Tutar Alt Değeri Tutar Alt Değeri US Amount Low Amount Low ZHS 金额下限 金额下限 24 180 :p_amount_to Number AR إلى المبلغ إلى المبلغ D Bis Betrag Bis Betrag E A Importe A Importe F Montant - A Montant - A I Importo massimo Importo massimo JA 金額 至 金額 至 KO 금액 상한 금액 상한 PTB Quantia Superior Quantia Superior RU Сумма по Сумма по S Till belopp Till belopp TR Tutar, Üst Değeri Tutar, Üst Değeri US Amount High Amount High ZHS 金额上限 金额上限