ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3A356E1EAD00AEE6E06362FB0905B9E1Y 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 GMF GMFINVAL_XML AR GMF تقرير تقييم المخزون (تنسيق XML) (3) Imported from BI Publisher Description: تقرير تقييم المخزون Application: ماليات التصنيع التشغيلي Source: تقرير تقييم المخزون (تنسيق XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG D GMF Lagerbestandsbewertung (3) 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 (3) 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 (3) 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 (3) 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 在庫評価レポート (3) Imported from BI Publisher Description: 在庫評価レポート Application: Process Manufacturing Financials Source: 在庫評価レポート(XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG KO GMF 재고 평가 보고서 (3) 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 (3) 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 Отчет об оценке запасов (3) Imported from BI Publisher Description: Отчет об оценке запасов Application: Финансы УНП Source: Отчет об оценке запасов (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG S GMF Lagervärdering - rapport (3) 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 (3) 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 (3) 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 库存估价报表 (3) Imported from BI Publisher Description: 库存估价报表 Application: OPM 财务管理系统 Source: 库存估价报表 (XML) Short Name: GMFINVAL_XML DB package: GMF_GMFINVAL_XMLP_PKG BI Publisher 1=1 :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 US P_LEDGER Dummy 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 US Non Block Sql Non Block 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') US Organization Context Organization Context 5 -10 :debugflag Char N US DebugFlag Debug Flag 6 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 US Legal Entity Legal Entity 7 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 US From Organization From Organization 8 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 US To Organization To Organization 9 40 :p_from_item_id Char US From Item From Item 10 50 :p_to_item_id Char US To Item To Item 11 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 US Current Balance Current Balance 12 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 US Period Year Period Year 13 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 US Period Number Period Number 14 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 US Report Currency Report Currency 15 100 :p_exchange_rate Number 1.000000000000000 US Exchange Rate Exchange Rate