ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB879D2E0530100007F1FF2 GL Ledger Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name AR دفاتر الأستاذ المقيدة بمجموعة الوصول ، المحددة بواسطة قيمة الملف الشخصي "مجموعة الوصول إلى بيانات GL" لمسؤولية تسجيل الدخول الحالية D Ledger, die durch das Zugriffsset eingeschränkt sind, definiert durch den Profilwert 'GL Data Access Set' der aktuellen Anmeldeverantwortung E Libros restringidos por el conjunto de acceso, definido por el valor del perfil "Conjunto de acceso a datos GL" de la responsabilidad de inicio de sesión actual F Grands livres limités par un ensemble d'accès, défini par la valeur du profil "GL Data Access Set" de la responsabilité de connexion actuelle I Libri mastri limitati dal set di accesso, definito dal valore del profilo 'GL Data Access Set' della responsabilità di login corrente JA 現在のログイン責任者のプロファイル値'GL Data Access Set'によって定義されたアクセスセットによって制限された元帳 KO 현재 로그인 권한의 프로파일 값 'GL 데이터 액세스 세트'로 정의 된 액세스 세트로 제한되는 원장 PTB Ledgers restritos pelo conjunto de acesso, definido pelo valor do perfil 'GL Data Access Set' da atual responsabilidade de login RU Леджеры, ограниченные набором доступа, определяемые значением профиля "GL Data Access Set" текущей ответственности за вход в систему S Ledgers begränsade av åtkomstuppsättning, definierade av profilvärde 'GL Data Access Set' för det aktuella inloggningsansvaret TR Mevcut oturum açma sorumluluğunun profil değeri 'GL Veri Erişim Kümesi' ile tanımlanan erişim kümesiyle kısıtlanmış defterler US Ledgers restricted by access set, defined by profile value 'GL Data Access Set' of the current login responsibility ZHS 由访问集限制的分类账，由当前登录责任的配置文件值 "GL数据访问集 "定义。 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 41D6D8E6DBA7CFA3E06362FB090507E0 select gsob.name ledger, haou.name operating_unit, x.organization_code, null test, x.item, x.item_description, x.category, x.user_item_type, x.uom, x.item_status, x.inventory_asset, x.costing_enabled, x.make_buy, x.planning_method, x.revision, x.subinventory, x.subinventory_desc, x.asset_subinventory, ccg.cost_group, x.quantity_type, x.total_qty, -- x.item_unit_cost, -- x.total_cost, x.material_cost, x.material_overhead_cost, x.resource_cost, x.outside_processing_cost, x.overhead_cost, -- x.onhand_qty, x.onhand_cost, x.intransit_qty, x.intransit_cost, x.receiving_qty, x.receiving_cost, -- -- x.item|| ' - ' || x.item_description item_label, x.subinventory || ' - ' || x.subinventory_desc subinventory_label, ood.organization_code || ' - ' || ood.organization_name organization_label, sysdate report_run_date from ( select mp.organization_id, mp.organization_code, msi.concatenated_segments item, msi.description item_description, mc.concatenated_segments category, xxen_util.meaning(msi.item_type,'ITEM_TYPE',3) user_item_type, msi.primary_uom_code uom, msi.inventory_item_status_code item_status, xxen_util.meaning(cict.inventory_asset_flag,'SYS_YES_NO',700) inventory_asset, xxen_util.meaning(msi.costing_enabled_flag,'YES_NO',0) costing_enabled, xxen_util.meaning(msi.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_buy, decode(msi.inventory_planning_code,6, xxen_util.meaning(nvl(msi.mrp_planning_code,6),'MRP_PLANNING_CODE',700), xxen_util.meaning(nvl(msi.inventory_planning_code,6),'MTL_MATERIAL_PLANNING',700)) planning_method, decode(:p_item_revision, 1, ciqt.revision, null) revision, ciqt.subinventory_code subinventory, sec.description subinventory_desc, xxen_util.meaning(sec.asset_inventory,'SYS_YES_NO',700) asset_subinventory, coalesce(ciqt.cost_group_id,cict.cost_group_id,mp.default_cost_group_id) cost_group_id, case when ciqt.qty_source in (3,4,5) then 'Onhand' when ciqt.qty_source in (6,7,8) then 'Intransit' else 'Receiving' end quantity_type, round(sum(nvl(ciqt.rollback_qty,0)),:p_qty_precision) total_qty, -- round(nvl(cict.item_cost,0)*:p_exchange_rate, :p_ext_precision) item_unit_cost, -- sum(ciqt.rollback_qty * nvl(cict.item_cost,0) * case when ciqt.qty_source in (3,4,5) then decode(sec.asset_inventory,2,0,1) else 1 end * :p_exchange_rate) total_cost, sum(ciqt.rollback_qty * nvl(cict.material_cost,0) * case when ciqt.qty_source in (3,4,5) then decode(sec.asset_inventory,2,0,1) else 1 end * :p_exchange_rate) material_cost, sum(ciqt.rollback_qty * nvl(cict.material_overhead_cost,0) * case when ciqt.qty_source in (3,4,5) then decode(sec.asset_inventory,2,0,1) else 1 end * :p_exchange_rate) material_overhead_cost, sum(ciqt.rollback_qty * nvl(cict.resource_cost,0) * case when ciqt.qty_source in (3,4,5) then decode(sec.asset_inventory,2,0,1) else 1 end * :p_exchange_rate) resource_cost, sum(ciqt.rollback_qty * nvl(cict.outside_processing_cost,0) * case when ciqt.qty_source in (3,4,5) then decode(sec.asset_inventory,2,0,1) else 1 end * :p_exchange_rate) outside_processing_cost, sum(ciqt.rollback_qty * nvl(cict.overhead_cost,0) * case when ciqt.qty_source in (3,4,5) then decode(sec.asset_inventory,2,0,1) else 1 end * :p_exchange_rate) overhead_cost, -- round(sum(case when ciqt.qty_source in (3,4,5) then nvl(ciqt.rollback_qty,0) else null end),:p_qty_precision) onhand_qty, sum(case when ciqt.qty_source in (3,4,5) then nvl(ciqt.rollback_qty,0) else null end * nvl(cict.item_cost,0) * decode(sec.asset_inventory,2,0,1) * :p_exchange_rate) onhand_cost, round(sum(case when ciqt.qty_source in (6,7,8) then nvl(ciqt.rollback_qty,0) else null end),:p_qty_precision) intransit_qty, sum(case when ciqt.qty_source in (6,7,8) then nvl(ciqt.rollback_qty,0) else null end * nvl(cict.item_cost,0) * :p_exchange_rate) intransit_cost, round(sum(case when ciqt.qty_source in (9,10) then nvl(ciqt.rollback_qty,0) else null end),:p_qty_precision) receiving_qty, sum(case when ciqt.qty_source in (9,10) then nvl(ciqt.rollback_qty,0) else null end * nvl(cict.item_cost,0) * :p_exchange_rate) receiving_cost from cst_inv_qty_temp ciqt, cst_inv_cost_temp cict, mtl_parameters mp, mtl_secondary_inventories sec, mtl_system_items_vl msi, mtl_categories_b_kfv mc where ciqt.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id ) and -- cict.organization_id (+) = ciqt.organization_id and cict.inventory_item_id (+) = ciqt.inventory_item_id and -- mp.organization_id = ciqt.organization_id and -- sec.organization_id(+) = ciqt.organization_id and sec.secondary_inventory_name(+) = ciqt.subinventory_code and -- msi.organization_id = ciqt.organization_id and msi.inventory_item_id = ciqt.inventory_item_id and -- mc.category_id = ciqt.category_id and -- ( -- Q1 ( ciqt.qty_source in (3,4,5) and cict.cost_source in (1,2) and ( mp.primary_cost_method = 1 or cict.cost_group_id = ciqt.cost_group_id) ) or -- Q2/Q3 ( ciqt.qty_source in (6,7,8) and cict.cost_source in (1,2) and ( (mp.primary_cost_method <> 1 and cict.cost_group_id = ciqt.cost_group_id) or mp.primary_cost_method = 1 ) ) or -- Q4 ( ciqt.qty_source in (9,10) and cict.cost_source in (3,4) and cict.rcv_transaction_id = ciqt.rcv_transaction_id ) or -- Non Costed ( :p_cost_enabled_only = '2' and nvl(msi.costing_enabled_flag,'N') = 'N' ) ) group by mp.organization_id, mp.organization_code, msi.concatenated_segments, msi.description, mc.concatenated_segments, xxen_util.meaning(msi.item_type,'ITEM_TYPE',3), msi.primary_uom_code, msi.inventory_item_status_code, cict.inventory_asset_flag, xxen_util.meaning(msi.costing_enabled_flag,'YES_NO',0), msi.planning_make_buy_code, decode(msi.inventory_planning_code,6, xxen_util.meaning(nvl(msi.mrp_planning_code,6),'MRP_PLANNING_CODE',700), xxen_util.meaning(nvl(msi.inventory_planning_code,6),'MTL_MATERIAL_PLANNING',700)), decode(:p_item_revision, 1, ciqt.revision, null), ciqt.subinventory_code, coalesce(ciqt.cost_group_id,cict.cost_group_id,mp.default_cost_group_id), case when ciqt.qty_source in (3,4,5) then 'Onhand' when ciqt.qty_source in (6,7,8) then 'Intransit' else 'Receiving' end, sec.description, sec.asset_inventory, round(nvl(cict.item_cost,0) * :p_exchange_rate, :p_ext_precision) having decode(:p_neg_qty,1,1,2) = decode(:p_neg_qty,1,decode(sign(sum(ciqt.rollback_qty)),'-1',1,2),2) and decode(:p_zero_qty,2,round(sum(nvl(ciqt.rollback_qty,0)),:p_qty_precision),1) <> 0 ) x, org_organization_definitions ood, hr_all_organization_units haou, gl_sets_of_books gsob, cst_cost_groups ccg where 1=1 and x.organization_id = ood.organization_id and ood.operating_unit = haou.organization_id and ood.set_of_books_id = gsob.set_of_books_id and x.cost_group_id = ccg.cost_group_id (+) order by x.organization_code, x.subinventory, x.item, x.revision Y D356F4B6A3800CE2E0530100007F8E5F XXEN_INV_VALUE US XXFJ CST Inventory Value - Multi-Organization (Item Costs) Report: CST Inventory Value - Multi-Organization (Item Costs) Description: The Inventory Value Report can be used to report Inventory Value by - Elemental Item Cost level - Quantity Type (Onhand, Intransit, Receiving) The report can be used to analyze inventory value by Ledger, Operating Unit, Organization, Subinventory, Item Category, Cost Group The report corresponds to the following standard Oracle Reports - Elemental Inventory Value Report - All Inventories Value Report The report can be run across multiple Inventory Organizations Templates are provided that match the existing standard Oracle Reports of the same name: - All Inventories Value - All Inventories Value by Cost Group - Elemental Inventory Value - Elemental Inventory Value by Subinventory - Elemental Inventory Value by Cost Group DB package: XXEN_INV_VALUE Notes: To run the report including non-costed items the As of Date parameter must be left blank (current date). The report cannot be run historically when including non-costed items due to a bug in the Oracle API uses to populate the interminm costing tables used by the report. The API will error with the following error, however the report will complete but return no data: ORA-01403: no data found in Package CST_Inventory_PVT Procedure Calculate_InventoryCost 1=1 :p_api_mode :p_as_of_date :p_cat_from :p_cat_num :p_cat_set_name :p_cat_to :p_category_set :p_conc_request_id :p_cost_enabled_only :p_cost_group_from :p_cost_group_to :p_cost_type :p_cost_type_id :p_currency_code :p_currency_dsp :p_detail :p_exchange_rate :p_exchange_rate_char :p_exp_item :p_exp_sub :p_ext_precision :p_gl_num :p_intransit_value :p_inverse_rate :p_item_from :p_item_revision :p_item_to :p_ledger_id :p_neg_qty :p_one_time :p_onhand_value :p_org_id :p_ou_id :p_own :p_period_end :p_precision :p_qty_precision :p_rate_type :p_receipt :p_receiving_value :p_round_unit :p_rpt_option :p_sessionid :p_shipment :p_sort_option :p_subinv_from :p_subinv_to :p_uncosted_txn :p_view_cost :p_zero_cost :p_zero_qty 1 -70 :p_report_code Char INV_VALUE US Report Code 2 -60 :p_gl_num Number fnd_profile.value('MFG_CHART_OF_ACCOUNTS_ID') AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung F Plan comptable Id ID plan de comptes I Id piano dei conti Id del piano dei conti US Chart of Accounts Id ZHS 科目表标识 科目表标识 3 -50 :p_cat_num Number select mcs.structure_id from mtl_category_sets mcs where mcs.category_set_id=:$flex$.category_set AR هيكل الفئة هيكل الفئة D Kategoriestruktur Kategoriestruktur F Structure de la catégorie Structure de catégorie I Struttura categoria Struttura categoria US Category Structure ZHS 类别结构 类别结构 4 -40 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') US CST_SRS_INVERSE_RATE 5 -30 :p_rate_type Number 2 US CST_SRS_RATE_TYPE 6 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen F Quantité Précision Précision des quantités I Precisione quantità Precisione quantità US Quantity Precision ZHS 数量精确度 数量精确度 7 -10 :p_view_cost Number fnd_profile.value('CST_VIEW_COSTS') AR امتياز عرض التكاليف امتياز عرض التكاليف D Berechtigung für Kosten anzeigen Berechtigung für Kosten anzeigen F Voir le privilège des coûts Voir privilège coût I Visualizza privilegio costi Visualizza privilegio costi US View Cost Privilege ZHS 查看成本权限 查看成本权限 8 5 :p_api_mode LOV custom Y select x.value, x.description from ( select 'All' value, 'Onhand, Intransit, and Receiving Quantities/Values' description from dual union select 'Onhand' value, 'Onhand Quantities/Values' description from dual union select 'Onhand and Intransit' value, 'Onhand and Intransit Quantities/Values' description from dual union select 'Intransit' value, 'Intransit Quantities/Values' description from dual union select 'Receiving' value, 'Receiving Quantities/Values' description from dual ) x order by x.value All Y F Mode API US Quantity Type 9 10 1=1 gsob.name=:p_ledger_name LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) F Grand livre US Ledger 10 20 1=1 haou.name=:p_ou_name LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) F Unité d'exploitation US Operating Unit 11 30 1=1 ood.organization_code=:p_org_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') AR معرف التنظيم معرف التنظيم D Organisationskennung Organisationskennung F Code de l'organisation ID organisation I Id organizzazione Id dell'organizzazione US Organization Code ZHS 组织标识 组织标识 12 40 :p_cost_type LOV custom Y select distinct cct.cost_type value, cct.description description from cst_cost_types cct where nvl(cct.disable_date,sysdate+1)>sysdate and ( (cct.cost_type_id not in (1,2,5,6)) or exists ( select null from mtl_parameters mp, org_organization_definitions ood where mp.organization_id = ood.organization_id and ( (:$flex$.ledger is not null and ood.set_of_books_id in (select gsob.set_of_books_id from gl_sets_of_books gsob where gsob.name = :$flex$.ledger) ) or (:$flex$.ledger is null and ood.operating_unit in (select hou.organization_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') ) or (:$flex$.ledger is null and :$flex$.operating_unit is null and xxen_util.contains(:$flex$.organization_code,ood.organization_code) = 'Y' ) or (:$flex$.ledger is null and :$flex$.operating_unit is null and :$flex$.organization_code is null and ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') ) ) and mp.primary_cost_method = cct.cost_type_id and mp.organization_id = nvl(cct.organization_id,mp.organization_id) ) ) order by cct.cost_type select cct.cost_type from cst_cost_types cct where cct.cost_type_id = ( select min(mp.primary_cost_method) from mtl_parameters mp, org_organization_definitions ood where mp.organization_id = ood.organization_id and ( (:$flex$.ledger is not null and ood.set_of_books_id in (select gsob.set_of_books_id from gl_sets_of_books gsob where gsob.name = :$flex$.ledger) ) or (:$flex$.ledger is null and ood.operating_unit in (select hou.organization_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') ) or (:$flex$.ledger is null and :$flex$.operating_unit is null and xxen_util.contains(:$flex$.organization_code,ood.organization_code) = 'Y' ) or (:$flex$.ledger is null and :$flex$.operating_unit is null and :$flex$.organization_code is null and ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') ) ) and mp.primary_cost_method not in (2,5,6) ) AR نوع التكلفة نوع التكلفة D Kostentyp Kostentyp F Type de coût Type de coût I Tipo di costo Tipo di costo US Cost Type Cost Type ZHS 成本类型 成本类型 13 50 :p_as_of_date DateTime sysdate AR اعتبارًا من تاريخ اعتبارًا من تاريخ D Vom Vom F En date du En date du I In data In data US As of Date As of Date ZHS 截止日期 截止日期 14 55 :p_cost_enabled_only LOV custom Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' and (lookup_code = 1 or :$flex$.as_of_date is null) order by value,description 1 Y US Costing Enabled Items Only Costing Enabled Items Only. To include uncosted items, the As of Date must be left blank (current date). The report cannot be run historically for uncosted items. 15 60 :p_item_from Char AR الصنف من الصنف من D Von Artikel Von Artikel F Article de Article - De I Articolo - Da Articolo - Da US Item From Item from ZHS 物料自 物料自 16 70 :p_item_to Char AR الصنف إلى الصنف إلى D Bis Artikel Bis Artikel F Objet à Article - A I Articolo - A Articolo - A US Item To Item to ZHS 物料至 物料至 17 80 :p_category_set LOV Oracle CST_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets where mult_item_cat_assign_flag='N' order by value,description select mdcs.category_set_id from mtl_default_category_sets mdcs where mdcs.functional_area_id=5 Y AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet F Ensemble de la catégorie Jeu de catégories I Serie categorie Serie di categorie US Category Set Category set ZHS 类别集 类别集 18 90 :p_cat_from Char AR الفئة من الفئة من D Von Kategorie Von Kategorie F Catégorie de Catégorie - De I Categoria - Da Categoria - Da US Category From Category From ZHS 类别自 类别自 19 100 :p_cat_to Char AR الفئة إلى الفئة إلى D Bis Kategorie Bis Kategorie F Catégorie à Catégorie - A I Categoria - A Categoria - A US Category To Category To ZHS 类别至 类别至 20 110 :p_subinv_from LOV custom Y select distinct msi.secondary_inventory_name value, null description from mtl_secondary_inventories msi where msi.organization_id in ( select ood.organization_id from org_organization_definitions ood where ( (:$flex$.organization_code is null and :$flex$.operating_unit is null and ood.set_of_books_id in (select gsob.set_of_books_id from gl_sets_of_books gsob where gsob.name = :$flex$.ledger) ) or (:$flex$.organization_code is null and ood.operating_unit in (select hou.organization_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') ) or (xxen_util.contains(:$flex$.organization_code,ood.organization_code) = 'Y' ) or (:$flex$.ledger is null and :$flex$.operating_unit is null and :$flex$.organization_code is null and ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') ) ) ) order by msi.secondary_inventory_name AR مخزن من مخزن من D Von Lager Von Lager F Sous-inventaire De Magasin - De I Sottomagazzino - Da Sottomagazzino - Da US Subinventory From Subinventory From ZHS 子库存自 子库存自 21 120 :p_subinv_to LOV custom Y select distinct msi.secondary_inventory_name value, null description from mtl_secondary_inventories msi where msi.organization_id in ( select ood.organization_id from org_organization_definitions ood where ( (:$flex$.organization_code is null and :$flex$.operating_unit is null and ood.set_of_books_id in (select gsob.set_of_books_id from gl_sets_of_books gsob where gsob.name = :$flex$.ledger) ) or (:$flex$.organization_code is null and ood.operating_unit in (select hou.organization_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') ) or (xxen_util.contains(:$flex$.organization_code,ood.organization_code) = 'Y' ) or (:$flex$.ledger is null and :$flex$.operating_unit is null and :$flex$.organization_code is null and ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') ) ) ) order by msi.secondary_inventory_name AR مخزن إلى مخزن إلى D Bis Lager Bis Lager F Magasin - A Magasin - A I Sottomagazzino - A Sottomagazzino - A US Subinventory To Subinventory To ZHS 子库存至 子库存至 22 130 :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 gsob.currency_code from gl_sets_of_books gsob where ( (:$flex$.ledger is not null and gsob.name = :$flex$.ledger ) or (:$flex$.ledger is null and gsob.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') ) or (:$flex$.ledger is null and :$flex$.operating_unit is null and gsob.set_of_books_id in (select ood.set_of_books_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code) = 'Y') ) or (:$flex$.ledger is null and :$flex$.operating_unit is null and :$flex$.organization_code is null and gsob.set_of_books_id in (select ood.set_of_books_id from org_organization_definitions ood where ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID')) ) ) and rownum=1 Y AR العملة العملة D Währung Währung F Monnaie Devise I Divisa Divisa US Currency Currency ZHS 币种 币种 23 140 :p_exchange_rate_char LOV Oracle CST_SRS_EXCHANGE_RATE_C Y select actual_rate id, display_rate value, period description from cst_gl_translation_view where org_id=fnd_profile.value('MFG_ORGANIZATION_ID') and code=:$flex$.cst_srs_currency_code and inverse=:$flex$.cst_srs_inverse_rate and rate_type=:$flex$.cst_srs_rate_type order by period_year desc,period_num desc Y AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs F Taux de change Taux de change I Tasso di cambio Tasso di cambio US Exchange Rate Exchange Rate ZHS 汇率 汇率 24 150 :p_item_revision LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR الكميات بواسطة المراجعة الكميات بواسطة المراجعة D Mengen nach Version Mengen nach Version F Quantités par révision Quantités par version I Quantità per revisione Quantità per revisione US Quantities By Revision Quantities by Revision ZHS 按版本显示数量 按版本列出的数量 25 160 :p_neg_qty LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR الكميات السالبة فقط الكميات السالبة فقط D Nur negative Mengen Nur negative Mengen F Quantités négatives uniquement Quantités négatives seulement I Solo quantità negative Solo quantità negative US Negative Quantities only Negative Quantities Only ZHS 仅限于负数量 仅限于负数量 26 170 :p_zero_cost LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR عرض التكاليف الصفرية فقط عرض التكلفة الصفرية فقط D Nur Nullkosten anzeigen Nur Nullkosten anzeigen F Afficher uniquement les coûts zéro Afficher coût zéro seulement I Visualizza solo costi zero Visualizza solo costi zero US Display Zero Costs only Display zero cost only ZHS 仅显示零成本 仅显示零成本 27 180 :p_exp_item LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR تضمين بنود المصروفات تضمين بنود المصروفات D Mit Aufwandsartikeln Mit Aufwandsartikeln F Inclure les postes de dépenses Inclure les articles passés en charges I Includi articoli di spesa Includi articoli di spesa US Include Expense Items Include expense items ZHS 包括低值易耗品 包括低值易耗品 28 190 :p_exp_sub LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR تضمين مصروفات المخازن تضمين مصروفات المخازن D Mit Aufwandslägern Mit Aufwandslägern F Inclure les dépenses des sous-inventaires Inclure les magasins passés en charge I Includi sottomagazzini di spesa Include i sottomagazzini di spesa US Include Expense Subinventories Include expense subinventories ZHS 包括费用子库存 包括费用子库存 29 200 :p_zero_qty LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR تضمين الكميات الصفرية عرض الكميات الصفرية D Mit Nullmengen Mit Nullmengen F Inclure les quantités nulles Afficher les quantités zéro I Includi quantità zero Visualizza quantità zero US Include Zero Quantities Display zero quantities ZHS 包括零数量 显示零数量 30 210 :p_uncosted_txn LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description 2 Y AR تضمين حركات بدون قيم تضمين حركات بدون قيم D Mit nicht bewerteten Transaktionen Mit nicht bewerteten Transaktionen F Inclure les transactions non évaluées Inclure mouvements non valorisés I Includi transazioni non valorizzate Include le transazioni non valorizzate US Include Unvalued Transactions Include Unvalued Transactions ZHS 包括未估计值的事务处理 包括未估计值的事务处理 :$flex$.as_of_date As of Date Y Costing Enabled Items Only :$flex$.category_set Category Set Category Structure :$flex$.cst_srs_currency_code Currency Exchange Rate :$flex$.cst_srs_inverse_rate CST_SRS_INVERSE_RATE Exchange Rate :$flex$.cst_srs_rate_type CST_SRS_RATE_TYPE Exchange Rate :$flex$.ledger Ledger Cost Type :$flex$.ledger Ledger Currency :$flex$.ledger Ledger Operating Unit :$flex$.ledger Ledger Organization Code :$flex$.ledger Ledger Subinventory From :$flex$.ledger Ledger Subinventory To :$flex$.operating_unit Operating Unit Cost Type :$flex$.operating_unit Operating Unit Currency :$flex$.operating_unit Operating Unit Organization Code :$flex$.operating_unit Operating Unit Subinventory From :$flex$.operating_unit Operating Unit Subinventory To :$flex$.organization_code Organization Code Cost Type :$flex$.organization_code Organization Code Currency :$flex$.organization_code Organization Code Subinventory From :$flex$.organization_code Organization Code Subinventory To