ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472B051A9E05362FB09050512Y select &P_FLEXDATA C_FLEXDATA, L.description Account_Description, M.meaning Transaction_Type, SUM(GREATEST(round(WA.base_transaction_value,:mprecision),0)) C_DEBITS, ABS(SUM(LEAST(round(WA.base_transaction_value,:mprecision),0))) C_CREDITS, SUM(round(WA.base_transaction_value,:mprecision)) C_NET_ACTIVITY, fnd_flex_xml_publisher_apis.process_kff_combination_1('account', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') Account, /* WIP_WIPUTACS_XMLP_PKG.c_acct_descripformula(( L.SEGMENT1 || '\n' || L.SEGMENT2 || '\n' || L.SEGMENT3 || '\n' || L.SEGMENT4 || '\n' || L.SEGMENT5 || '\n' || L.SEGMENT6 || '\n' || L.SEGMENT7 || '\n' || L.SEGMENT8 || '\n' || L.SEGMENT9 || '\n' || L.SEGMENT10 || '\n' || L.SEGMENT11 || '\n' || L.SEGMENT12 || '\n' || L.SEGMENT13 || '\n' || L.SEGMENT14 || '\n' || L.SEGMENT15 || '\n' || L.SEGMENT16 || '\n' || L.SEGMENT17 || '\n' || L.SEGMENT18 || '\n' || L.SEGMENT19 || '\n' || L.SEGMENT20 || '\n' || L.SEGMENT21 || '\n' || L.SEGMENT22 || '\n' || L.SEGMENT23 || '\n' || L.SEGMENT23 || '\n' || L.SEGMENT25 || '\n' || L.SEGMENT26 || '\n' || L.SEGMENT27 || '\n' || L.SEGMENT28 || '\n' || L.SEGMENT29 || '\n' || L.SEGMENT30 ), :Account, :C_ACCT_DESCRIP) C_ACCT_DESCRIP,*/ fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_descrip', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') C_ACCT_DESCRIP, WIP_WIPUTACS_XMLP_PKG.c_flex_sortformula(( L.SEGMENT1 || '\n' || L.SEGMENT2 || '\n' || L.SEGMENT3 || '\n' || L.SEGMENT4 || '\n' || L.SEGMENT5 || '\n' || L.SEGMENT6 || '\n' || L.SEGMENT7 || '\n' || L.SEGMENT8 || '\n' || L.SEGMENT9 || '\n' || L.SEGMENT10 || '\n' || L.SEGMENT11 || '\n' || L.SEGMENT12 || '\n' || L.SEGMENT13 || '\n' || L.SEGMENT14 || '\n' || L.SEGMENT15 || '\n' || L.SEGMENT16 || '\n' || L.SEGMENT17 || '\n' || L.SEGMENT18 || '\n' || L.SEGMENT19 || '\n' || L.SEGMENT20 || '\n' || L.SEGMENT21 || '\n' || L.SEGMENT22 || '\n' || L.SEGMENT23 || '\n' || L.SEGMENT23 || '\n' || L.SEGMENT25 || '\n' || L.SEGMENT26 || '\n' || L.SEGMENT27 || '\n' || L.SEGMENT28 || '\n' || L.SEGMENT29 || '\n' || L.SEGMENT30 ), :Account, :C_ACCT_DESCRIP, :C_FLEX_SORT) C_FLEX_SORT from gl_code_combinations L, mfg_lookups M, wip_transaction_accounts WA, wip_transactions WT, mtl_categories_b mc, mtl_item_categories mic where WT.Organization_id = :P_Organization_Id and WA.accounting_line_type != 15 and &P_PROJECT_WHERE &Limit_Dates and WA.transaction_id = WT.transaction_id and mic.organization_id(+) = :P_Organization_Id and mic.category_set_id(+) = :P_Category_Set and mic.inventory_item_id(+) = WT.primary_item_id and mc.category_id(+) = mic.category_id and &P_Cat_Where and WA.organization_id = :P_Organization_Id &P_Limit_Accounts and NVL(wa.gl_batch_id,-1) = NVL(:P_GL_Batch_Id,NVL(wa.gl_batch_id,-1)) and WA.reference_account = L.code_combination_id and L.chart_of_accounts_id = &P_STRUCT_NUM and M.lookup_code = WT.transaction_type and M.lookup_type = 'WIP_TRANSACTION_TYPE' group by &P_FLEXDATA, L.description, M.meaning , fnd_flex_xml_publisher_apis.process_kff_combination_1('account', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_descrip', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') order by &P_FLEXDATA, M.meaning WIP WIPUTACS_XML AR WIP تقرير إجمالي حساب ما تحت التنفيذ (بتنسيق XML) Imported from BI Publisher Description: تقرير إجمالي حساب ما تحت التنفيذ Application: العمل في الإنجاز Source: تقرير إجمالي حساب ما تحت التنفيذ (بتنسيق XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG D WIP Fertigung - Kontenübersicht Imported from BI Publisher Description: Fertigung - Kontenübersicht Application: Fertigung Source: Fertigung - Kontenübersicht (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG E WIP Resumen de Cuentas de Obra en Curso Imported from BI Publisher Description: Informe de resumen de cuentas de obra en curso Application: Work in Process Source: Resumen de Cuentas de Obra en Curso (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG F WIP Etat Synthèse de la comptabilisation des en-cours Imported from BI Publisher Description: Etat Synthèse de la comptabilisation des en-cours Application: Work In Process Source: Etat Synthèse de la comptabilisation des en-cours (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG I WIP Rapporto Sintetico conti WIP Imported from BI Publisher Description: Rapporto Sintetico conti WIP Application: Work in Process Source: Rapporto Sintetico conti WIP (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG JA WIP WIP勘定要約レポート Imported from BI Publisher Description: WIP勘定要約レポート Application: Work in Process Source: WIP勘定要約レポート(XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG KO WIP 계정 요약 보고서 Imported from BI Publisher Description: WIP 계정 요약 보고서 Application: Work in Process Source: WIP 계정 요약 보고서(XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG PTB WIP Relatório Sumariado da Conta do WIP Imported from BI Publisher Description: Rel.Sumário Contas WIP Application: Work in Process Source: Relatório Sumariado da Conta do WIP (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG RU WIP Сводный отчет о счетах НзП Imported from BI Publisher Description: Сводный отчет о счетах НзП Application: Незавершенное производство Source: Сводный отчет о счетах НзП (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG S WIP PIA-kontoöversikt - rapport Imported from BI Publisher Description: PIA-kontoöversikt - rapport Application: Work in Process Source: PIA-kontoöversikt - rapport (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG TR WIP Hesap Özeti Raporu Imported from BI Publisher Description: WIP Hesap Özeti Raporu Application: Üretim İzleme Source: WIP Hesap Özeti Raporu (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG US WIP Account Summary Imported from BI Publisher Description: WIP Account Summary Report Application: Work in Process Source: WIP Account Summary Report (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG ZHS WIP 帐户汇总报表 Imported from BI Publisher Description: WIP 帐户汇总报表 Application: 在制品管理系统 Source: WIP 帐户汇总报表 (XML) Short Name: WIPUTACS_XML DB package: WIP_WIPUTACS_XMLP_PKG BI Publisher &limit_dates &p_cat_where &p_flexdata &p_limit_accounts &p_project_where &p_struct_num :account :c_acct_descrip :c_flex_sort :lp_from_date :lp_to_date :mprecision :p_account :p_cat_from :p_cat_num :p_cat_seg :p_cat_to :p_cat_where :p_category_set :p_conc_request_id :p_currency_code :p_debug :p_flexdata :p_from_date :p_gl_batch_id :p_limit_accounts :p_organization_id :p_project_id :p_project_where :p_struct_num :p_to_date 1 -60 :p_struct_num Number select chart_of_accounts_id from org_organization_definitions where organization_id = fnd_profile.value('mfg_organization_id') Y AR رقم هيكل مرن رقم هيكل مرن D FlexFeld-Struktur-Nummer FlexFeld-Struktur-Nummer E Número de Tipo de Estructura Número de Tipo de Estructura F Numéro structure flexible Numéro structure flexible I Numero struttura flexfield Numero struttura flexfield JA フレックス体系番号 フレックス体系番号 KO 가변 구조 번호 가변 구조 번호 PTB Número da Estrutura de Flexfield Número da Estrutura de Flexfield RU Номер структуры ГП Номер структуры ГП S Flexstrukturnummer Flexstrukturnummer TR Esnek Yapı Numarası Esnek Yapı Numarası US Flex Structure Number Flex Structure Number ZHS 弹性结构编号 弹性结构编号 2 -50 :p_currency_code LOV Oracle CST_SRS_CURRENCY_CODE Y select currency_code id, currency_code value, description description from fnd_currencies_vl where trunc(nvl(start_date_active,sysdate-1))<sysdate and trunc(nvl(end_date_active,sysdate+1))>sysdate order by value,description SELECT GL.CURRENCY_CODE FROM ORG_ORGANIZATION_DEFINITIONS OOD,GL_SETS_OF_BOOKS GL WHERE OOD.ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') AND GL.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID Y AR رمز العملة رمز العملة D Währungsschlüssel Währungsschlüssel E Código de Divisa Código de Divisa F Code devise Code devise I Codice divisa Codice divisa JA 通貨コード 通貨コード KO 통화 코드 통화 코드 PTB Cód. da Moeda Cód. da Moeda RU Код валюты Код валюты S Valutakod Valutakod TR Para Birimi Kodu Para Birimi Kodu US Currency Code Currency Code ZHS 币种代码 币种代码 3 -40 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR Org_Id معرف التنظيم D Org_Id Organisationskennung E Org_Id Id Organización F Org_Id ID organisation I Org_Id Id dell'organizzazione JA Org_Id 組織ID KO Org_Id 조직 ID PTB Org_Id Id da Organização RU Org_Id Идент. организ. S Org_Id Organisations-id TR Org_Id Organizasyon No US Org_Id Organization Id ZHS Org_Id 组织标识 4 -30 :p_cat_num Number SELECT STRUCTURE_ID FROM MTL_CATEGORY_SETS WHERE CATEGORY_SET_ID = :$flex$.category_set Y AR هيكل الفئة هيكل الفئة D Kategoriestruktur Kategoriestruktur E Estructura de Categoría Estructura de Categoría F Structure de catégorie Structure de catégorie I Struttura categoria Struttura categoria JA カテゴリ体系 カテゴリ体系 KO 범주 구조 범주 구조 PTB Estrutura da Categoria Estrutura da Categoria RU Структура категорий Структура категорий S Kategoristruktur Kategoristruktur TR Kategori Yapısı Kategori Yapısı US Category Structure Category Structure ZHS 类别结构 类别结构 5 -20 :p_project_dummy Number select organization_id from mtl_parameters where organization_id=:$flex$.org_id AND project_reference_enabled=1 and cost_group_accounting=1 US Project_Dummy Project_Dummy 6 10 :p_from_date Date AR التواريخ من من تاريخ D Datum von Datum von E De Fecha De Fecha F Dates - Du Date de début I Date - Da Data - Da JA 日付:自 日付:自 KO 일자: 부터 일자: 부터 PTB Datas - De Data - De RU Даты с Дата с S Från datum Från datum TR Tarihler, İlk Başlangıç Tarihi US Dates From Date From ZHS 日期自 日期自 7 20 :p_to_date Date AR إلى إلى D Bis Bis E A A F A A I A A JA 至 至 KO 까지 까지 PTB Até Até RU По По S Till Till TR Son Son US To To ZHS 至 至 8 30 :p_account Char AR الحساب الحساب D Konto Konto E Cuenta Cuenta F Compte Compte I Conto Conto JA 勘定科目 勘定科目 KO 계정 계정 PTB Conta Conta RU Счет Счет S Konto Konto TR Hesap Hesap US Account Account ZHS 帐户 帐户 9 40 :p_gl_batch_id LOV Oracle WIP_SRS_GL_BATCH_ID_OPT 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 Stapel E Lote Contable Lote Contable F Lot GL Lot GL I Batch GL Batch GL JA GLバッチ GLバッチ KO GL 뱃치 GL 뱃치 PTB Lote GL Lote GL RU Пакет ГК Пакет ГК S Huvudboksbunt Huvudboksbunt TR GL İşlem Grubu GL İşlem Grubu US GL Batch GL Batch ZHS GL 批 GL 批 10 50 :p_category_set LOV Oracle INV_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by value,description SELECT CATEGORY_SET_NAME FROM MTL_CATEGORY_SETS A, MTL_DEFAULT_CATEGORY_SETS B WHERE B.FUNCTIONAL_AREA_ID = 5 AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID Y AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet E Juego de Categorías Juego de Categorías F Jeu de catégories Jeu de catégories I Serie di categorie Serie di categorie JA カテゴリ・セット カテゴリ・セット KO 범주 세트 범주 세트 PTB Conj. Categorias Conj. Categorias RU Набор катег. Набор катег. S Kategoriuppsättning Kategoriuppsättning TR Kategori Kümesi Kategori Kümesi US Category Set Category Set ZHS 类别集 类别集 11 60 :p_cat_from Char AR الفئة من الفئة من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégorie - De Catégorie - De I Categoria - Da Categoria - Da JA カテゴリ:自 カテゴリ:自 KO 범주: 부터 범주: 부터 PTB Categoria - De Categoria - De RU Категория с Категория с S Från kategori Från kategori TR İlk Kategori İlk Kategori US Category From Category From ZHS 类别自 类别自 12 70 :p_cat_to Char AR الفئة إلى الفئة إلى D Bis Kategorie Bis Kategorie E A Categoría A Categoría F Catégorie - A Catégorie - A I Categoria - A Categoria - A JA カテゴリ:至 カテゴリ:至 KO 범주: 까지 범주: 까지 PTB Categoria - Até Categoria - Até RU Категория по Категория по S Till kategori Till kategori TR Son Kategori Son Kategori US Category To Category To ZHS 类别至 类别至 13 80 :p_project_id LOV Oracle CST_SRS_PROJECTID Y select project_id id, name value, segment1 description from pa_projects_all where project_id in( select ppp.project_id from pjm_project_parameters ppp where ppp.organization_id=:$flex$.project_dummy ) order by value,description AR معرف المشروع معرف المشروع D Projektkennung Projektkennung E Id Proyecto Id Proyecto F ID projet ID projet I Id progetto Id progetto JA プロジェクトID プロジェクトID KO 프로젝트 ID 프로젝트 ID PTB Id do Projeto Id do Projeto RU Идент. проекта Идент. проекта S Projekt-id Projekt-id TR Proje No Proje No US Project Id Project Id ZHS 项目标识 项目标识