ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B24CBF5AD89C6343E0530100007FDCC2 INV Organization Code (no access org restrictions and avoiding master and disabled orgs) Y select mp.organization_code value, haou.name description from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and hoi.organization_id = haou.organization_id and sysdate < nvl(haou.date_to, sysdate +1) and mp.organization_id <> mp.master_organization_id order by 1 US 8E2FF36EDF2279D2E0530100007F1FF2 INV Period Y select distinct oap.period_name value, max(oap.period_year||'-'||oap.period_num||', '||xxen_util.meaning(nvl2(oap.period_close_date,decode(oap.open_flag,'P',2,'N',decode(oap.summarized_flag,'N',65,66),4),3),'MTL_ACCT_PERIOD_STATUS',700)||' ('||oap.period_start_date||' - '||oap.schedule_close_date||')') over (partition by oap.period_name) description, max(oap.period_start_date) over (partition by oap.period_name) period_start_date, max(oap.effective_period_num) over (partition by oap.period_name) effective_period_num from gl_ledgers gl, org_organization_definitions ood, mtl_parameters mp, (select oap.period_year*10000+oap.period_num effective_period_num, oap.* from org_acct_periods oap) oap where oap.period_start_date<=sysdate and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') and ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and gl.period_set_name=oap.period_set_name and gl.ledger_id=ood.set_of_books_id and ood.organization_id=oap.organization_id order by period_start_date desc, effective_period_num desc, oap.period_name AR فترات دفتر الأستاذ العام السابقة للمخزون (تعتمد على دفتر الأستاذ و / أو معلمة رمز المؤسسة) للمؤسسات غير الرئيسية D Vergangene Bestands-GL-Perioden (abhängig von Ledger- und/oder Organisationscode-Parameter) für Nicht-Master-Organisationen E Períodos GL de inventario pasados (dependientes de los parámetros del libro mayor y/o del código de organización) para organizaciones no maestras F Périodes passées de GL d'inventaire (dépendant du grand livre et/ou du code d'organisation) pour les organisations non maîtresses I Periodi GL di inventario passati (dipendente dal parametro del ledger e/o del codice dell'organizzazione) per organizzazioni non master JA 非マスター組織の過去のインベントリGL期間（元帳および/または組織コードパラメータに依存する）。 KO 비 마스터 조직에 대한 과거 재고 GL 기간 (원장 및 / 또는 조직 코드 매개 변수에 따라 다름) PTB Períodos GL de inventário anteriores (ledger e/ou código de organização dependente do parâmetro) para organizações não-mestras RU Прошлые инвентаризационные GL-периоды (зависящие от бухгалтерской книги и/или параметра организационного кода) для неосновных организаций S Tidigare lager GL-perioder (storbok och / eller organisationskodparameter beroende) för icke-huvudorganisationer TR Ana olmayan kuruluşlar için geçmiş envanter GL dönemleri (genel muhasebe ve / veya kuruluş kodu parametresine bağlı) US Past inventory GL periods (ledger and/or organization code parameter dependent) for non master organizations ZHS 非主组织的过去库存GL期(分类账和/或组织代码参数而定) AD37153A4C90DEB6E053B46B6358A8FEY select distinct org_code, inv_org_name, item, item_description, on_hand_qty, uom, fifo_value, std_cost, fifo_value - std_cost fifo_diff from (select s.org_code, s.inv_org_name, msib.segment1 item, msib.description item_description, round(( case when s.transaction_quantity <= s.primary_quantity then s.transaction_quantity else s.primary_quantity end),4) on_hand_qty, msib.primary_uom_code uom, round(xxnuf_get_fifo_value(s.organization_id,s.inventory_item_id,( case when s.transaction_quantity <= s.primary_quantity then s.transaction_quantity else s.primary_quantity end)),4) fifo_value, round( case when s.transaction_quantity <= s.primary_quantity then s.transaction_quantity else s.primary_quantity end * xxnuf_mat_var_rep_pkg.get_std_cost (:period_name, 'NUF_CAL', s.organization_id, s.inventory_item_id, :cost_mthd_code), 4) std_cost from mtl_system_items_b msib, mtl_material_transactions mmt6, (select gpb.organization_id, gpb.inventory_item_id, ood.organization_code org_code, ood.organization_name inv_org_name, nvl(sum(gpb.primary_quantity),0) transaction_quantity, (select sum(mmt.primary_quantity) from mtl_material_transactions mmt where gpb.inventory_item_id =mmt.inventory_item_id and mmt.organization_id =gpb.organization_id and mmt.transaction_type_id in(18,61) ) primary_quantity from xle_entity_profiles xep, org_organization_definitions ood, mtl_parameters mp, gmf_period_balances gpb, org_acct_periods oap, cm_whse_asc cwa, cm_whse_src cws where 1=1 and xep.name =:legal_entity and xep.legal_entity_id=ood.legal_entity and ood.organization_id=mp.organization_id and nvl(mp.eam_enabled_flag,'N')='N' and ood.organization_id =gpb.organization_id and gpb.acct_period_id=oap.acct_period_id and oap.organization_id=gpb.organization_id and oap.period_name=:period_name and oap.period_start_date >= cwa.eff_start_date (+) and oap.period_start_date <= cwa.eff_end_date (+) and gpb.organization_id = cwa.organization_id (+) and gpb.inventory_item_id = cws.inventory_item_id (+) and gpb.organization_id = cws.organization_id (+) and exists (select 1 from mtl_material_transactions mmt1 where gpb.inventory_item_id =mmt1.inventory_item_id and mmt1.organization_id =gpb.organization_id and mmt1.transaction_type_id in(18,61) ) group by gpb.organization_id, gpb.inventory_item_id, ood.organization_code, ood.organization_name ) s where msib.inventory_item_id =s.inventory_item_id and msib.organization_id =s.organization_id and msib.inventory_item_id =mmt6.inventory_item_id and msib.organization_id =mmt6.organization_id and mmt6.transaction_type_id in(18,61) ) US GME FIFO Report 1=1 :cost_mthd_code :legal_entity :period_name 1 10 1=1 ood.organization_code=:organization_code LOV INV Organization Code (no access org restrictions and avoiding master and disabled orgs) B24CBF5AD89C6343E0530100007FDCC2 Y select mp.organization_code value, haou.name description from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and hoi.organization_id = haou.organization_id and sysdate < nvl(haou.date_to, sysdate +1) and mp.organization_id <> mp.master_organization_id order by 1 US Organization Code 2 20 :period_name LOV INV Period 8E2FF36EDF2279D2E0530100007F1FF2 Y select distinct oap.period_name value, max(oap.period_year||'-'||oap.period_num||', '||xxen_util.meaning(nvl2(oap.period_close_date,decode(oap.open_flag,'P',2,'N',decode(oap.summarized_flag,'N',65,66),4),3),'MTL_ACCT_PERIOD_STATUS',700)||' ('||oap.period_start_date||' - '||oap.schedule_close_date||')') over (partition by oap.period_name) description, max(oap.period_start_date) over (partition by oap.period_name) period_start_date, max(oap.effective_period_num) over (partition by oap.period_name) effective_period_num from gl_ledgers gl, org_organization_definitions ood, mtl_parameters mp, (select oap.period_year*10000+oap.period_num effective_period_num, oap.* from org_acct_periods oap) oap where oap.period_start_date<=sysdate and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') and ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and gl.period_set_name=oap.period_set_name and gl.ledger_id=ood.set_of_books_id and ood.organization_id=oap.organization_id order by period_start_date desc, effective_period_num desc, oap.period_name select distinct max(oap.period_name) keep (dense_rank last order by oap.period_year,oap.period_num) over (partition by oap.organization_id) period from mtl_parameters mp, org_acct_periods oap where regexp_like(:$flex$.organization_code,'(^|;)\s*'||xxen_util.regexp_escape(mp.organization_code)||'\s*(;|$)') and mp.organization_id=oap.organization_id and oap.open_flag='N' and oap.summarized_flag='Y' Y US Period 3 30 :legal_entity LOV custom Y select GLP.LEGAL_ENTITY_NAME value, null description from GMF_LEGAL_ENTITIES GLP,GMF_FISCAL_POLICIES GFP WHERE GLP.LEGAL_ENTITY_ID=GFP.LEGAL_ENTITY_ID ORDER BY GLP.LEGAL_ENTITY_NAME SELECT legal_entity_name VALUE,NULL MEANING FROM GL_SUBR_STA WHERE REFERENCE_NO =:$FLEX$.Reference_No Y US Legal Entity 4 40 :cost_mthd_code LOV custom Y select cmm.cost_mthd_code value, cmm.cost_mthd_desc description from cm_mthd_mst cmm order by cmm.cost_mthd_code Y US Cost Method