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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 FA00000000AC7A10E0530100007FAC01 select gsob.name ledger, haou.name operating_unit, y.organization_code, y.subinventory, y.subinventory_desc, y.asset_subinventory, y.cost_group, y.cost_element, gcck.concatenated_segments account, y.item, y.item_description, y.category, y.user_item_type, y.uom, y.item_status, y.inventory_asset, y.make_buy, y.planning_method, y.revision, y.qty, y.element_value value, y.item||' - '||y.item_description item_label, y.subinventory||' - '||y.subinventory_desc subinventory_label, ood.organization_code||' - '||ood.organization_name organization_label, sysdate report_run_date from ( select x.*, decode(ce.element,6,'Expense',xxen_util.meaning(ce.element,'CST_COST_CODE_TYPE',700)) cost_element, case ce.element when 1 then x.material_acct_id when 2 then x.moh_acct_id when 3 then x.resource_acct_id when 4 then x.osp_acct_id when 5 then x.overhead_acct_id when 6 then x.expense_acct_id end account_id, case ce.element when 1 then x.material_value when 2 then x.moh_value when 3 then x.resource_value when 4 then x.osp_value when 5 then x.overhead_value when 6 then x.expense_value end element_value 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.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, nvl(sec.asset_inventory,1) asset_inventory_flag, ccg.cost_group, round(sum(nvl(ciqt.rollback_qty,0)),:p_qty_precision) qty, -- case when nvl(mp.cost_group_accounting,2)=1 then max(ccga.material_account) when mp.primary_cost_method=1 then max(sec.material_account) else max(mp.material_account) end material_acct_id, case when nvl(mp.cost_group_accounting,2)=1 then max(ccga.material_overhead_account) when mp.primary_cost_method=1 then max(sec.material_overhead_account) else max(mp.material_overhead_account) end moh_acct_id, case when nvl(mp.cost_group_accounting,2)=1 then max(ccga.resource_account) when mp.primary_cost_method=1 then max(sec.resource_account) else max(mp.resource_account) end resource_acct_id, case when nvl(mp.cost_group_accounting,2)=1 then max(ccga.overhead_account) when mp.primary_cost_method=1 then max(sec.overhead_account) else max(mp.overhead_account) end overhead_acct_id, case when nvl(mp.cost_group_accounting,2)=1 then max(ccga.outside_processing_account) when mp.primary_cost_method=1 then max(sec.outside_processing_account) else max(mp.outside_processing_account) end osp_acct_id, max(sec.expense_account) expense_acct_id, -- sum(ciqt.rollback_qty*nvl(cict.material_cost,0)*decode(sec.asset_inventory,2,0,1)*:p_exchange_rate) material_value, sum(ciqt.rollback_qty*nvl(cict.material_overhead_cost,0)*decode(sec.asset_inventory,2,0,1)*:p_exchange_rate) moh_value, sum(ciqt.rollback_qty*nvl(cict.resource_cost,0)*decode(sec.asset_inventory,2,0,1)*:p_exchange_rate) resource_value, sum(ciqt.rollback_qty*nvl(cict.overhead_cost,0)*decode(sec.asset_inventory,2,0,1)*:p_exchange_rate) overhead_value, sum(ciqt.rollback_qty*nvl(cict.outside_processing_cost,0)*decode(sec.asset_inventory,2,0,1)*:p_exchange_rate) osp_value, sum(ciqt.rollback_qty*nvl(cict.item_cost,0)*decode(sec.asset_inventory,2,1,0)*:p_exchange_rate) expense_value 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, cst_cost_groups ccg, cst_cost_group_accounts ccga where ciqt.qty_source in (3,4,5) and cict.organization_id=ciqt.organization_id and cict.inventory_item_id=ciqt.inventory_item_id and cict.cost_source in (1,2) and (mp.primary_cost_method=1 or cict.cost_group_id=ciqt.cost_group_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 ccg.cost_group_id(+)=coalesce(ciqt.cost_group_id,cict.cost_group_id,mp.default_cost_group_id) and ccga.organization_id(+)=ciqt.organization_id and ccga.cost_group_id(+)=coalesce(ciqt.cost_group_id,mp.default_cost_group_id) group by mp.organization_id, mp.organization_code, mp.primary_cost_method, mp.cost_group_accounting, 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, 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, sec.description, sec.asset_inventory, ccg.cost_group 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, (select 1 element from dual union all select 2 from dual union all select 3 from dual union all select 4 from dual union all select 5 from dual union all select 6 from dual) ce where (nvl(x.asset_inventory_flag,1)<>2 and ce.element between 1 and 5 or nvl(x.asset_inventory_flag,1)=2 and ce.element=6) and case ce.element when 1 then x.material_value when 2 then x.moh_value when 3 then x.resource_value when 4 then x.osp_value when 5 then x.overhead_value when 6 then x.expense_value end<>0 ) y, gl_code_combinations_kfv gcck, org_organization_definitions ood, hr_all_organization_units haou, gl_sets_of_books gsob where 1=1 and y.account_id=gcck.code_combination_id(+) and y.organization_id=ood.organization_id and ood.operating_unit=haou.organization_id and ood.set_of_books_id=gsob.set_of_books_id order by y.organization_code, y.subinventory, gcck.concatenated_segments, y.cost_element, y.item, y.revision Initial version - Subinventory Account Value with multi-org support Y XXEN_INV_VALUE US CST Subinventory Account Value - Multi-Org Report: CST Subinventory Account Value - Multi-Org Description: Shows onhand inventory value broken down by GL account and cost element across multiple organizations. For each subinventory, the report unpivots inventory value into separate rows per cost element (Material, Material Overhead, Resource, Outside Processing, Overhead), each showing the GL account where that cost element is recorded. Asset subinventories show 5 rows per item (one per cost element). Expense subinventories show 1 row per item with total cost under the expense account. Account determination follows Oracle standard costing rules: - Standard costing: accounts from subinventory setup (mtl_secondary_inventories) - Average/FIFO/LIFO costing: accounts from organization defaults (mtl_parameters) - Cost group accounting: accounts from cost group accounts (cst_cost_group_accounts) Corresponds to Oracle standard report: Subinventory Account Value Report (CSTRSAVR) The report can be run across multiple Inventory Organizations. DB package: XXEN_INV_VALUE Enginatics 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_report_code :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 -100 :p_report_code Char INV_VALUE US Report Code 2 -90 :p_gl_num Number fnd_profile.value('MFG_CHART_OF_ACCOUNTS_ID') US Chart of Accounts Id 3 -80 :p_cat_num Number select mcs.structure_id from mtl_category_sets mcs where mcs.category_set_id=:$flex$.category_set US Category Structure 4 -70 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') US CST_SRS_INVERSE_RATE 5 -60 :p_rate_type Number 2 US CST_SRS_RATE_TYPE 6 -50 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') US Quantity Precision 7 -40 :p_view_cost Number fnd_profile.value('CST_VIEW_COSTS') US View Cost Privilege 8 -30 :p_api_mode Char Onhand 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) 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)) 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') US Organization Code 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) ) US Cost Type Cost Type 13 50 :p_as_of_date DateTime sysdate US As of Date As of Date 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). 15 60 :p_item_from Char US Item From 16 70 :p_item_to Char US Item To 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 mcs.category_set_name from mtl_category_sets mcs, mtl_default_category_sets mdcs where mdcs.functional_area_id=5 and mcs.category_set_id=mdcs.category_set_id Y US Category Set Category Set 18 90 :p_cat_from Char US Category From 19 100 :p_cat_to Char US Category To 20 110 :p_subinv_from Char US Subinventory From 21 120 :p_subinv_to Char US Subinventory To 22 130 :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 select meaning from mfg_lookups where lookup_type='SYS_YES_NO' and lookup_code=2 Y US Quantities By Revision Quantities By Revision 23 140 :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 select meaning from mfg_lookups where lookup_type='SYS_YES_NO' and lookup_code=2 Y US Negative Quantities Only Negative Quantities Only 24 150 :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 select meaning from mfg_lookups where lookup_type='SYS_YES_NO' and lookup_code=2 Y US Include Expense Items Include Expense Items 25 160 :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 select meaning from mfg_lookups where lookup_type='SYS_YES_NO' and lookup_code=2 Y US Include Zero Quantities Include Zero Quantities