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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 D0415A9FC1910DE9E0530100007F1551 select gsob.name ledger, haou.name operating_unit, mp.organization_code, msi.concatenated_segments item, msi.description item_description, decode(:p_item_revision, 1, ciqt.revision, null) revision, 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.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, ciqt.subinventory_code subinventory, sec.description subinventory_description, xxen_util.meaning(sec.asset_inventory,'SYS_YES_NO',700) asset_subinventory, decode(ciqt.subinventory_code,null,'Intransit','On-hand') type, ccg.cost_group, -- nvl(:p_currency_code,gsob.currency_code) currency, :p_exchange_rate exchange_rate, round(nvl(cict.item_cost,0)*:p_exchange_rate, :p_ext_precision) item_unit_cost, -- round(sum(nvl(ciqt.rollback_qty,0)),:p_qty_precision) element_qty, -- case rowgen.column_value when 1 then gcc1.concatenated_segments when 2 then gcc2.concatenated_segments when 3 then gcc3.concatenated_segments when 4 then gcc4.concatenated_segments when 5 then gcc5.concatenated_segments end account, case rowgen.column_value when 1 then 'Material' when 2 then 'Material Overhead' when 3 then 'Resource' when 4 then 'Outside Processing' when 5 then 'Overhead' end cost_element, -- round(case rowgen.column_value when 1 then sum(ciqt.rollback_qty * decode(nvl(sec.asset_inventory,1),1,1,0) * nvl(cict.material_cost,0)) when 2 then sum(ciqt.rollback_qty * decode(nvl(sec.asset_inventory,1),1,1,0) * nvl(cict.material_overhead_cost,0)) when 3 then sum(ciqt.rollback_qty * decode(nvl(sec.asset_inventory,1),1,1,0) * nvl(cict.resource_cost,0)) when 4 then sum(ciqt.rollback_qty * decode(nvl(sec.asset_inventory,1),1,1,0) * nvl(cict.outside_processing_cost,0)) when 5 then sum(ciqt.rollback_qty * decode(nvl(sec.asset_inventory,1),1,1,0) * nvl(cict.overhead_cost,0)) end * :p_exchange_rate / xxen_util.zero_to_null(sum(nvl(ciqt.rollback_qty,0))) , :p_ext_precision) element_unit_cost, case rowgen.column_value when 1 then sum(ciqt.rollback_qty * decode(nvl(sec.asset_inventory,1),1,1,0) * nvl(cict.material_cost,0)) when 2 then sum(ciqt.rollback_qty * decode(nvl(sec.asset_inventory,1),1,1,0) * nvl(cict.material_overhead_cost,0)) when 3 then sum(ciqt.rollback_qty * decode(nvl(sec.asset_inventory,1),1,1,0) * nvl(cict.resource_cost,0)) when 4 then sum(ciqt.rollback_qty * decode(nvl(sec.asset_inventory,1),1,1,0) * nvl(cict.outside_processing_cost,0)) when 5 then sum(ciqt.rollback_qty * decode(nvl(sec.asset_inventory,1),1,1,0) * nvl(cict.overhead_cost,0)) end * :p_exchange_rate element_extended_value, -- msi.concatenated_segments || ' - ' || msi.description item_label, ciqt.subinventory_code || ' - ' || sec.description subinventory_label, mp.organization_code || ' - ' || ood.organization_name organization_label, case rowgen.column_value when 1 then 'Material (' || gcc1.concatenated_segments || ')' when 2 then 'Material Overhead (' || gcc2.concatenated_segments || ')' when 3 then 'Resource (' || gcc3.concatenated_segments || ')' when 4 then 'Outside Processing (' || gcc4.concatenated_segments || ')' when 5 then 'Overhead (' || gcc5.concatenated_segments || ')' end cost_element_label from mtl_categories_b_kfv mc, mtl_system_items_vl msi, mtl_secondary_inventories sec, cst_inv_qty_temp ciqt, cst_inv_cost_temp cict, cst_item_costs cic, cst_cost_groups ccg, mtl_parameters mp, org_organization_definitions ood, hr_all_organization_units haou, gl_sets_of_books gsob, -- gl_code_combinations_kfv gcc1, gl_code_combinations_kfv gcc2, gl_code_combinations_kfv gcc3, gl_code_combinations_kfv gcc4, gl_code_combinations_kfv gcc5, table(xxen_util.rowgen(5)) rowgen where 1=1 and 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 msi.organization_id = ciqt.organization_id and msi.inventory_item_id = ciqt.inventory_item_id and mp.organization_id = ciqt.organization_id and cict.organization_id = ciqt.organization_id and cict.inventory_item_id = ciqt.inventory_item_id and (cict.cost_group_id = ciqt.cost_group_id or mp.primary_cost_method = 1) and sec.organization_id(+) = ciqt.organization_id and sec.secondary_inventory_name(+) = ciqt.subinventory_code and mc.category_id = ciqt.category_id and cic.organization_id = ciqt.organization_id and cic.inventory_item_id = ciqt.inventory_item_id and cic.cost_type_id = cict.cost_type_id and ccg.cost_group_id (+) = ciqt.cost_group_id and ood.organization_id = ciqt.organization_id and gsob.set_of_books_id = ood.set_of_books_id and haou.organization_id = ood.operating_unit and gcc1.code_combination_id = sec.material_account and gcc2.code_combination_id(+) = sec.material_overhead_account and gcc3.code_combination_id(+) = sec.resource_account and gcc4.code_combination_id(+) = sec.outside_processing_account and gcc5.code_combination_id(+) = sec.overhead_account group by gsob.name, haou.name, mp.organization_code, ood.organization_name, nvl(:p_currency_code,gsob.currency_code), xxen_util.meaning(msi.item_type,'ITEM_TYPE',3), msi.concatenated_segments, msi.description, decode(:p_item_revision, 1, ciqt.revision, null), mc.concatenated_segments, msi.primary_uom_code, msi.inventory_item_status_code, cict.inventory_asset_flag, 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)), ciqt.subinventory_code, decode(ciqt.subinventory_code,null,'Intransit','On-hand'), sec.description, sec.asset_inventory, ccg.cost_group, decode(cict.cost_type_id, :p_cost_type_id, ' ', '*'), round(nvl(cict.item_cost,0) * :p_exchange_rate, :p_ext_precision), rowgen.column_value, case rowgen.column_value when 1 then gcc1.concatenated_segments when 2 then gcc2.concatenated_segments when 3 then gcc3.concatenated_segments when 4 then gcc4.concatenated_segments when 5 then gcc5.concatenated_segments end, case rowgen.column_value when 1 then 'Material (' || gcc1.concatenated_segments || ')' when 2 then 'Material Overhead (' || gcc2.concatenated_segments || ')' when 3 then 'Resource (' || gcc3.concatenated_segments || ')' when 4 then 'Outside Processing (' || gcc4.concatenated_segments || ')' when 5 then 'Overhead (' || gcc5.concatenated_segments || ')' end, case rowgen.column_value when 1 then round(nvl(cict.material_cost,0)*:p_exchange_rate, :p_ext_precision) when 2 then round(nvl(cict.material_overhead_cost,0)*:p_exchange_rate, :p_ext_precision) when 3 then round(nvl(cict.resource_cost,0)*:p_exchange_rate, :p_ext_precision) when 4 then round(nvl(cict.outside_processing_cost,0)*:p_exchange_rate, :p_ext_precision) when 5 then round(nvl(cict.overhead_cost,0)*:p_exchange_rate, :p_ext_precision) end having 2=2 and 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 order by ciqt.subinventory_code, msi.concatenated_segments, decode(:p_item_revision, 1, ciqt.revision, null) Y XXEN_INV_VALUE US CST Inventory Value - Multi-Organization (Element Costs) 11i Report: CST Inventory Value - Multi-Organization (Element Costs) Description: This Inventory Value Report reports Inventory Value at the Cost Element level, and can be used to analyze inventory value by Cost Element Account and/or by Cost Element. The report can be run across multiple Inventory Organizations. Provided Templates: * Pivot - Account Summary Inventory Value summarised by Cost Element Account * Pivot - Account, Organization, Subinventory, Item Inventory Value summarised by Cost Element Account, Inventory Organization, SubInventory, Item * Pivot - Cost Element, Organization, Subinventory, Item Inventory Value summarised by Cost Element, Inventory Organization, SubInventory, Item DB package: XXEN_INV_VALUE Enginatics 1=1 2=2 :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_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_set_of_books_id :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_api_mode Char ONHAND F Mode API US API Mode 2 -60 :p_gl_num Number fnd_profile.value('MFG_CHART_OF_ACCOUNTS_ID') F Plan comptable Id US Chart of Accounts Id 3 -50 :p_cat_num Number select mcs.structure_id from mtl_category_sets mcs where mcs.category_set_id=:$flex$.category_set F Structure de la catégorie US Category Structure 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') F Quantité Précision US Quantity Precision 7 -10 :p_view_cost Number fnd_profile.value('CST_VIEW_COSTS') F Voir le privilège des coûts US View Cost Privilege 8 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 9 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 Fonctionnement Unt US Operating Unt 10 30 1=1 mp.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') F Code de l'organisation US Organization Code 11 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) ) F Type de coût Type de coût US Cost Type Cost Type 12 50 :p_as_of_date DateTime sysdate Y F En date du A partir de la date US As of Date As of Date 13 60 :p_item_from Char F Article de Point de US Item From Item from 14 70 :p_item_to Char F Objet à Point à US Item To Item to 15 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 F Ensemble de la catégorie Ensemble de catégories US Category Set Category set 16 90 :p_cat_from Char F Catégorie de Catégorie De US Category From Category From 17 100 :p_cat_to Char F Catégorie à Catégorie Vers US Category To Category To 18 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 F Sous-inventaire De Sous-inventaire de US Subinventory From Subinventory From 19 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 US Subinventory To Subinventory To 20 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 F Monnaie Monnaie US Currency Currency 21 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 F Taux de change Taux de change US Exchange Rate Exchange Rate 22 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 F Quantités par révision Quantités par révision US Quantities By Revision Quantities by Revision 23 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 F Quantités négatives uniquement Quantités négatives uniquement US Negative Quantities only Negative Quantities Only 24 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 F Afficher uniquement les coûts zéro Afficher uniquement le coût zéro US Display Zero Costs only Display zero cost only 25 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 F Inclure les postes de dépenses Inclure les postes de dépenses US Include Expense Items Include expense items 26 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 F Inclure les dépenses des sous-inventaires Inclure les sous-inventaires des dépenses US Include Expense Subinventories Include expense subinventories 27 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 F Inclure les quantités nulles Afficher des quantités nulles US Include Zero Quantities Display zero quantities 28 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 F Inclure les transactions non évaluées Inclure les transactions non valorisées US Include Unvalued Transactions Include Unvalued Transactions :$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 Unt :$flex$.ledger Ledger Organization Code :$flex$.ledger Ledger Subinventory From :$flex$.ledger Ledger 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 Pivot - Account Summary OPERATIONS 21 ACCOUNT 1 15 ASSET_SUBINVENTORY 4 CATEGORY 22 COST_ELEMENT 30 COST_ELEMENT_LABEL 17 COST_GROUP 18 CURRENCY 26 ELEMENT_EXTENDED_VALUE 24 ELEMENT_QTY 25 ELEMENT_UNIT_COST 19 EXCHANGE_RATE 7 INVENTORY_ASSET 1 ITEM 3 2 ITEM_DESCRIPTION 27 ITEM_LABEL 6 ITEM_STATUS 20 ITEM_UNIT_COST 10 LEDGER 8 MAKE_BUY 11 OPERATING_UNIT 12 ORGANIZATION_CODE 29 ORGANIZATION_LABEL 9 PLANNING_METHOD 3 REVISION 13 SUBINVENTORY 2 14 SUBINVENTORY_DESCRIPTION 28 SUBINVENTORY_LABEL 16 TYPE 23 UOM 5 USER_ITEM_TYPE ACCOUNT ROW 2 ASSET_SUBINVENTORY FILTER 4 CATEGORY FILTER 10 ELEMENT_EXTENDED_VALUE VALUE 1 SUM INVENTORY_ASSET FILTER 7 ITEM FILTER 11 ITEM_STATUS FILTER 9 LEDGER ROW 1 MAKE_BUY FILTER 5 OPERATING_UNIT FILTER 1 ORGANIZATION_CODE FILTER 2 PLANNING_METHOD FILTER 6 SUBINVENTORY FILTER 3 USER_ITEM_TYPE FILTER 8 S Site Pivot - Account, Organization, Subinventory, Item OPERATIONS 21 ACCOUNT 1 15 ASSET_SUBINVENTORY 4 CATEGORY 22 COST_ELEMENT 30 COST_ELEMENT_LABEL 17 COST_GROUP 18 CURRENCY 26 ELEMENT_EXTENDED_VALUE SUM 24 ELEMENT_QTY MAX 25 ELEMENT_UNIT_COST SUM 19 EXCHANGE_RATE 7 INVENTORY_ASSET 1 ITEM 2 ITEM_DESCRIPTION 27 ITEM_LABEL 4 6 ITEM_STATUS 20 ITEM_UNIT_COST 10 LEDGER 8 MAKE_BUY 11 OPERATING_UNIT 12 ORGANIZATION_CODE 29 ORGANIZATION_LABEL 2 9 PLANNING_METHOD 3 REVISION 13 SUBINVENTORY 14 SUBINVENTORY_DESCRIPTION 28 SUBINVENTORY_LABEL 3 16 TYPE 23 UOM 5 USER_ITEM_TYPE ACCOUNT ROW 2 ASSET_SUBINVENTORY FILTER 4 CATEGORY FILTER 10 ELEMENT_EXTENDED_VALUE VALUE 1 SUM INVENTORY_ASSET FILTER 7 ITEM_LABEL ROW 5 ITEM_STATUS FILTER 9 LEDGER ROW 1 MAKE_BUY FILTER 5 OPERATING_UNIT FILTER 1 ORGANIZATION_CODE FILTER 2 ORGANIZATION_LABEL ROW 3 PLANNING_METHOD FILTER 6 SUBINVENTORY FILTER 3 SUBINVENTORY_LABEL ROW 4 USER_ITEM_TYPE FILTER 8 S Site Pivot - Cost Element, Organization, Subinventory, Item OPERATIONS 22 ACCOUNT 15 ASSET_SUBINVENTORY 4 CATEGORY 21 COST_ELEMENT 29 COST_ELEMENT_LABEL 1 17 COST_GROUP 18 CURRENCY 26 ELEMENT_EXTENDED_VALUE 24 ELEMENT_QTY 25 ELEMENT_UNIT_COST 19 EXCHANGE_RATE 7 INVENTORY_ASSET 1 ITEM 2 ITEM_DESCRIPTION 27 ITEM_LABEL 3 6 ITEM_STATUS 20 ITEM_UNIT_COST 10 LEDGER 8 MAKE_BUY 11 OPERATING_UNIT 12 ORGANIZATION_CODE 30 ORGANIZATION_LABEL 9 PLANNING_METHOD 3 REVISION 13 SUBINVENTORY 14 SUBINVENTORY_DESCRIPTION 28 SUBINVENTORY_LABEL 2 16 TYPE 23 UOM 5 USER_ITEM_TYPE ASSET_SUBINVENTORY FILTER 5 CATEGORY FILTER 11 COST_ELEMENT_LABEL ROW 1 ELEMENT_EXTENDED_VALUE VALUE 3 SUM ELEMENT_QTY VALUE 1 SUM ELEMENT_UNIT_COST VALUE 2 AVG INVENTORY_ASSET FILTER 8 ITEM FILTER 12 ITEM_LABEL ROW 4 ITEM_STATUS FILTER 10 LEDGER FILTER 1 MAKE_BUY FILTER 6 OPERATING_UNIT FILTER 2 ORGANIZATION_CODE FILTER 3 ORGANIZATION_LABEL ROW 2 PLANNING_METHOD FILTER 7 SUBINVENTORY FILTER 4 SUBINVENTORY_LABEL ROW 3 USER_ITEM_TYPE FILTER 9 S Site Pivot - Summary by Cost Group SYSADMIN 21 ACCOUNT 1 15 ASSET_SUBINVENTORY 4 CATEGORY 22 COST_ELEMENT 30 COST_ELEMENT_LABEL 17 COST_GROUP 18 CURRENCY 26 ELEMENT_EXTENDED_VALUE SUM 24 ELEMENT_QTY MAX 25 ELEMENT_UNIT_COST SUM 19 EXCHANGE_RATE 7 INVENTORY_ASSET 1 ITEM 2 ITEM_DESCRIPTION 27 ITEM_LABEL 4 6 ITEM_STATUS 20 ITEM_UNIT_COST 10 LEDGER 8 MAKE_BUY 11 OPERATING_UNIT 12 ORGANIZATION_CODE 29 ORGANIZATION_LABEL 2 9 PLANNING_METHOD 3 REVISION 13 SUBINVENTORY 14 SUBINVENTORY_DESCRIPTION 28 SUBINVENTORY_LABEL 3 16 TYPE 23 UOM 5 USER_ITEM_TYPE ASSET_SUBINVENTORY FILTER 4 CATEGORY FILTER 10 COST_GROUP ROW 1 ELEMENT_EXTENDED_VALUE VALUE 1 SUM INVENTORY_ASSET FILTER 7 ITEM_STATUS FILTER 9 MAKE_BUY FILTER 5 OPERATING_UNIT FILTER 1 ORGANIZATION_CODE FILTER 2 ORGANIZATION_LABEL ROW 2 PLANNING_METHOD FILTER 6 SUBINVENTORY FILTER 3 SUBINVENTORY_LABEL ROW 3 USER_ITEM_TYPE FILTER 8 S Site Pivot - Account, Organization, Subinventory, Item