ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FBB51A9E05362FB09050512 SELECT iim.item_number, iim.inventory_item_id, mp.organization_code, nvl(sum(moqd.primary_transaction_quantity), 0) primary_quantity, iim.primary_uom_code , nvl(sum(moqd.secondary_transaction_quantity),0) secondary_quantity, iim.secondary_uom_code , iim.description , sysdate transdate, haou.name organization_name, moqd.subinventory_code, msi.description subinv_description, mp.organization_id, iim.dual_uom_control, GMF_GMFINVAL_XMLP_PKG.unitcostcfformula(iim.inventory_item_id, mp.organization_id, sysdate) UNITCOSTCF, GMF_GMFINVAL_XMLP_PKG.TOTALCOSTCFFORMULA(nvl(sum(moqd.primary_transaction_quantity), 0)) TOTALCOSTCF, GMF_GMFINVAL_XMLP_PKG.TOTALCOSTCP_p TOTALCOSTCP, GMF_GMFINVAL_XMLP_PKG.UNITCOSTCP_p UNITCOSTCP FROM mtl_item_flexfields iim, mtl_parameters mp, mtl_onhand_quantities_detail moqd, hr_all_organization_units haou, hr_organization_information hoi, mtl_secondary_inventories msi, gmd_org_access_vw oa WHERE &Q1ORQ2 = '1' AND iim.inventory_item_id = moqd.inventory_item_id AND iim.organization_id = moqd.organization_id AND iim.organization_id = mp.organization_id AND hoi.org_information2 = TO_CHAR(:p_legal_entity_id) /* BUG 12970368 */ AND hoi.organization_id = mp.organization_id AND hoi.org_information_context = 'Accounting Information' AND haou.organization_id = hoi.organization_id AND haou.organization_id = mp.organization_id AND moqd.is_consigned = 2 AND msi.secondary_inventory_name = moqd.subinventory_code AND msi.organization_id = mp.organization_id AND iim.organization_id = oa.organization_id AND msi.asset_inventory = 1 /* B 8439947 Bug 12970368 */ &OrganizationCP &ItemCP GROUP BY iim.item_number, iim.inventory_item_id, mp.organization_code,iim.primary_uom_code, iim.secondary_uom_code,iim.description, sysdate, haou.name, moqd.subinventory_code, msi.description, mp.organization_id, iim.dual_uom_control UNION SELECT iim.item_number, iim.inventory_item_id, mp.organization_code, nvl(sum(gpb.primary_quantity), 0) primary_quantity, iim.primary_uom_code , nvl(sum(gpb.secondary_quantity),0) secondary_quantity, iim.secondary_uom_code , iim.description , /*Bug#12970368 oap.period_start_date transdate,*/ (oap.schedule_close_date + (86399/86400)) transdate, /* Bug#12970368*/ haou.name organization_name, gpb.subinventory_code, msi.description subinv_description, mp.organization_id, iim.dual_uom_control, GMF_GMFINVAL_XMLP_PKG.unitcostcfformula(iim.inventory_item_id, mp.organization_id, (oap.schedule_close_date + (86399/86400))) UNITCOSTCF, /*Bug#12970368*/ GMF_GMFINVAL_XMLP_PKG.TOTALCOSTCFFORMULA(nvl(sum(gpb.primary_quantity), 0)) TOTALCOSTCF, GMF_GMFINVAL_XMLP_PKG.TOTALCOSTCP_p TOTALCOSTCP, GMF_GMFINVAL_XMLP_PKG.UNITCOSTCP_p UNITCOSTCP FROM mtl_item_flexfields iim, mtl_parameters mp, gmf_period_balances gpb, org_acct_periods oap, hr_all_organization_units haou, hr_organization_information hoi, mtl_secondary_inventories msi, gmd_org_access_vw oa WHERE &Q1ORQ2 = '2' AND iim.inventory_item_id = gpb.inventory_item_id AND iim.organization_id = gpb.organization_id AND iim.organization_id = mp.organization_id AND mp.organization_id = gpb.organization_id AND hoi.org_information2 = TO_CHAR(:p_legal_entity_id) /* BUG 12970368 */ AND hoi.organization_id = mp.organization_id AND hoi.org_information_context = 'Accounting Information' AND haou.organization_id = hoi.organization_id AND haou.organization_id = mp.organization_id AND mp.organization_id = oap.organization_id AND gpb.acct_period_id = oap.acct_period_id AND oap.period_year = :p_period_year AND oap.period_num = :p_period_num AND gpb.subinventory_code (+)= msi.secondary_inventory_name AND mp.organization_id = msi.organization_id AND iim.organization_id = oa.organization_id AND msi.asset_inventory = 1 /* B 8439947 Bug 12970368 */ &OrganizationCP &ItemCP GROUP BY iim.item_number, iim.inventory_item_id, mp.organization_code, iim.primary_uom_code, iim.secondary_uom_code, iim.description, oap.schedule_close_date, haou.name, gpb.subinventory_code, msi.description, mp.organization_id, iim.dual_uom_control /* ORDER BY 3,1,11 ORDER BY 3 ASC,10 ASC,13 ASC,2 ASC,1 ASC,8 ASC,14 ASC,5 ASC,7 ASC , 3 , 1 , 11 bug #13638682 */ ORDER BY 3 ASC, 1 ASC, 11 ASC, 10 ASC,13 ASC,2 ASC,8 ASC,14 ASC,5 ASC,7 ASC Y GMF GMFINVAL_XML AR GMF تقرير تقييم المخزون (تنسيق XML) Imported from BI Publisher Description: تقرير تقييم المخزون Application: ماليات التصنيع التشغيلي Source: تقرير تقييم المخزون (تنسيق XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG D GMF Lagerbestandsbewertung Imported from BI Publisher Description: Auswertung "Lagerbestandsbewertung" Application: Process Manufacturing Financials Source: Lagerbestandsbewertung (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG E GMF Valoración de Inventario Imported from BI Publisher Description: Informe de valoración de inventario Application: Process Manufacturing Financials Source: Valoración de Inventario (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG F GMF Etat de valorisation du stock Imported from BI Publisher Description: Etat de valorisation du stock Application: Process Manufacturing Financials Source: Etat de valorisation du stock (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG I GMF Rapporto Valutazione scorte Imported from BI Publisher Description: Rapporto Valutazione magazzino Application: Process Manufacturing Financials Source: Rapporto Valutazione scorte (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG JA GMF 在庫評価レポート Imported from BI Publisher Description: 在庫評価レポート Application: Process Manufacturing Financials Source: 在庫評価レポート(XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG KO GMF 재고 평가 보고서 Imported from BI Publisher Description: 재고 평가 보고서 Application: Process Manufacturing Financials Source: 재고 평가 보고서(XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG PTB GMF Relatório de Avaliação do Inventário Imported from BI Publisher Description: Relatório de Avaliação do Inventário Application: Process Manufacturing Financials Source: Relatório de Avaliação do Inventário (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG RU GMF Отчет об оценке запасов Imported from BI Publisher Description: Отчет об оценке запасов Application: Финансы УНП Source: Отчет об оценке запасов (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG S GMF Lagervärdering - rapport Imported from BI Publisher Description: Lagervärdering - rapport Application: Processtillverkning: Ekonomi Source: Lagervärdering - rapport (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG TR GMF Envanter Değerleme Raporu Imported from BI Publisher Description: Envanter Değerleme Raporu Application: Üretim Prosesi Finansal Yönetim Source: Envanter Değerleme Raporu (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG US GMF Inventory Valuation Imported from BI Publisher Description: Inventory Valuation Report Application: Process Manufacturing Financials Source: Inventory Valuation Report (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG ZHS GMF 库存估价报表 Imported from BI Publisher Description: 库存估价报表 Application: OPM 财务管理系统 Source: 库存估价报表 (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG BI Publisher &itemcp &organizationcp &q1orq2 :balancecp :current_dummy :from_item_num :from_orgn_code :itemcp :lfrom_item_num :lfrom_orgn_code :lto_item_num :lto_orgn_code :nonblocksql :organizationcp :p_conc_request_id :p_currency_code :p_current :p_exchange_rate :p_from_item_id :p_from_organization_id :p_legal_entity_id :p_organization_context :p_period_num :p_period_year :p_to_item_id :p_to_organization_id :q1orq2 :sy_all :to_item_num :to_orgn_code :totalcostcp :unitcostcp 1 -50 :ledger Number select ledger_id from gmf_fiscal_policies where legal_entity_id = :$flex$.legal_entity AR P_LEDGER دفتر الأستاذ الافتراضي D P_LEDGER Dummy-Buch E P_LEDGER Libro mayor ficticio F P_LEDGER Livre fictif I P_LEDGER Libro contabile fittizio JA P_LEDGER ダミー元帳 KO P_LEDGER Dummy 원장 PTB P_LEDGER Razão Fictício RU P_LEDGER Фиктивная книга S P_LEDGER Dummy-bokföringsbok TR P_LEDGER Smzde Defter US P_LEDGER Dummy Ledger ZHS P_LEDGER 虚拟分类帐 2 -40 :nonblocksql LOV Oracle NONBLOCKSQL Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=108473 order by ffvv.flex_value NO AR Sql غير مدرج بالقطعة Sql غير مدرج بالقطعة E SQL No Bloqueante SQL No Bloqueante F SQL hors bloc SQL hors bloc JA 未ブロックSQL 未ブロックSQL KO 비블록 SQL 비블록 SQL PTB Sql de Não Bloqueio Sql de Não Bloqueio RU SQL без блоков SQL без блоков S Icke-blockerande SQL Icke-blockerande SQL TR Blok Dışı Sql Blok Dışı Sql US Non Block Sql Non Block Sql ZHS 非块结构 SQL 非块结构 SQL 3 -30 :sy_all Char fnd_profile.value('SY$ALL') US SY_ALL SY_ALL 4 -20 :p_organization_context Number fnd_profile.value('MFG_ORGANIZATION_ID') AR سياق التنظيم سياق التنظيم D Organisationskontext Organisationskontext E Contexto de Organización Contexto de Organización F Contexte de l'organisation Contexte de l'organisation I Contesto organizzazione Contesto dell'organizzazione JA 組織コンテキスト 組織コンテキスト KO 조직 컨텍스트 조직 컨텍스트 PTB Contexto da Organização Contexto da Organização RU Контекст организации Контекст организации S Organisationssammanhang Organisationssammanhang TR Organizasyon İçeriği Organizasyon İçeriği US Organization Context Organization Context ZHS 组织上下文 组织上下文 5 10 :p_legal_entity_id LOV Oracle GMF_SRS_LEGAL_ENTITY Y select legal_entity_id id, legal_entity_name value, null description from gmf_legal_entities where legal_entity_id in (select legal_entity_id from gmf_fiscal_policies) order by legal_entity_name Y AR الكيان القانوني الكيان القانوني D Mandant Mandant E Entidad Jurídica Entidad Jurídica F Entité juridique Entité juridique I Persona giuridica Persona giuridica JA 法的エンティティ 法的エンティティ KO 법인 법인 PTB Pessoa Jurídica Pessoa Jurídica RU Юридическое лицо Юридическое лицо S Juridisk enhet Juridisk enhet TR Tüzel Kişilik Tüzel Kişilik US Legal Entity Legal Entity ZHS 法人主体 法人主体 6 20 :p_from_organization_id LOV Oracle GMF_SRS_FROM_ORGANIZATION Y select ood.organization_id id, ood.organization_code value, ood.organization_name description from org_organization_definitions ood,mtl_parameters mp where ood.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and ood.legal_entity=:$flex$.gmf_srs_legal_entity order by value,description AR من التنظيم من التنظيم D Von Organisation Von Organisation E De Organización De Organización F Organisation d'origine Organisation d'origine I Organizzazione - Da Organizzazione - Da JA 組織:自 組織:自 KO 조직: 부터 조직: 부터 PTB Da Organização Da Organização RU Организация с Организация с S Från organisation Från organisation TR İlk Organizasyon İlk Organizasyon US From Organization From Organization ZHS 起始组织 起始组织 7 30 :p_to_organization_id LOV Oracle GMF_SRS_TO_ORGANIZATION Y select ood.organization_id id, ood.organization_code value, ood.organization_name description from org_organization_definitions ood,mtl_parameters mp where ood.organization_id=mp.organization_id and mp.process_enabled_flag='Y' and ood.legal_entity=:$flex$.gmf_srs_legal_entity and ood.organization_code>=:$flex$.gmf_srs_from_organization.value order by value,description AR إلى التنظيم إلى التنظيم D Nach Organisation Nach Organisation E A Organización A Organización F Organisation - A Organisation - A I Organizzazione - A Organizzazione - A JA 組織:至 組織:至 KO 조직: 까지 조직: 까지 PTB Organização - Até Organização - Até RU Организация по Организация по S Till organisation Till organisation TR Son Organizasyon Son Organizasyon US To Organization To Organization ZHS 目标组织 目标组织 8 40 :p_from_item_id Char AR من الصنف من الصنف D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR İlk Kalem İlk Kalem US From Item From Item ZHS 起始物料 起始物料 9 50 :p_to_item_id Char AR إلى الصنف إلى الصنف D Bis Artikel Bis Artikel E A Artículo A Artículo F Article - A Article - A I Articolo - A Articolo - A JA 品目:至 品目:至 KO 품목: 까지 품목: 까지 PTB Item - Até Item - Até RU Позиция по Позиция по S Till artikel Till artikel TR Son Kalem Son Kalem US To Item To Item ZHS 终止物料 终止物料 10 60 :current LOV Oracle GMF_YES_NO Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='YES_NO' order by meaning select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR الرصيد الحالي الرصيد الحالي D Aktueller Bestand Aktueller Bestand E Saldo Actual Saldo Actual F Solde en cours Solde en cours I Saldo corrente Saldo corrente JA 現在残高 現在残高 KO 현재 잔고 현재 잔고 PTB Saldo Atual Saldo Atual RU Текущий остаток Текущий остаток S Aktuellt saldo Aktuellt saldo TR Cari Bakiye Cari Bakiye US Current Balance Current Balance ZHS 当前余额 当前余额 11 70 :p_period_year LOV Oracle GMF_SRS_GL_PERIOD_YEARS Y select glp.period_year id, glp.period_year value, null description from gl_periods glp,gl_ledgers gll where :$flex$.gmf_yes_no.id='N' and gll.ledger_id=:$flex$.p_ledger and glp.period_set_name=gll.period_set_name and glp.period_type=gll.accounted_period_type and gll.accounted_period_type=glp.period_type and glp.period_num=(select min (p2.period_num) from gl_periods p2 where p2.period_set_name=gll.period_set_name and p2.period_type=gll.accounted_period_type and p2.period_year=glp.period_year) order by glp.period_year desc AR سنة الفترة سنة الفترة D Periode Jahr Periode Jahr E Año del Período Año del Período F Année de la période Année de la période I Anno periodo Anno periodo JA 期間年 期間年 KO 기간 년도 기간 년도 PTB Ano do Período Ano do Período RU Год периода Год периода S Periodår Periodår TR Dönem Yılı Dönem Yılı US Period Year Period Year ZHS 期间年度 期间年度 12 80 :p_period_num LOV Oracle GMF_SRS_GL_PERIOD_NUMBERS Y select glp.period_num id, glp.period_num value, null description from gl_periods glp,gl_period_statuses sts,gl_ledgers gll where gll.ledger_id=:$flex$.p_ledger and glp.period_set_name=gll.period_set_name and glp.period_type=gll.accounted_period_type and glp.period_year=:$flex$.gmf_srs_gl_period_years and glp.period_num=sts.period_num and glp.period_year=sts.period_year and sts.ledger_id=gll.ledger_id and sts.application_id=101 order by glp.period_num AR رقم الفترة رقم الفترة D Periodennummer Periodennummer E Número de Período Número de Período F Numéro de période Numéro de période I Numero periodo Numero periodo JA 期間番号 期間番号 KO 기간 번호 기간 번호 PTB Nr. do Período Nr. do Período RU Номер периода Номер периода S Periodnr Periodnr TR Dönem Numarası Dönem Numarası US Period Number Period Number ZHS 期间编号 期间编号 13 90 :p_currency_code LOV Oracle GMF_GL_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code SELECT base_currency_code FROM gmf_fiscal_policies where legal_entity_id = :$flex$.legal_entity AR عملة التقرير عملة التقرير D Auswertungswährung Auswertungswährung E Divisa del Informe Divisa del Informe F Devise de reporting Devise de reporting I Divisa rapporto Divisa rapporto JA レポート通貨 レポート通貨 KO 보고서 통화 보고서 통화 PTB Moeda do Relatório Moeda do Relatório RU Валюта отчета Валюта отчета S Rapportvaluta Rapportvaluta TR Rapor Para Birimi Rapor Para Birimi US Report Currency Report Currency ZHS 报表币种 报表币种 14 100 :p_exchange_rate Number 1.000000000000000 AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de Cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa de Câmbio RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz Kuru US Exchange Rate Exchange Rate ZHS 汇率 汇率 :$flex$.gmf_srs_from_organization.value From Organization To Organization value :$flex$.gmf_srs_gl_period_years Period Year Period Number :$flex$.gmf_srs_legal_entity Legal Entity From Organization :$flex$.gmf_srs_legal_entity Legal Entity To Organization :$flex$.gmf_yes_no.id Current Balance Period Year :$flex$.legal_entity Legal Entity P_LEDGER :$flex$.legal_entity Legal Entity Report Currency :$flex$.p_ledger P_LEDGER Period Number :$flex$.p_ledger P_LEDGER Period Year