ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4706051A9E05362FB09050512Y SELECT &p_select_clause FROM (&p_sla_col_1 &p_gl_columns &p_sla_col_2 &p_party_details &p_sla_qualifier_segment &p_sla_col_3 &p_trx_identifiers_1 &p_trx_identifiers_2 &p_trx_identifiers_3 &p_trx_identifiers_4 &p_trx_identifiers_5 &p_sla_legal_ent_col &p_sla_from &p_sla_seg_desc_from &p_gl_view &p_sla_legal_ent_from &p_party_from &p_sla_join &p_sla_seg_desc_join &p_other_param_filter &p_gl_join &p_sla_legal_ent_join &p_party_join &p_union_all &p_gl_col_1 &p_gl_party_details &p_gl_qualifier_segment &p_gl_col_2 &p_gl_legal_ent_col &p_gl_from &p_gl_seg_desc_from &p_gl_legal_ent_from &p_gl_where &p_gl_seg_desc_join &p_gl_legal_ent_join &p_other_union) TABLE1 &p_le_from WHERE 1 = 1 &p_trx_id_filter &p_le_join &p_where_clause ORDER BY &p_orderby_clause JE JEFRAEAF AR JE ملف تدقيق القيود المحاسبية في فرنسا Imported from BI Publisher Application: المحليات الأوروبية Source: ملف تدقيق القيود المحاسبية في فرنسا Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG D JE Buchungen - Protokolldatei Imported from BI Publisher Application: Europäische Lokalisierungen Source: Frankreich: Buchungen - Protokolldatei Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG E JE Francia - Fichero de Auditoría de Apuntes Contables Imported from BI Publisher Application: Localizaciones Europeas Source: Francia - Fichero de Auditoría de Apuntes Contables Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG F JE France - Fichier d'audit des pièces comptables Imported from BI Publisher Application: European Localizations Source: France - Fichier d'audit des pièces comptables Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG I JE Francia - file audit inserimenti contabili Imported from BI Publisher Application: European Localizations Source: Francia - file audit inserimenti contabili Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG RU JE Файл об аудите бухгалтерских записей (Франция) Imported from BI Publisher Application: Версии для Европы Source: Файл об аудите бухгалтерских записей (Франция) Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG S JE Bokföringsposter - kontrollfil (FRA) Imported from BI Publisher Application: European Localizations Source: Bokföringsposter - kontrollfil (FRA) Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG TR JE Fransa Muhasebe Kayıtları Denetleme Dosyası Imported from BI Publisher Application: Avrupa Yerelleştirmeleri Source: Fransa Muhasebe Kayıtları Denetleme Dosyası Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG US JE French Accounting Entries Audit File Imported from BI Publisher Application: European Localizations Source: French Accounting Entries Audit File Short Name: JEFRAEAF DB package: JE_FR_JELINES_RPT_PKG BI Publisher &p_gl_col_1 &p_gl_col_2 &p_gl_columns &p_gl_from &p_gl_join &p_gl_legal_ent_col &p_gl_legal_ent_from &p_gl_legal_ent_join &p_gl_party_details &p_gl_qualifier_segment &p_gl_seg_desc_from &p_gl_seg_desc_join &p_gl_view &p_gl_where &p_le_from &p_le_join &p_orderby_clause &p_other_param_filter &p_other_union &p_party_details &p_party_from &p_party_join &p_select_clause &p_sla_col_1 &p_sla_col_2 &p_sla_col_3 &p_sla_from &p_sla_join &p_sla_legal_ent_col &p_sla_legal_ent_from &p_sla_legal_ent_join &p_sla_qualifier_segment &p_sla_seg_desc_from &p_sla_seg_desc_join &p_trx_id_filter &p_trx_identifiers_1 &p_trx_identifiers_2 &p_trx_identifiers_3 &p_trx_identifiers_4 &p_trx_identifiers_5 &p_union_all &p_where_clause :p_account_flexfield_from :p_account_flexfield_to :p_account_segment_from :p_account_segment_to :p_accounted_amount_from :p_accounted_amount_to :p_acct_sequence_name :p_acct_sequence_num_from :p_acct_sequence_num_to :p_acct_sequence_version :p_additional_info :p_approved_query :p_balance_type :p_balance_type_code :p_balancing_segment_from :p_balancing_segment_to :p_budget_name :p_budget_version_id :p_coa_id :p_commercial_query :p_created_query :p_creation_date_from :p_creation_date_to :p_custom_header_query :p_custom_line_query :p_custom_parameter_1 :p_custom_parameter_10 :p_custom_parameter_11 :p_custom_parameter_12 :p_custom_parameter_13 :p_custom_parameter_14 :p_custom_parameter_15 :p_custom_parameter_16 :p_custom_parameter_17 :p_custom_parameter_18 :p_custom_parameter_19 :p_custom_parameter_2 :p_custom_parameter_20 :p_custom_parameter_21 :p_custom_parameter_22 :p_custom_parameter_23 :p_custom_parameter_24 :p_custom_parameter_25 :p_custom_parameter_26 :p_custom_parameter_27 :p_custom_parameter_28 :p_custom_parameter_29 :p_custom_parameter_3 :p_custom_parameter_30 :p_custom_parameter_4 :p_custom_parameter_5 :p_custom_parameter_6 :p_custom_parameter_7 :p_custom_parameter_8 :p_custom_parameter_9 :p_custom_query_flag :p_doc_seq_name :p_doc_sequence_name :p_doc_sequence_num_from :p_doc_sequence_num_to :p_dummy_event_class :p_encumbrance_type :p_encumbrance_type_id :p_entered_currency :p_event_class :p_event_class_rowid :p_fetch_from_gl :p_gl_batch_name :p_gl_col_1 :p_gl_col_2 :p_gl_columns :p_gl_date_from :p_gl_date_to :p_gl_from :p_gl_join :p_gl_legal_ent_col :p_gl_legal_ent_from :p_gl_legal_ent_join :p_gl_party_details :p_gl_qualifier_segment :p_gl_seg_desc_from :p_gl_seg_desc_join :p_gl_view :p_gl_where :p_include_le_info_flag :p_include_legal_entity_info :p_include_tax_details :p_include_tax_details_flag :p_include_user_trx_id_flag :p_include_user_trx_identifiers :p_include_zero_amount_flag :p_include_zero_amount_lines :p_je_category :p_je_category_name :p_je_source :p_je_source_name :p_je_status :p_je_status_code :p_le_col :p_le_from :p_le_join :p_ledger :p_ledger_id :p_legal_audit_flag :p_legal_entity :p_legal_entity_id :p_long_report :p_main_col_end :p_main_col_start :p_order_by :p_order_by_clause :p_orderby_clause :p_other_from :p_other_join :p_other_param_filter :p_other_union :p_party_details :p_party_details_col :p_party_from :p_party_id :p_party_join :p_party_name :p_party_number_from :p_party_number_to :p_party_type :p_party_type_code :p_period_from :p_period_to :p_period_type :p_post_accounting_program :p_post_acct_program_rowid :p_posted_query :p_posting_status :p_posting_status_code :p_process_category :p_process_category_rowid :p_resp_application_id :p_rpt_sequence_name :p_rpt_sequence_num_from :p_rpt_sequence_num_to :p_rpt_sequence_version :p_security_id_char_1 :p_security_id_char_2 :p_security_id_char_3 :p_security_id_int_1 :p_security_id_int_2 :p_security_id_int_3 :p_segment_col :p_select_clause :p_side :p_side_code :p_sla_col_1 :p_sla_col_2 :p_sla_col_3 :p_sla_from :p_sla_join :p_sla_legal_ent_col :p_sla_legal_ent_from :p_sla_legal_ent_join :p_sla_qualifier_segment :p_sla_seg_desc_from :p_sla_seg_desc_join :p_tax_query :p_transaction_date_from :p_transaction_date_to :p_transaction_view :p_trx_id_filter :p_trx_identifiers :p_trx_identifiers_1 :p_trx_identifiers_2 :p_trx_identifiers_3 :p_trx_identifiers_4 :p_trx_identifiers_5 :p_trx_legal_entity :p_trx_legal_entity_id :p_trx_num_from :p_trx_num_to :p_union_all :p_user_trx_id_column_1 :p_user_trx_id_column_2 :p_user_trx_id_column_3 :p_user_trx_id_column_4 :p_user_trx_id_column_5 :p_user_trx_id_value_1 :p_user_trx_id_value_2 :p_user_trx_id_value_3 :p_user_trx_id_value_4 :p_user_trx_id_value_5 :p_uti_col :p_valuation_method :p_vat_registration_query :p_where_clause :p_ytd_carriedfwd :p_ytd_carriedfwd_flag :p_ytd_carriedfwd_info 1 -60 :p_ledger Char SELECT NAME FROM GL_LEDGERS WHERE LEDGER_ID = :$flex$.ledger_ledger_set AR دفتر الأستاذ اسم دفتر الأستاذ D Buch Buchbezeichnung E Libro Mayor Nombre de Libro Mayor F Livre Nom du livre I Libro contabile Nome libro contabile RU Книга Имя книги S Huvudbok Huvudbok TR Ledger Defter Adı US Ledger Ledger Name 2 -50 :p_legal_entity Char SELECT NAME FROM XLE_FIRSTPARTY_INFORMATION_V WHERE LEGAL_ENTITY_ID = :$flex$.legal_entity AR P_LEGAL_ENTITY اسم الكيان القانوني D P_LEGAL_ENTITY Mandantenname E P_LEGAL_ENTITY Nombre de Entidad Jurídica F P_LEGAL_ENTITY Nom de l'entité juridique I P_LEGAL_ENTITY Nome della persona giuridica RU P_LEGAL_ENTITY Название юридического лица S P_LEGAL_ENTITY Juridisk enhet TR P_LEGAL_ENTITY Tüzel Kişilik Adı US P_LEGAL_ENTITY Legal Entity Name 3 -40 :p_je_source_name Char SELECT :$flex$.journal_entry_source.VALUE FROM DUAL AR P_JE_SOURCE_NAME اسم المصدر D P_JE_SOURCE_NAME Herkunftsbezeichnung E P_JE_SOURCE_NAME Nombre de Origen F P_JE_SOURCE_NAME Nom de l'origine I P_JE_SOURCE_NAME Nome dell'origine RU P_JE_SOURCE_NAME Имя источника S P_JE_SOURCE_NAME Källa TR P_JE_SOURCE_NAME Kaynak Adı US P_JE_SOURCE_NAME Source Name 4 -30 :p_coa_id LOV Oracle JEFR_CHART_OF_ACCOUNTS Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_ledgers where ledger_id=:$flex$.jefr_ledger_sets order by value,description SELECT chart_of_accounts_id FROM gl_ledgers WHERE ledger_id = :$flex$.ledger_ledger_set AR P_COA_ID معرف دليل الحسابات D P_COA_ID Kontenplankennung E P_COA_ID Id Plan de Cuentas F P_COA_ID ID plan de comptes I P_COA_ID ID del piano dei conti RU P_COA_ID Идент. плана счетов S P_COA_ID Kontoplans-id TR P_COA_ID Hesap Planı No US P_COA_ID Chart of Accounts ID 5 -20 :p_gl_date_from Date SELECT To_char(glp.start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')) FROM gl_periods glp ,gl_ledgers gl WHERE gl.ledger_id = :$flex$.ledger_ledger_set AND glp.period_set_name = gl.period_set_name AND glp.period_name = :$flex$.period_from Y AR P_GL_DATE_FROM تاريخ البداية D P_GL_DATE_FROM Von Datum E P_GL_DATE_FROM Fecha de Inicio F P_GL_DATE_FROM Date de début I P_GL_DATE_FROM Data avvio RU P_GL_DATE_FROM Начальная дата S P_GL_DATE_FROM Startdatum TR P_GL_DATE_FROM Başlangıç Tarihi US P_GL_DATE_FROM Start Date 6 -10 :p_gl_date_to Date SELECT To_char(glp.end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')) FROM gl_periods glp ,gl_ledgers gl WHERE gl.ledger_id = :$flex$.ledger_ledger_set AND glp.period_set_name = gl.period_set_name AND glp.period_name = :$flex$.period_to Y AR P_GL_DATE_TO تاريخ النهاية D P_GL_DATE_TO Bis Datum E P_GL_DATE_TO Fecha de Finalización F P_GL_DATE_TO Date de fin I P_GL_DATE_TO Data fine RU P_GL_DATE_TO Конечная дата S P_GL_DATE_TO Slutdatum TR P_GL_DATE_TO Bitiş Tarihi US P_GL_DATE_TO End Date 7 10 :p_ledger_id LOV Oracle JEFR_LEDGER_SETS Y select ledger_id id, name value, description description from gl_ledgers a where ( nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N' or exists (select 1 from gl_access_set_ledgers b where b.ledger_id=a.ledger_id and b.access_set_id in (decode (fnd_global.resp_appl_id ,101 ,null ,decode (fnd_profile.value('XLA_USE_LEDGER_SECURITY') ,'Y' ,fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID') ,null ) ) ,decode (fnd_global.resp_appl_id ,101 ,fnd_profile.value('GL_ACCESS_SET_ID') ,decode (fnd_profile.value('XLA_USE_LEDGER_SECURITY') ,'Y' ,fnd_profile.value('GL_ACCESS_SET_ID') ,b.access_set_id) ) ) ) ) order by value,description Y 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 RU Книга/набор книг Книга/набор книг S Huvudbok/huvudboksgrupp Huvudbok/huvudboksgrupp TR Defter/Defter Kümesi Defter/Defter Kümesi US Ledger/Ledger Set Ledger/Ledger Set 8 20 :p_legal_entity_id LOV Oracle JEFR_LEGAL_ENTITIES Y select xfi.legal_entity_id id, xfi.name value, null description from xle_firstparty_information_v xfi where legal_entity_id in (select legal_entity_id from gl_ledger_le_v where ledger_id in (select ledger_id from gl_ledger_set_assignments where ledger_set_id=:$flex$.jefr_ledger_sets) or ledger_id=:$flex$.jefr_ledger_sets) order by xfi.name Y AR الكيان القانوني معرف الكيان القانوني D Mandant Mandantenkennung E Entidad Jurídica Id Entidad Jurídica F Entité juridique ID entité juridique I Persona giuridica Id persona giuridica RU Юридическое лицо Идент. юридического лица S Juridisk enhet Id för juridisk enhet TR Tüzel Kişilik Tüzel Kişilik No US Legal Entity Legal Entity ID 9 30 :p_je_source LOV Oracle JGSLA_SRS_JE_SOURCES_ALL Y select je_source_name id, user_je_source_name value, null description from (select user_je_source_name,je_source_name from gl_je_sources union all select meaning,'#ALL#' from xla_lookups where lookup_type='XLA_ALL') a where exists (select 1 from xla_subledgers b where b.je_source_name= decode ((select 1 from xla_subledgers where application_id=fnd_global.resp_appl_id) ,1,a.je_source_name ,b.je_source_name ) and b.application_id= decode ((select 1 from xla_subledgers where application_id=fnd_global.resp_appl_id) ,1,fnd_global.resp_appl_id ,b.application_id ) ) or (fnd_profile.value('XLA_JE_SOURCE_ALLOW_OVERRIDE')='Y' and a.je_source_name='#ALL#' ) order by upper(user_je_source_name) Y AR مصدر قيد اليومية المصدر D Belegherkunft Herkunft E Origen de Asiento Origen F Origine des pièces Origine I Origine scrittura contabile Origine RU Источник записи Источник S Verifikationskälla Källa TR Fiş Giriş Kaynağı Kaynak US Journal Entry Source Source 10 40 :p_account_flexfield_from Char Y AR من الحقل المحاسبي المرن من الحقل المحاسبي المرن D Von Konto-FlexFeld Von Konto-FlexFeld E De Estructura Contable De Estructura Contable F Clé comptable flexible - De Clé comptable flexible - De I Flexfied contabile - Da Flexfied contabile - Da RU ГП плана счетов с ГП плана счетов с S Från kodsträng Från kodsträng TR İlk Hesap Esnekalanı İlk Hesap Esnekalanı US Accounting Flexfield From Accounting Flexfield From 11 50 :p_account_flexfield_to Char Y AR إلى الحقل المحاسبي المرن إلى الحقل المحاسبي المرن D Bis Konto-FlexFeld Bis Konto-FlexFeld E A Estructura Contable A Estructura Contable F Clé comptable flexible - A Clé comptable flexible - A I Flexfield contabile - A Flexfield contabile - A RU ГП плана счетов по ГП плана счетов по S Till kodsträng Till kodsträng TR Son Hesap Esnekalanı Son Hesap Esnekalanı US Accounting Flexfield To Accounting Flexfield To 12 60 :p_show_adj_periods LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description Y AR إظهار فترات التعديل إظهار فترات التعديل D Korrekturperioden anzeigen Korrekturperioden anzeigen E Mostrar Períodos de Ajuste Mostrar Períodos de Ajuste F Afficher les périodes d'ajustement Afficher les périodes d'ajustement I Mostra periodi adeguamento Mostra i periodi adeguamento RU Показать периоды корректировки Показать периоды корректировки S Visa justeringsperioder Visa justeringsperioder TR Düzeltme Dönemlerini Göster Düzeltme Dönemlerini Göster US Show Adjustment Periods Show Adjustment Periods 13 70 :p_period_from LOV Oracle JEFR_PERIOD_FROM_ADJ Y select period_name id, period_name value, null description from gl_ledgers gl,gl_periods glp where gl.ledger_id=:$flex$.jefr_ledger_sets and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and ((nvl(:$flex$.xla_srs_yes_no,'N')='N' and glp.adjustment_period_flag='N') or(nvl(:$flex$.xla_srs_yes_no,'N')='Y')) order by glp.period_year desc,glp.period_num desc Y AR من الفترة من الفترة D Von Periode Von Periode E De Período De Período F Période - De Période - De I Periodo - Da Periodo - Da RU Период с Период с S Från period Från period TR Dönem Başlangıcı Dönem Başlangıcı US Period From Period From 14 80 :p_period_to LOV Oracle JEFR_PERIOD_TO_ADJ Y select period_name id, period_name value, null description from gl_ledgers gl,gl_periods glp where ((nvl(:$flex$.xla_srs_yes_no,'N')='N' and glp.adjustment_period_flag='N') or (nvl(:$flex$.xla_srs_yes_no,'N')='Y')) and gl.ledger_id=:$flex$.jefr_ledger_sets and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.period_year= (select glp2.period_year from gl_periods glp2 where glp2.period_set_name=glp.period_set_name and glp2.period_type=glp.period_type and glp2.period_name= :$flex$.jefr_period_from_adj ) and glp.period_num>= (select glp2.period_num from gl_periods glp2 where glp2.period_set_name=glp.period_set_name and glp2.period_type=glp.period_type and glp2.period_name= :$flex$.jefr_period_from_adj ) order by glp.period_year desc,glp.period_num desc SELECT :$flex$.period_from from DUAL Y AR إلى الفترة إلى الفترة D Bis Periode Bis Periode E A Período A Período F Période - A Période - A I Periodo - A Periodo - A RU Период по Период по S Till period Till period TR Dönem Sonu Dönem Sonu US Period To Period To 15 90 :p_posting_status_code LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_YES_NO' AND LOOKUP_CODE = 'Y' 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 RU Статус проводки Статус проводки S Postningsstatus Postningsstatus TR Muhasebeleşme Statüsü Muhasebeleşme Statüsü US Posting Status Posting Status 16 100 :p_period_type LOV Oracle JGSLAJNLLG_ACCT_PERIOD_TYPES_SET Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='JGSLAJNLLG_ACCT_PERIOD_TYPES' order by value,description select meaning from fnd_lookups where lookup_type = 'JGSLAJNLLG_ACCT_PERIOD_TYPES' and lookup_code = 'B' Y AR نوع الفترة المحاسبية نوع الفترة المحاسبية D Buchungsperiodenart Buchungsperiodenart E Tipo de Período Contable Tipo de Período Contable F Type de période comptable Type de période comptable I Tipo periodo contabile Tipo di periodo contabile RU Тип учетного периода Тип учетного периода S Typ av redovisningsperiod Typ av redovisningsperiod TR Muhasebe Dönemi Tipi Muhasebe Dönemi Tipi US Accounting Period Type Accounting Period Type 17 110 :p_doc_sequence_name LOV Oracle JGSLA_DOC_SEQ_NAMES Y select name id, name value, null description from fnd_document_sequences order by value,description AR اسم مسلسل المستند اسم مسلسل المستند D Belegfolge Belegfolge E Nombre de Secuencia de Documento Nombre de Secuencia de Documento F Nom de la séquence de document Nom de la séquence de document I Nome sequenza documenti Nome sequenza documenti RU Имя последовательности документов Имя последовательности документов S Dokumentsekvens Dokumentsekvens TR Doküman Sıra Adı Doküman Sıra Adı US Document Sequence Name Document Sequence Name 18 120 :p_custom_parameter_1 LOV Oracle JEFR_RPT_SORT_BY Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='JEFR_RPT_SORT_PARAMS' and language=userenv('LANG') order by value,description Select meaning from fnd_lookup_values where lookup_type='JEFR_RPT_SORT_PARAMS' and lookup_code='ACCOUNTING_SEQUENCE' AND LANGUAGE=USERENV('LANG') Y AR فرز بواسطة فرز التقرير D Sortieren nach Sortiert nach E Ordenar por Clasificación del Informe F Tri par Tri d'état I Ordina per Ordinamento rapporto RU Сортировка Сортировка отчета S Sortera efter Sortering av rapport TR Sıralama Bazı Rapor Sıralaması US Sort By Report Sort 19 130 :p_include_zero_amount_flag LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_YES_NO' AND LOOKUP_CODE = 'N' AR تضمين المبلغ الصفري تضمين المبلغ الصفري D Mit Nullsalden Mit Nullsalden E Incluir Importe Cero Incluir Importe Cero F Inclure les montants de valeur zéro Inclure les montants de valeur zéro I Includi importo zero Include l'importo zero RU Включать нулевые суммы Включать нулевые суммы S Inkludera nollbelopp Inkludera nollbelopp TR Sıfır Tutarı Dahil Et Sıfır Tutarı Dahil Et US Include Zero Amount Include Zero Amount 20 140 :p_additional_info LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT MEANING FROM XLA_LOOKUPS WHERE LOOKUP_TYPE = 'XLA_YES_NO' AND LOOKUP_CODE = 'Y' Y AR المعلومات الإضافية المعلومات الإضافية D Weitere Informationen Weitere Informationen E Información Adicional Información Adicional F Informations complémentaires Informations complémentaires I Ulteriori informazioni Ulteriori informazioni RU Дополнительные сведения Дополнительные сведения S Mer information Mer information TR Ek Bilgiler Ek Bilgiler US Additional Information Additional Information