ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4725951A9E05362FB09050512 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, to_char(GLH.LAST_UPDATE_DATE,'DD-MON-YY') 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(GL_GLWACCTR_XMLP_PKG.cf_line_balanceformula(cc.segment1, cc.segment3, cc.segment4, LGR.LEDGER_ID, GLB.STATUS), GL_GLWACCTR_XMLP_PKG.cf_gl_balanceformula(cc.segment1, cc.segment3, cc.segment4, LGR.LEDGER_ID, GLB.STATUS)) 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 Y SQLGL GLRXCKJ_XML AR GL اليوميات - مراجعة (بتنسيق XML) Imported from BI Publisher Description: اليوميات - مراجعة Application: الأستاذ العام Source: اليوميات - مراجعة (بتنسيق XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG D GL Buchungen - Prüfung Imported from BI Publisher Description: Buchungen - Prüfung Application: Rechnungswesen Source: Buchungen - Prüfung (XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG E GL Asientos - Comprobación Imported from BI Publisher Description: Asientos - Comprobación Application: General Ledger Source: Asientos - Comprobación (XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG F GL Pièces - Vérification Imported from BI Publisher Description: Pièces - Vérification Application: General Ledger Source: Pièces - Vérification (XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG I GL Scritture contabili - Controllo Imported from BI Publisher Description: Scritture contabili - controllo Application: General Ledger Source: Scritture contabili - Controllo (XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG JA GL 仕訳 - チェック Imported from BI Publisher Description: 仕訳 - チェック Application: General Ledger Source: 仕訳 - チェック (XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG KO GL 분개 - 수표 Imported from BI Publisher Description: 분개 - 수표 Application: General Ledger Source: 분개 - 수표(XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG PTB GL Lançamentos - Verificação Imported from BI Publisher Description: Lançamentos - Verificação Application: General Ledger Source: Lançamentos - Verificação (XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG RU GL Журналы - проверка Imported from BI Publisher Description: Журналы - проверка Application: Главная книга Source: Журналы - проверка (XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG S GL Verifikationer - Kontroll Imported from BI Publisher Description: Verifikationer - kontroll Application: General Ledger Source: Verifikationer - Kontroll (XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG TR GL Fişler - Kontrol Imported from BI Publisher Description: Fişler - Kontrol Et Application: Genel Muhasebe Source: Fişler - Kontrol (XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG US GL Journals - Check Imported from BI Publisher Description: Journals - Check Application: General Ledger Source: Journals - Check (XML) Short Name: GLRXCKJ_XML DB package: GL_GLWACCTR_XMLP_PKG ZHS GL 日记账 - 支票 Imported from BI Publisher Description: 日记账 - 支票 Application: 总帐管理系统 Source: 日记账 - 支票 (XML) Short Name: GLRXCKJ_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 -60 :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 -50 :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 -40 :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 -30 :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 مقطع فاصل الصفحات مقطع فاصل الصفحات D Seitenumbruch-Segment Seitenumbruch-Segment E Segmento de Salto de Página Segmento de Salto de Página F Segment de saut de page Segment de saut de page I Segmento di interruzione pagina Segmento di interruzione di pagina JA 改ページ・セグメント 改ページ・セグメント KO 페이지 구분 세그먼트 페이지 구분 세그먼트 PTB Segmento para Quebra de Página Segmento para Quebra de Página RU Сегмент разрыва страницы Сегмент разрыва страницы S Sidbrytningssegment Sidbrytningssegment TR Sayfa Sonu Segmenti Sayfa Sonu Segmenti US Pagebreak Segment Pagebreak Segment ZHS 分页段 分页段 5 -20 :p_report_name Char CHECK 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 报表名称 报表名称 6 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 分类账/分类账集 分类账/分类账集 7 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) select meaning from gl_lookups where lookup_type='JOURNAL_REPORT_TYPE' and lookup_code='P' 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 过账状态 过账状态 8 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 العملة رمز العملة أو STAT D Währung Währungsschlüssel oder STAT E Divisa Código de divisa o ESTADÍSTICA F Devise Code devise ou STAT I Divisa Codice divisa o STAT JA 通貨 通貨コードまたはSTAT KO 통화 통화 코드 또는 STAT PTB Moeda Código da Moeda ou STAT RU Валюта Код валюты или СТАТ S Valuta Valutakod eller statistisk valuta TR Para Birimi Para Birimi Kodu veya İSTATİSTİKSEL US Currency Currency Code or STAT ZHS 币种 币种代码或 STAT 9 40 :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 日记账来源 日记账来源 10 50 :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 批名 批名 11 60 :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 类别 类别 12 70 :p_start_update_date Date Y AR تاريخ بداية التحديث تاريخ بداية التحديث D Von Aktualisierungsdatum Von Aktualisierungsdatum E De Fecha de Actualización De Fecha de Actualización F Date de début de la mise à jour Date de début de la mise à jour I Data aggiornamento iniziale Data aggiornamento iniziale JA 開始更新日 開始更新日 KO 갱신 시작 일자 갱신 시작 일자 PTB Data Inicial da Atualização Data Inicial da Atualização RU Дата начала обновления Дата начала обновления S Startdatum för uppdatering Startdatum för uppdatering TR İlk Güncelleme Tarihi İlk Güncelleme Tarihi US Start Update Date Start Update Date ZHS 起始更新日期 起始更新日期 13 80 :p_end_update_date Date Y AR تاريخ نهاية التحديث تاريخ نهاية التحديث D Bis Aktualisierungsdatum Bis Aktualisierungsdatum E A Fecha de Actualización A Fecha de Actualización F Date de fin de la mise à jour Date de fin de la mise à jour I Data aggiornamento finale Data aggiornamento finale JA 最終更新日 最終更新日 KO 갱신 종료 일자 갱신 종료 일자 PTB Data Final da Atualização Data Final da Atualização RU Дата окончания обновления Дата окончания обновления S Slutdatum för uppdatering Slutdatum för uppdatering TR Son Güncelleme Tarihi Son Güncelleme Tarihi US End Update Date End Update Date ZHS 终止更新日期 终止更新日期 14 90 :p_last_updated_by LOV Oracle GL_SRS_RX_USER_ID Y select user_id id, user_name value, user_name description from fnd_user order by value,description AR آخر تحديث بواسطة آخر تحديث بواسطة D Zuletzt aktualisiert von Zuletzt aktualisiert von E Actualizado por Actualizado por F Dernière mise à jour par Dernière mise à jour par I Ultimo aggiornamento di Ultimo aggiornamento di JA 最終更新者 最終更新者 KO 최종 갱신자 최종 갱신자 PTB Atualizado da Última Vez Por Atualizado da Última Vez Por RU Обновлено Обновлено S Senast uppdaterad av Senast uppdaterad av TR Son Güncelleyen Son Güncelleyen US Last Updated By Last Updated By ZHS 上次更新者 上次更新者 :$FLEX$.GL_SRS_COA_UNVALIDATED GL_SRS_COA_UNVALIDATED Pagebreak Segment :$flex$.gl_srs_coa_unvalidated GL_SRS_COA_UNVALIDATED Pagebreak Segment :$flex$.gl_srs_das_ledger_currencies_and_stat Currency Batch Name :$flex$.gl_srs_journal_type Posting Status Batch Name