ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4702A51A9E05362FB09050512 select &P_acct_flex Account, decode(:P_sort_id,1,&P_item_flex,&SORT_COL) Sort_option, &C_batch_sel round(sum(nvl(mta.base_transaction_value,0)), :r_extended_precision) Net_activity, round(sum(decode( nvl(mta.base_transaction_value,0) / abs(decode( nvl(mta.base_transaction_value,0), 0, 1, nvl( mta.base_transaction_value,0 ) )), 1, nvl(mta.base_transaction_value,0), 0 ) ), :r_extended_precision) sum_debits, round(sum(decode( nvl(mta.base_transaction_value,0) / abs(decode( nvl(mta.base_transaction_value,0), 0, 1, nvl( mta.base_transaction_value,0 ) )), -1, nvl(abs(mta.base_transaction_value),0), 0 ) ), :r_extended_precision) sum_credits, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_pad', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_acct_pad, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_field', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_acct_field, /* INV_INVTRACS_XMLP_PKG.c_sort_padformula(:C_sort_pad, decode ( :P_sort_id , 1 , ( MSI.SEGMENT1 || '\n' || MSI.SEGMENT2 || '\n' || MSI.SEGMENT3 || '\n' || MSI.SEGMENT4 || '\n' || MSI.SEGMENT5 || '\n' || MSI.SEGMENT6 || '\n' || MSI.SEGMENT7 || '\n' || MSI.SEGMENT8 || '\n' || MSI.SEGMENT9 || '\n' || MSI.SEGMENT10 || '\n' || MSI.SEGMENT11 || '\n' || MSI.SEGMENT12 || '\n' || MSI.SEGMENT13 || '\n' || MSI.SEGMENT14 || '\n' || MSI.SEGMENT15 || '\n' || MSI.SEGMENT16 || '\n' || MSI.SEGMENT17 || '\n' || MSI.SEGMENT18 || '\n' || MSI.SEGMENT19 || '\n' || MSI.SEGMENT20 ) , 'X' )) C_sort_pad,*/ --fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_field, decode(:P_sort_id,1,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'),&SORT_COL) C_item_field, INV_INVTRACS_XMLP_PKG.get_debit(round ( sum ( nvl ( mta.base_transaction_value , 0 ) ) , :r_extended_precision )) C_debits, INV_INVTRACS_XMLP_PKG.get_credit(round ( sum ( nvl ( mta.base_transaction_value , 0 ) ) , :r_extended_precision )) C_credits from mtl_material_transactions mmt, &C_item_from gl_code_combinations gcc, mtl_transaction_accounts mta &C_type_from &C_gl_batch_from where mta.transaction_id = mmt.transaction_id &C_type_where &C_item_where and mta.reference_account = gcc.code_combination_id and mta.organization_id = :P_org_id and mta.accounting_line_type <> 15 and &P_where_acct &P_date_range &C_gl_batch_where group by &P_acct_flex, decode(:P_sort_id,1,&P_item_flex,&SORT_COL), &C_batch_desc ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_pad', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_field', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'),decode(:P_sort_id,1,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'),&SORT_COL) order by 8, 10, 5, 1 , 2 Y INV INVTRACS_XML AR INV إجمالي توزيع حساب المواد (بتنسيق XML) Imported from BI Publisher Description: إجمالي توزيع حساب المواد Application: المخازن Source: إجمالي توزيع حساب المواد (بتنسيق XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG D INV Materialkontenaufteilungen - Übersicht Imported from BI Publisher Description: Materialkontenaufteilungen - Übersicht Application: Lager Source: Materialkontenaufteilungen - Übersicht (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG E INV Resumen de Distribución de Cuenta de Material Imported from BI Publisher Description: Resumen de Distribuciones Contables de Material Application: Inventory Source: Resumen de Distribución de Cuenta de Material (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG F INV Synthèse des imputations par compte matière Imported from BI Publisher Description: Synthèse des imputations par compte matière Application: Inventory Source: Synthèse des imputations par compte matière (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG I INV Sintetico distribuzione conto materiali Imported from BI Publisher Description: Sintetico distribuzione conto materiali Application: Inventory Source: Sintetico distribuzione conto materiali (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG JA INV 材料費配分要約 Imported from BI Publisher Description: 材料費配分要約 Application: Inventory Source: 材料費配分要約(XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG KO INV 재료비 계정 분배 요약 Imported from BI Publisher Description: 재료비 계정 분배 요약 Application: Inventory Source: 재료비 계정 분배 요약(XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG PTB INV Resumo da classificação contábil de material Imported from BI Publisher Description: Sumário de distribuição de conta de material Application: Inventário Source: Resumo da classificação contábil de material (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG RU INV Сводка распределения счетов материалов Imported from BI Publisher Description: Сводка распределения счетов материалов Application: Запасы Source: Сводка распределения счетов материалов (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG S INV Översikt över kontering av materialkonto Imported from BI Publisher Description: Översikt över kontering av materialkonto Application: Inventory Source: Översikt över kontering av materialkonto (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG TR INV Malzeme hesap dağıtım özeti Imported from BI Publisher Description: Malzeme hesap dağıtım özeti Application: Stok Yönetimi Source: Malzeme hesap dağıtım özeti (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG US INV Material account distribution summary Imported from BI Publisher Description: Material account distribution summary Application: Inventory Source: Material account distribution summary (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG ZHS INV 物料帐户分配汇总 Imported from BI Publisher Description: 物料帐户分配汇总 Application: 库存管理系统 Source: 物料帐户分配汇总 (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG BI Publisher &c_batch_desc &c_batch_sel &c_gl_batch_from &c_gl_batch_where &c_item_from &c_item_where &c_type_from &c_type_where &p_acct_flex &p_date_range &p_item_flex &p_where_acct &sort_col :p_acct_flex :p_acct_hi :p_acct_lo :p_conc_request_id :p_date_range :p_from_date :p_from_date_dsp :p_from_date_t :p_gl_batch_id :p_gl_struct_num :p_item_flex :p_org_id :p_sort_id :p_struct_num :p_to_date :p_to_date_dsp :p_to_date_t :p_where_acct :r_extended_precision 1 -30 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 2 -20 :p_gl_struct_num Number select CHART_OF_ACCOUNTS_ID from org_organization_definitions where ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') Y AR هيكل الأستاذ العام المرن هيكل مرن للحساب D Konto-FlexFeld-Struktur Konto-FlexFeld-Struktur E Tipo de Estructura Contable Tipo de Estructura Contable F Structure flex GL Structure de clé comptable flexible I Struttura flex GL Struttura flexfield contabile JA GLフレックス体系 会計フレックス体系 KO GL 가변 구조 계정 가변 구조 PTB Estrutura Flex GL Estrutura Flex de Conta RU Структура ГП ГК Структура ГП плана счетов S RED-flexstruktur Kodsträngsstruktur TR GL Esnek Yapısı Hesap Esnek Yapısı US GL Flex Structure Account Flex Structure ZHS GL 弹性结构 帐户弹性结构 3 10 :p_sort_id LOV Oracle INV_SRS_ACS_SORT_OPTIONS Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_ACS_SORT' and enabled_flag='Y' order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'INV_SRS_ACS_SORT' AND ENABLED_FLAG = 'Y' AND LOOKUP_CODE = 1 Y AR فرز بواسطة خيار الفرز D Sortieren nach Sortieroption E Ordenar por Opción de Ordenación F Tri par Option de tri I Ordina per Opzione di ordinamento JA ソート・キー ソート・オプション KO 정렬 기준 정렬 옵션 PTB Classificar por Opção de Classificação RU Сортировка Параметр сортировки S Sortera efter Sorteringsalternativ TR Sıralama Bazı Sıralama Seçeneği US Sort By Sort Option ZHS 排序依据 排序选项 4 20 :p_from_date Date AR تواريخ الحركات من تاريخ حركة من D Von Transaktionsdatum Von Transaktionsdatum E De Fecha de Transacción De Fecha de Transacción F Dates de mouvement - Du Date du mouvement - Du : I Date transazione - Da Data transazione minima JA 取引日:自 取引日:自 KO 트랜잭션 일자: 부터 트랜잭션 일자 하한 PTB Datas Transação - De Data de Transação - Inferior RU Даты транзакций с Дата транзакции с S Från transaktionsdatum Från transaktionsdatum TR İşlem Tarihleri: İlk İşlem Tarihi Alt Değeri US Transaction Dates From Transaction Date Low ZHS 事务处理起始日期 事务处理日期下限 5 30 :p_to_date Date AR إلى تاريخ حركة إلى D Bis Bis Transaktionsdatum E A A Fecha de Transacción F Au Date du mouvement - Au : I A Data transazione massima JA 至 取引日:至 KO 까지 트랜잭션 일자 상한 PTB Até Data de Transação - Superior RU По Дата транзакции по S Till Till transaktionsdatum TR Son İşlem Tarihi Üst Değeri US To Transaction Date High ZHS 至 事务处理日期上限 6 40 :p_acct_lo Char AR حسابات من من حساب D Von Konto Von Konto E De Cuenta De Cuenta F Comptes - De Compte - De I Conti - Da Conto - minimo JA 勘定科目:自 勘定科目:自 KO 계정: From 계정 하한 PTB Contas - De Conta Inferior RU Счета с Счет с S Från konton Från konto TR Hesaplar, İlk Hesap Alt Değeri US Accounts From Account Low ZHS 帐户自 帐户下限 7 50 :p_acct_hi Char AR إلى 2 إلى حساب D Bis 2 Bis Konto E A 2 A Cuenta F A Compte - A I A 2 Conto - massimo JA 至 2 勘定科目:至 KO 까지 2 계정 상한 PTB Até 2 Conta Superior RU По 2 Счет по S Till 2 Till konto TR Son 2 Hesap Üst Değeri US To 2 Account High ZHS 至 2 帐户上限 8 60 :p_gl_batch_id LOV Oracle INV_SRS_GL_BATCH_NUMBER Y select ogb.gl_batch_id id, ogb.gl_batch_id value, null description from org_gl_batches ogb,org_acct_periods oap where ogb.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and oap.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and oap.acct_period_id=ogb.acct_period_id order by ogb.creation_date desc AR مجموعة أ/ع معرف مجموعة أ/ع D Stapel Stapelkennung E Lote Contable Id Lote Contable F Lot GL ID lot GL I Batch GL ID batch GL JA GLバッチ GLバッチID KO GL 뱃치 GL 뱃치 ID PTB Lote GL ID do Lote GL RU Пакет ГК Идентификатор пакета ГК S Huvudboksbunt HB-bunt-id TR GL İşlem Grubu GL Grup No US GL Batch GL Batch ID ZHS GL 批 GL 批标识