ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4727251A9E05362FB09050512Y select decode(grlcr.amount, NULL, null, NULL) FLEX_2_DATA_ALL, decode(grlcr.amount, NULL, null, NULL) FLEX_2_DATA_ALL_GLLE, --grlcr.recurring_header_id HEADER_ID, grlcr.recurring_header_id HEADER_ID2, --grlcr.recurring_line_num LINE_NUM, grlcr.recurring_line_num LINE_NUM1, grlcr.rule_num RULE_NUM, grlcr.amount AMOUNT, gl1.description TYPE, gl2.meaning AMOUNT_TYPE, grlcr.ledger_currency CURRENCY_CODE, grlcr.entered_currency ENTERED_CURRENCY, decode (grlcr.currency_type , 'E',gl5.description, 'S',gl6.description, 'T',gl7.description, 'C',gl8.description ) CURRENCY_TYPE, gl4.meaning PERIOD, grlcr.operator OPERATOR --, decode(:BATCH_TYPE_CODE, 'S', fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_2_field_all', 'SQLGL', 'GL#', gcc1.CHART_OF_ACCOUNTS_ID, NULL, gcc1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_2_field_all_glle', 'SQLGL', 'GLLE', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE')) FLEX_2_FIELD_ALL --, --fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_2_field_all', 'SQLGL', 'GL#', gcc1.CHART_OF_ACCOUNTS_ID, NULL, gcc1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_2_FIELD_ALL from gl_recurring_line_calc_rules grlcr, gl_lookups gl1, gl_lookups gl2, gl_lookups gl4, gl_lookups gl5, gl_lookups gl6, gl_lookups gl7, gl_lookups gl8, gl_ledger_relationships lr where gl1.lookup_type (+) = 'BATCH_TYPE' and gl1.lookup_code (+) = grlcr.actual_flag and gl2.lookup_type (+) = decode( grlcr.amount_type, 'PTD', 'PTD_YTD', 'YTD', 'PTD_YTD', 'PATD', 'PATD_EOD', 'YATD', 'PATD_EOD', 'EOD', 'PATD_EOD', '' ) and gl2.lookup_code(+) = grlcr.amount_type and gl4.lookup_type (+) = 'PERIOD CODE' and gl4.lookup_code (+) = grlcr.relative_period_code and gl5.lookup_code = 'E' and gl5.lookup_type = 'GL_CURRENCY_TYPE' and gl6.lookup_code ='S' and gl6.lookup_type = 'GL_CURRENCY_TYPE' and gl7.lookup_code = 'T' and gl7.lookup_type = 'GL_CURRENCY_TYPE' and gl8.lookup_code ='C' and gl8.lookup_type = 'GL_CURRENCY_TYPE' and lr.source_ledger_id (+) = grlcr.ledger_id and lr.target_ledger_id (+) = grlcr.ledger_id and lr.target_currency_code (+) = grlcr.ledger_currency and lr.application_id (+) = 101 and grlcr.recurring_header_id=:HEADER_ID1 and grlcr.recurring_line_num=:LINE_NUM order by grlcr.rule_num SQLGL GLXRLRFL_XML AR GL أخرى - قائمة الصيغ الدورية (بتنسيق XML) Imported from BI Publisher Description: قائمة صيغ الموازنات واليوميات الدورية Application: الأستاذ العام Source: أخرى - قائمة الصيغ الدورية (بتنسيق XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG D GL Sonstiges - Wiederkehrende Buchungen - Formeln Imported from BI Publisher Description: Wiederkehrende Buchungs- und Budgetformeln Application: Rechnungswesen Source: Sonstiges - Wiederkehrende Buchungen - Formeln (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG E GL Otros - Listado de Fórmulas Recurrentes Imported from BI Publisher Description: Listado de Asientos Recurrentes y Fórmulas Presupuestarias Application: General Ledger Source: Otros - Listado de Fórmulas Recurrentes (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG F GL Autres - Liste formules répétitives Imported from BI Publisher Description: Liste des formules de pièces répétitives et des formules budgétaires Application: General Ledger Source: Autres - Liste formules répétitives (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG I GL Altro - Elenco formule periodiche Imported from BI Publisher Description: Elenco delle formule del budget e delle scritture periodiche Application: General Ledger Source: Altro - Elenco formule periodiche (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG JA GL その他 - 定型仕訳算式一覧表 Imported from BI Publisher Description: 定型仕訳と予算算式リスト Application: General Ledger Source: その他 - 定型仕訳算式一覧表 (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG KO GL 기타 - 반복 공식 목록 Imported from BI Publisher Description: 반복 분개 및 예산 공식 목록 Application: General Ledger Source: 기타 - 반복 공식 목록(XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG PTB GL Outro - Lista de Fórmulas Repetitivas Imported from BI Publisher Description: Lista de Lançamentos Repetitivos e Fórmulas de Orçamento Application: General Ledger Source: Outro - Lista de Fórmulas Repetitivas (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG RU GL Другое - список периодических формул Imported from BI Publisher Description: Список периодических журнальных и бюджетных формул Application: Главная книга Source: Другое - список периодических формул (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG S GL Övrigt - Lista över återkommande formler Imported from BI Publisher Description: Återkommande verifikationer och budgetformler - lista Application: General Ledger Source: Övrigt - Lista över återkommande formler (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG TR GL Diğer - Tekrarlı Formül Listesi Imported from BI Publisher Description: Tekrarlı Fiş ve Bütçe Formül Listesi Application: Genel Muhasebe Source: Diğer - Tekrarlı Formül Listesi (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG US GL Other - Recurring Formula Listing Imported from BI Publisher Description: Recurring Journal and Budget Formula Listing Application: General Ledger Source: Other - Recurring Formula Listing (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG ZHS GL 其它 - 经常性公式列表 Imported from BI Publisher Description: 经常性日记账和预算公式列表 Application: 总帐管理系统 Source: 其它 - 经常性公式列表 (XML) Short Name: GLXRLRFL_XML DB package: GL_GLXRLRFL_XMLP_PKG BI Publisher :flex_1_select_all :flex_2_select_all :flex_2_select_all_glle :header_id1 :line_num :p_conc_request_id :p_period_set :p_period_type :p_recurring_batch_id :p_struct_num 1 -40 :p_struct_num 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 科目表标识 科目表标识 2 -30 :p_period_set Char SELECT period_set_name FROM GL_ACCESS_SETS WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR اسم مجموعة الفترات اسم مجموعة الفترات D Bezeichnung PeriodenSet Bezeichnung PeriodenSet E Nombre de Juego de Períodos Nombre de Juego de Períodos F Nom du jeu de périodes Nom du jeu de périodes I Nome serie di periodi Nome serie di periodi JA 期間セット名 期間セット名 KO 기간 세트명 기간 세트명 PTB Nome do Conjunto de Períodos Nome do Conjunto de Períodos RU Имя набора периодов Имя набора периодов S Namn på periodserie Namn på periodserie TR Dönem Kümesi Adı Dönem Kümesi Adı US Period Set Name Period Set Name ZHS 期间集名称 期间集名称 3 -20 :p_period_type Char SELECT accounted_period_type FROM GL_ACCESS_SETS WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID') Y AR نوع الفترة المحاسبية نوع الفترة المحاسبية D Buchungsperiodenart Buchungsperiodenart E Tipo de Período Contable Tipo de Período Contable F Types de période comptabilisée Types de période comptabilisée I Tipo di periodo contabilizzato Tipo di periodo contabilizzato JA 計上済期間タイプ 計上済期間タイプ KO 계상된 기간 유형 계상된 기간 유형 PTB Tipo de Período Contábil Tipo de Período Contábil RU Тип учтенного периода Тип учтенного периода S Typ av redovisningsperiod Typ av redovisningsperiod TR Muhasebeye Katılan Dönem Tipi Muhasebeye Katılan Dönem Tipi US Accounted Period Type Accounted Period Type ZHS 入账期间类型 入账期间类型 4 10 :p_recurring_batch_id LOV Oracle GL_SRS_GLXRLRFL_P1 Y select recurring_batch_id id, name value, null description from gl_recurring_batches where (chart_of_accounts_id,period_set_name,accounted_period_type)=(select chart_of_accounts_id,period_set_name,accounted_period_type from gl_access_sets where access_set_id=fnd_profile.value('GL_ACCESS_SET_ID')) and decode(security_flag,'Y',decode(fnd_data_security.check_function(1.0,'GL_DAS_RECURRING_JOURNAL_V','GL_DAS_RECURRING_JOURNAL',to_char(recurring_batch_id),null,null,null,null,fnd_global.user_name),'T','Y','N'),'Y')='Y' order by name 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 批名 批名