ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 8E2FF36EDF2E79D2E0530100007F1FF2 INV Category (restricted) Y select mck.concatenated_segments value, mct.description from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_categories_tl mct where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mck.structure_id and (mcsv.category_set_id, mck.category_id) in (select mic.category_set_id, mic.category_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) and mck.category_id=mct.category_id and mct.language=userenv('lang') order by mck.concatenated_segments AR فئة عنصر المخزون ، مقيدة بمجموعة الفئة المحددة السابقة والفئات التي تحتوي على عنصر واحد على الأقل معين في MFG_ORGANIZATION_ID الحالي D Kategorie des Inventarartikels, eingeschränkt auf den zuvor ausgewählten Kategoriensatz und auf Kategorien, denen mindestens ein Artikel in der aktuellen MFG_ORGANIZATION_ID zugeordnet ist E Categoría de artículo de inventario, restringida al conjunto de categorías seleccionadas anteriormente y a las categorías que tienen al menos un artículo asignado en el MFG_ORGANIZATION_ID actual F Catégorie d'article d'inventaire, limitée à l'ensemble des catégories sélectionnées précédemment et aux catégories auxquelles au moins un article est attribué dans l'ID_ORGANISATION_FMG actuelle I Categoria di articolo dell'inventario, limitata al precedente set di categorie selezionato e alle categorie che hanno almeno un articolo assegnato nel MFG_ORGANIZATION_ID corrente JA インベントリ項目カテゴリ、前に選択されたカテゴリセットに制限され、現在のMFG_ORGANIZATION_IDに少なくとも1つの項目が割り当てられているカテゴリに制限されています。 KO 재고 품목 범주, 이전에 선택한 범주 세트 및 현재 MFG_ORGANIZATION_ID에 할당 된 품목이 하나 이상있는 범주로 제한됨 PTB Categoria de item de inventário, restrita ao conjunto de categorias selecionadas anteriormente e às categorias que têm pelo menos um item atribuído no MFG_ORGANIZATION_ID atual RU Категория инвентаризационных элементов, ограниченная ранее выбранной категорией и категориями, которым в текущем идентификаторе MFG_ORGANIZATION_ID присвоен хотя бы один элемент. S Lagerkategori, begränsad till tidigare vald kategorisats och till kategorier som har åtminstone ett objekt tilldelat i den aktuella MFG_ORGANIZATION_ID TR Envanter öğesi kategorisi, önceki seçilen kategori grubuyla ve geçerli MFG_ORGANIZATION_ID'de atanmış en az bir öğeye sahip kategorilerle sınırlıdır US Inventory item category, restricted to previous selected category set and to categories which have at least one item assigned in the current MFG_ORGANIZATION_ID ZHS 库存项目类别，仅限于以前选定的类别集和在当前MFG_ORGANIZATION_ID中至少有一个项目的类别。 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US 8E2FF36EDF2D79D2E0530100007F1FF2 INV Category Set (restricted) Y select mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where mcsv.category_set_id in (select mic.category_set_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) order by mcsv.category_set_name US Category sets having at least one assigned inv items 8E2FF36EDF0079D2E0530100007F1FF2 INV Cross Reference Y select mcrv.cross_reference value, mcrv.description from mtl_cross_references_vl mcrv where (mcrv.organization_id is null or :$flex$.organization_code is null or mcrv.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and (:$flex$.cross_reference_type is null or mcrv.cross_reference_type=:$flex$.cross_reference_type) order by mcrv.cross_reference US 8E2FF36EDEE479D2E0530100007F1FF2 INV Cross Reference Type Y select mcrt.cross_reference_type value, mcrt.description from mtl_cross_reference_types mcrt where sysdate<nvl(mcrt.disable_date,sysdate+1) order by mcrt.cross_reference_type US B8DD9131FE72F277E0530100007F06F8 INV Item Description (master) Y select msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments US Inventory item descriptions restricted to the accessible inventory organizations only. 8E2FF36EDE8579D2E0530100007F1FF2 INV Item Type Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US 0B22DF18E239D64AE0630100007FBD85 INV Organization Code (including master) Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where 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) 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 order by ood.organization_code US All active inventory organization codes, restricted to the current user's org access view 8E2FF36EDEC079D2E0530100007F1FF2 INV Planner Code Y select x.* from ( select mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by mp.planner_code ) x union all select '<null>' value, null description from dual US Planner codes restricted to the currently selected inv organization 8E2FF36EDF2F79D2E0530100007F1FF2 PO Buyer Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name Corrected restriction to show buyers of the inventory orgs business group US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A8039008ACE0530100007FEB91 select mp.organization_code, haouv.name organization_name, msiv.concatenated_segments item, msiv.description, msiv.long_description, &category_columns -- Catalog Assignment (select micgbk.concatenated_segments from mtl_item_catalog_groups_b_kfv micgbk where msiv.item_catalog_group_id=micgbk.item_catalog_group_id) item_catalog, -- -- Main xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, (select misv.inventory_item_status_code_tl from mtl_item_status_vl misv where msiv.inventory_item_status_code=misv.inventory_item_status_code) item_status, xxen_util.meaning(msiv.allowed_units_lookup_code,'MTL_CONVERSION_TYPE',700) conversions, (select muomt.unit_of_measure_tl from mtl_units_of_measure_tl muomt where msiv.primary_uom_code=muomt.uom_code and muomt.language=userenv('lang')) primary_uom, (select muomt.unit_of_measure_tl from mtl_units_of_measure_tl muomt where msiv.secondary_uom_code=muomt.uom_code and muomt.language=userenv('lang')) secondary_uom, xxen_util.meaning(msiv.tracking_quantity_ind,'INV_TRACKING_UOM_TYPE',0) tracking_uom_indicator, xxen_util.meaning(msiv.ont_pricing_qty_source,'INV_PRICING_UOM_TYPE',0) pricing_uom_indicator, xxen_util.meaning(msiv.secondary_default_ind,'INV_DEFAULTING_UOM_TYPE',0) defaulting_control, msiv.dual_uom_deviation_high deviation_factor_plus, msiv.dual_uom_deviation_low deviation_factor_minus, -- Inventory xxen_util.meaning(msiv.inventory_item_flag,'YES_NO',0) inventory_item_flag, xxen_util.meaning(msiv.stock_enabled_flag,'YES_NO',0) stockable, xxen_util.meaning(msiv.mtl_transactions_enabled_flag,'YES_NO',0) transactable, xxen_util.meaning(msiv.revision_qty_control_code,'MTL_ENG_QUANTITY',700) revision_control, xxen_util.meaning(msiv.reservable_type,'MTL_RESERVATION_CONTROL',700) reservable, xxen_util.meaning(msiv.check_shortages_flag,'YES_NO',0) check_material_shortage, xxen_util.meaning(msiv.location_control_code,'MTL_LOCATION_CONTROL',700) locator_control, xxen_util.meaning(msiv.restrict_subinventories_code,'MTL_SUBINVENTORY_RESTRICTIONS',700) restrict_subinventories, xxen_util.meaning(msiv.restrict_locators_code,'MTL_LOCATOR_RESTRICTIONS',700) restrict_locators, -----Serial xxen_util.meaning(msiv.serial_number_control_code,'MTL_SERIAL_NUMBER',700) serial_number_generation, msiv.start_auto_serial_number starting_serial_number, msiv.auto_serial_alpha_prefix starting_serial_prefix, ------Lot xxen_util.meaning(msiv.lot_control_code,'MTL_LOT_CONTROL',700) lot_control, msiv.start_auto_lot_number starting_lot_number, msiv.auto_lot_alpha_prefix starting_lot_prefix, ----Lot Expiration xxen_util.meaning(msiv.shelf_life_code,'MTL_SHELF_LIFE',700) lot_expiration, msiv.shelf_life_days shelf_life_days, msiv.retest_interval retest_interval, msiv.expiration_action_interval expiration_action_interval, (select ma.description from mtl_actions ma where msiv.expiration_action_code=ma.action_code) expiration_action, ----Cycle Count xxen_util.meaning(msiv.cycle_count_enabled_flag,'YES_NO',0) cycle_count_enabled, msiv.negative_measurement_error negative_measurement_error, msiv.positive_measurement_error positive_measurement_error, ----Grade Controlled xxen_util.meaning(msiv.grade_control_flag,'YES_NO',0) grade_controlled, (select mg.description from mtl_grades mg where msiv.default_grade=mg.grade_code) default_grade, ----Not Visible in Form (select mms.status_code from mtl_material_statuses mms where msiv.default_material_status_id=mms.status_id) default_material_status, xxen_util.meaning(msiv.lot_status_enabled,'YES_NO',0) lot_status_enabled, (select mms.status_code from mtl_material_statuses mms where mms.status_id = msiv.default_lot_status_id) default_lot_status, xxen_util.meaning(msiv.serial_status_enabled,'YES_NO',0) serial_status_enabled, (select mms.status_code from mtl_material_statuses mms where mms.status_id = msiv.default_serial_status_id) default_serial_status, xxen_util.meaning(msiv.lot_split_enabled,'YES_NO',0) lot_split_enabled, xxen_util.meaning(msiv.lot_merge_enabled,'YES_NO',0) lot_merge_enabled, xxen_util.meaning(msiv.lot_translate_enabled,'YES_NO',0) lot_translate_enabled, xxen_util.meaning(msiv.lot_substitution_enabled,'YES_NO',0) lot_substitution_enabled, xxen_util.meaning(msiv.bulk_picked_flag,'YES_NO',0) bulk_picked, xxen_util.meaning(msiv.lot_divisible_flag,'YES_NO',0) lot_divisible, xxen_util.meaning(msiv.child_lot_flag,'YES_NO',0) child_lot_enabled, xxen_util.meaning(msiv.parent_child_generation_flag,'INV_PARENT_CHILD_GENERATION',0) child_lot_generation, msiv.child_lot_prefix child_lot_prefix, msiv.child_lot_starting_number child_lot_starting_number, xxen_util.meaning(msiv.child_lot_validation_flag,'YES_NO',0) child_lot_format_validation, msiv.maturity_days maturity_days, msiv.hold_days hold_days, xxen_util.meaning(msiv.copy_lot_attribute_flag,'YES_NO',0) copy_lot_attributes, --Bills of Material xxen_util.meaning(msiv.bom_enabled_flag,'YES_NO',0) bom_allowed, xxen_util.meaning(msiv.bom_item_type,'BOM_ITEM_TYPE',700) bom_item_type, (select msiv2.concatenated_segments from mtl_system_items_vl msiv2 where msiv2.organization_id = msiv.organization_id and msiv2.inventory_item_id = msiv.base_item_id) base_model, xxen_util.meaning(msiv.auto_created_config_flag,'YES_NO',0) autocreated_configuration, xxen_util.meaning(msiv.effectivity_control,'BOM_EFFECTIVITY_CONTROL',700) effectivity_control, xxen_util.meaning(msiv.config_model_type,'CZ_CONFIG_MODEL_TYPE',708) configurator_model_type, xxen_util.meaning(msiv.config_orgs,'INV_CONFIG_ORGS_TYPE',0) create_configured_item_bom, xxen_util.meaning(msiv.config_match,'INV_CONFIG_MATCH_TYPE',0) match_configuration, ----Not Visible in Form xxen_util.meaning(msiv.eng_item_flag,'YES_NO',0) engineering_item, -- Costing xxen_util.meaning(msiv.costing_enabled_flag,'YES_NO',0) costing_enabled, xxen_util.meaning(msiv.inventory_asset_flag,'YES_NO',0) inventory_asset_value, xxen_util.meaning(msiv.default_include_in_rollup_flag,'YES_NO',0) include_in_rollup, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = msiv.cost_of_sales_account) cost_of_goods_sold_account, msiv.std_lot_size standard_lot_size, -- Asset Management xxen_util.meaning(msiv.eam_item_type,'MTL_EAM_ITEM_TYPE',700) asset_item_type, xxen_util.meaning(msiv.eam_activity_type_code,'MTL_EAM_ACTIVITY_TYPE',700) asset_activity_type, xxen_util.meaning(msiv.eam_activity_cause_code,'MTL_EAM_ACTIVITY_CAUSE' ,700) asset_activity_cause, xxen_util.meaning(msiv.eam_activity_source_code,'MTL_EAM_ACTIVITY_SOURCE',700) asset_activity_source, xxen_util.meaning(msiv.eam_act_shutdown_status, 'BOM_EAM_SHUTDOWN_TYPE',700) asset_shutdown_type, xxen_util.meaning(msiv.eam_act_notification_flag,'YES_NO',0) asset_notification_required, -- Purchasing xxen_util.meaning(msiv.purchasing_item_flag,'YES_NO',0) purchased, xxen_util.meaning(msiv.purchasing_enabled_flag,'YES_NO',0) purchasable, xxen_util.meaning(msiv.must_use_approved_vendor_flag,'YES_NO',0) use_approved_supplier, xxen_util.meaning(msiv.allow_item_desc_update_flag,'YES_NO',0) allow_description_update, xxen_util.meaning(msiv.outsourced_assembly,'SYS_YES_NO',700) outsourced_assembly, xxen_util.meaning(msiv.outside_operation_flag,'YES_NO',0) outside_processing_item, xxen_util.meaning(msiv.outside_operation_uom_type,'OUTSIDE OPERATION UOM TYPE',201) outside_processing_unit_type, xxen_util.meaning(msiv.rfq_required_flag,'YES_NO',0) rfq_required, xxen_util.meaning(msiv.taxable_flag,'YES_NO',0) taxable, xxen_util.meaning(msiv.purchasing_tax_code,'ZX_INPUT_CLASSIFICATIONS',0) input_tax_classification_code, xxen_util.meaning(msiv.receipt_required_flag,'YES_NO',0) receipt_required, xxen_util.meaning(msiv.inspection_required_flag,'YES_NO',0) inspection_required, (select ppx.full_name from per_people_x ppx where ppx.person_id = msiv.buyer_id) default_buyer, msiv.list_price_per_unit list_price, msiv.market_price market_price, msiv.price_tolerance_percent price_tolerance_pct, msiv.receive_close_tolerance receipt_close_tolerance, msiv.invoice_close_tolerance invoice_close_tolerance, msiv.rounding_factor rounding_factor, (select muomt.unit_of_measure_tl from mtl_units_of_measure_tl muomt where muomt.unit_of_measure = msiv.unit_of_issue and language = userenv('lang') and rownum <= 1) unit_of_issue, (select pun.un_number from po_un_numbers pun where pun.un_number_id = msiv.un_number_id) un_number, (select phc.hazard_class from po_hazard_classes phc where phc.hazard_class_id = msiv.hazard_class_id) hazard_class, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = msiv.encumbrance_account) encumbrance_account, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = msiv.expense_account) expense_account, (select fcbk.concatenated_segments from fa_categories_b_kfv fcbk where fcbk.category_id = msiv.asset_category_id) asset_category, -- Receiving xxen_util.meaning(msiv.receipt_days_exception_code,'RECEIVING CONTROL LEVEL',201) receipt_date_action, msiv.days_early_receipt_allowed days_early_receipt_allowed, msiv.days_late_receipt_allowed days_late_receipt_allowed, xxen_util.meaning(msiv.allow_substitute_receipts_flag,'YES_NO',0) allow_substitute_receipts, xxen_util.meaning(msiv.allow_unordered_receipts_flag,'YES_NO',0) allow_unordered_receipts, xxen_util.meaning(msiv.allow_express_delivery_flag,'YES_NO',0) allow_express_transactions, xxen_util.meaning(msiv.qty_rcv_exception_code,'RCV OPTION',201) over_receipt_qty_action, msiv.qty_rcv_tolerance over_receipt_qty_tolerance, (select rrh.routing_name from rcv_routing_headers rrh where rrh.routing_header_id = msiv.receiving_routing_id) receipt_routing, xxen_util.meaning(msiv.enforce_ship_to_location_code,'RECEIVING CONTROL LEVEL',201) enforce_ship_to, -- Physical Attributes (select muomt.unit_of_measure_tl from mtl_units_of_measure_tl muomt where muomt.uom_code = msiv.weight_uom_code and language = userenv('lang') and rownum <= 1) weight_uom, msiv.unit_weight unit_weight, (select muomt.unit_of_measure_tl from mtl_units_of_measure_tl muomt where muomt.uom_code = msiv.volume_uom_code and language = userenv('lang') and rownum <= 1) volume_uom, msiv.unit_volume unit_volume, (select muomt.unit_of_measure_tl from mtl_units_of_measure_tl muomt where muomt.uom_code = msiv.dimension_uom_code and language = userenv('lang') and rownum <= 1) dimension_uom, msiv.unit_length unit_length, msiv.unit_width unit_width, msiv.unit_height unit_height, xxen_util.meaning(msiv.container_item_flag,'YES_NO',0) container, xxen_util.meaning(msiv.vehicle_item_flag,'YES_NO',0) vehicle, xxen_util.meaning(msiv.container_type_code,'CONTAINER_TYPE',3) container_type, msiv.internal_volume internal_volume, msiv.maximum_load_weight maximum_load_weight, msiv.minimum_fill_percent minimum_fill_percentage, xxen_util.meaning(msiv.collateral_flag,'YES_NO',0) collateral_item, xxen_util.meaning(msiv.event_flag,'YES_NO',0) event, xxen_util.meaning(msiv.equipment_type,'SYS_YES_NO',700) equipment, xxen_util.meaning(msiv.electronic_flag,'YES_NO',0) electronic_format, xxen_util.meaning(msiv.downloadable_flag,'YES_NO',0) downloadable, xxen_util.meaning(msiv.indivisible_flag,'YES_NO',0) om_indivisible, -- General Planning xxen_util.meaning(msiv.inventory_planning_code,'MTL_MATERIAL_PLANNING',700) inventory_planning_method, msiv.planner_code planner, (select mpl.description from mtl_planners mpl where msiv.planner_code=mpl.planner_code and msiv.organization_id=mpl.organization_id) planner_description, xxen_util.meaning(msiv.subcontracting_component,'INV_SUBCONTRACTING_COMPONENT',700) subcontracting_component, xxen_util.meaning(msiv.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_or_buy, msiv.min_minmax_quantity min_minmax_quantity, msiv.max_minmax_quantity max_minmax_quantity, msiv.minimum_order_quantity minimum_order_quantity, msiv.maximum_order_quantity maximum_order_quantity, msiv.order_cost order_cost, msiv.carrying_cost carrying_cost_percent, xxen_util.meaning(msiv.source_type,'MTL_SOURCE_TYPES',700) source_type, (select mp2.organization_code from mtl_parameters mp2 where mp2.organization_id = msiv.source_organization_id) source_organization, msiv.source_subinventory source_subinventory, xxen_util.meaning(msiv.mrp_safety_stock_code,'MTL_SAFETY_STOCK_TYPE',700) safety_stock, msiv.safety_stock_bucket_days safety_stock_bucket_days, msiv.mrp_safety_stock_percent safety_stock_percent, msiv.fixed_order_quantity fixed_order_quantity, msiv.fixed_days_supply fixed_days_supply, msiv.fixed_lot_multiplier fixed_lot_multiplier, -- msiv.vmi_minimum_units vmi_minimum_quantity, msiv.vmi_minimum_days vmi_minimum_days_of_supply, msiv.vmi_maximum_units vmi_maximum_quantity, msiv.vmi_maximum_days vmi_maximum_days_of_supply, msiv.vmi_fixed_order_quantity vmi_fixed_quantity, xxen_util.meaning(msiv.so_authorization_flag,'MTL_MSI_GP_RELEASE_AUTH',700) vmi_release_auth_required, xxen_util.meaning(msiv.consigned_flag,'SYS_YES_NO',700) vmi_consigned, xxen_util.meaning(msiv.asn_autoexpire_flag,'SYS_YES_NO',700) vmi_auto_expire_asn, xxen_util.meaning(msiv.vmi_forecast_type,'MTL_MSI_GP_FORECAST_TYPE',700) vmi_forecast_type, msiv.forecast_horizon vmi_forecaset_window_days, -- MPS/MRP Planning xxen_util.meaning(msiv.mrp_planning_code,'MRP_PLANNING_CODE',700) mrp_planning_method, xxen_util.meaning(msiv.ato_forecast_control,'MRP_ATO_FORECAST_CONTROL',700) forecast_control, xxen_util.meaning(msiv.end_assembly_pegging_flag,'ASSEMBLY_PEGGING_CODE',0) end_assembly_pegging, msiv.planning_exception_set planning_exception_set, msiv.shrinkage_rate shrinkage_rate, msiv.acceptable_early_days acceptable_early_days, -- xxen_util.meaning(msiv.rounding_control_type,'MTL_ROUNDING',700) round_order_quantities, xxen_util.meaning(msiv.planned_inv_point_flag,'YES_NO',0) planned_inventory_point, xxen_util.meaning(msiv.create_supply_flag,'YES_NO',0) create_supply, xxen_util.meaning(msiv.exclude_from_budget_flag,'SYS_YES_NO',700) exclude_from_budget, xxen_util.meaning(msiv.critical_component_flag,'SYS_YES_NO',700) critical_component, -- xxen_util.meaning(msiv.mrp_calculate_atp_flag,'YES_NO',0) calculate_atp, xxen_util.meaning(msiv.auto_reduce_mps,'MRP_AUTO_REDUCE_MPS',700) reduce_mps, -- xxen_util.meaning(msiv.repetitive_planning_flag,'YES_NO',0) repetitive_planning, msiv.overrun_percentage overrun_percentage, msiv.acceptable_rate_decrease acceptable_rate_minus, msiv.acceptable_rate_increase acceptable_rate_plus, -- xxen_util.meaning(msiv.planning_time_fence_code,'MTL_TIME_FENCE',700) planning_time_fence, msiv.planning_time_fence_days planning_time_fence_days, xxen_util.meaning(msiv.demand_time_fence_code,'MTL_TIME_FENCE',700) demand_time_fence, msiv.demand_time_fence_days demand_time_fence_days, xxen_util.meaning(msiv.release_time_fence_code,'MTL_RELEASE_TIME_FENCE',700) release_time_fence, msiv.release_time_fence_days release_time_fence_days, xxen_util.meaning(msiv.substitution_window_code, 'MTL_TIME_FENCE',700) substitution_window, msiv.substitution_window_days substitution_window_days, -- xxen_util.meaning(msiv.continous_transfer,'MTL_MSI_MRP_INT_ORG',700) continuous_inter_org_transfers, xxen_util.meaning(msiv.convergence,'MTL_MSI_MRP_CONV_SUPP',700) convergence_pattern, xxen_util.meaning(msiv.divergence,'MTL_MSI_MRP_DIV_SUPP',700) divergence_pattern, -- xxen_util.meaning(msiv.drp_planned_flag,'SYS_YES_NO',700) drp_planned, msiv.days_max_inv_supply drp_max_inv_days_supply, msiv.days_max_inv_window drp_max_inv_window, msiv.days_tgt_inv_supply drp_target_inv_days_supply, msiv.days_tgt_inv_window drp_target_inv_window, -- xxen_util.meaning(msiv.repair_program,'INV_REPAIR_PROGRAM',700) repair_program, msiv.repair_leadtime repair_lead_time, msiv.repair_yield repair_yield, xxen_util.meaning(msiv.preposition_point,'YES_NO',0) repair_preposition_point, -- Lead Times msiv.preprocessing_lead_time preprocessing_lead_time, msiv.full_lead_time processing_lead_time, msiv.postprocessing_lead_time postprocessing_lead_time, msiv.fixed_lead_time fixed_lead_time, msiv.variable_lead_time variable_lead_time, msiv.cum_manufacturing_lead_time cum_manufacturing_lead_time, msiv.cumulative_total_lead_time cumulative_total_lead_time, msiv.lead_time_lot_size lead_time_lot_size, -- Work In Process xxen_util.meaning(msiv.build_in_wip_flag,'YES_NO',0) build_in_wip, xxen_util.meaning(msiv.wip_supply_type,'WIP_SUPPLY',700) wip_supply_type, msiv.wip_supply_subinventory wip_supply_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.inventory_location_id = msiv.wip_supply_locator_id) wip_supply_locator, xxen_util.meaning(msiv.overcompletion_tolerance_type,'WIP_TOLERANCE_TYPE',700) overcompletion_tolerance_type, msiv.overcompletion_tolerance_value overcompletion_tolerance_value, msiv.inventory_carry_penalty inventory_carry_penalty, msiv.operation_slack_penalty operation_slack_penalty, -- Order Management xxen_util.meaning(msiv.customer_order_flag,'YES_NO',0) customer_ordered, xxen_util.meaning(msiv.customer_order_enabled_flag,'YES_NO',0) customer_orders_enabled, xxen_util.meaning(msiv.internal_order_flag,'YES_NO',0) internal_order_flag, xxen_util.meaning(msiv.internal_order_enabled_flag,'YES_NO',0) internal_orders_enabled, xxen_util.meaning(msiv.shippable_item_flag,'YES_NO',0) shippable, xxen_util.meaning(msiv.so_transactions_flag,'YES_NO',0) oe_transactable, xxen_util.meaning(msiv.pick_components_flag,'YES_NO',0) pick_components, xxen_util.meaning(msiv.replenish_to_order_flag,'YES_NO',0) assemble_to_order, xxen_util.meaning(msiv.ship_model_complete_flag,'YES_NO',0) ship_model_complete, xxen_util.meaning(msiv.returnable_flag,'YES_NO',0) returnable, xxen_util.meaning(msiv.return_inspection_requirement,'MTL_RETURN_INSPECTION',700) rma_inspection_required, xxen_util.meaning(msiv.financing_allowed_flag,'YES_NO',0) financing_allowed, -- xxen_util.meaning(msiv.atp_flag,'ATP_FLAG',3) check_atp, (select mar.rule_name from mtl_atp_rules mar where mar.rule_id = msiv.atp_rule_id) atp_rule, (select mar.infinite_supply_time_fence from mtl_atp_rules mar where mar.rule_id = msiv.atp_rule_id) atp_time_fence_days, xxen_util.meaning(msiv.atp_components_flag,'ATP_FLAG',3) atp_components, (select wrv.name from wms_rules_vl wrv where wrv.rule_id = msiv.picking_rule_id) picking_rule, (select mp2.organization_code from mtl_parameters mp2 where mp2.organization_id = msiv.default_shipping_org) default_shipping_organization, xxen_util.meaning(msiv.default_so_source_type,'SOURCE_TYPE',660) default_so_source_type, (select fnd.unit_of_measure from mtl_uom_conversions fnd where fnd.uom_class = '(FND_PROFILE.VALUE(ONT_UOM_CLASS_CHARGE_PERIODICITY))' and fnd.UOM_CODE = msiv.charge_periodicity_code) charge_periodicity, -- msiv.over_shipment_tolerance over_shipment_tolerance, msiv.under_shipment_tolerance under_shipment_tolerance, msiv.over_return_tolerance over_return_tolerance, msiv.under_return_tolerance under_return_tolerance, -- Invoicing xxen_util.meaning(msiv.invoiceable_item_flag,'YES_NO',0) invoiceable_item, xxen_util.meaning(msiv.invoice_enabled_flag,'YES_NO',0) invoice_enabled, (select rr.name from ra_rules rr where rr.rule_id = msiv.accounting_rule_id) accounting_rule, (select rr.name from ra_rules rr where rr.rule_id = msiv.invoicing_rule_id) invoicing_rule, xxen_util.meaning(msiv.tax_code,'ZX_OUTPUT_CLASSIFICATIONS',0) output_tax_classification_code, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = msiv.sales_account) sales_account, (select rtv.name from ra_terms_vl rtv where rtv.term_id = msiv.payment_terms_id) payment_terms, -- Service xxen_util.meaning(msiv.serv_req_enabled_code,'CS_SR_SERV_REQ_ENABLED_TYPE',170) service_request_enabled, xxen_util.meaning(msiv.serviceable_product_flag,'YES_NO',0) enable_contract_coverage, xxen_util.meaning(msiv.defect_tracking_on_flag,'YES_NO',0) enable_defect_tracking, xxen_util.meaning(msiv.comms_activation_reqd_flag,'YES_NO',0) enable_provisioning, -- xxen_util.meaning(msiv.contract_item_type_code,'OKB_CONTRACT_ITEM_TYPE',0) contract_item_type, msiv.service_duration contract_duration, (select muomt.unit_of_measure_tl from mtl_units_of_measure_tl muomt where muomt.uom_code = msiv.service_duration_period_code and language = userenv('lang') and rownum <= 1) contract_duration_period, (select octv.name from oks_coverage_templts_v octv where octv.id = msiv.coverage_schedule_id) contract_coverage_template, msiv.service_starting_delay contract_starting_delay_days, -- xxen_util.meaning(msiv.comms_nl_trackable_flag,'YES_NO',0) track_in_installed_base, (select xxen_util.meaning('Y','YES_NO',0) from csi_item_instances cii where msiv.inventory_item_id=cii.inventory_item_id and cii.accounting_class_code='CUST_PROD' and rownum=1) ib_exists, ccg.name counter_group, xxen_util.meaning(msiv.ib_item_instance_class,'CSI_ITEM_CLASS',170) item_instance_class, xxen_util.meaning(decode(msiv.asset_creation_code,0,2,msiv.asset_creation_code),'SYS_YES_NO',700) create_fixed_asset, -- xxen_util.meaning(msiv.recovered_part_disp_code,'CSP_RECOVERED_PART_DISP_CODE',0) recovered_part_disposition, xxen_util.meaning(msiv.serv_billing_enabled_flag,'YES_NO',0) enable_service_billing, xxen_util.meaning(msiv.material_billable_flag,'MTL_SERVICE_BILLABLE_FLAG',170) billing_type, -- Web Option xxen_util.meaning(msiv.web_status,'IBE_ITEM_STATUS',0) web_status, xxen_util.meaning(msiv.orderable_on_web_flag,'YES_NO',0) orderable_on_the_web, xxen_util.meaning(msiv.back_orderable_flag,'YES_NO',0) back_orderable, msiv.minimum_license_quantity minimum_license_quantity, -- Process Manufacturing xxen_util.meaning(msiv.process_quality_enabled_flag,'YES_NO',0) process_quality_enabled, xxen_util.meaning(msiv.process_costing_enabled_flag,'YES_NO',0) process_costing_enabled, xxen_util.meaning(msiv.recipe_enabled_flag,'YES_NO',0) recipe_enabled, xxen_util.meaning(msiv.process_execution_enabled_flag,'YES_NO',0) process_execution_enabled, msiv.process_supply_subinventory process_supply_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.inventory_location_id = msiv.process_supply_locator_id) process_supply_locator, msiv.process_yield_subinventory process_yield_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where milk.inventory_location_id = msiv.process_yield_locator_id) process_yield_locator, xxen_util.meaning(msiv.hazardous_material_flag,'YES_NO',0) hazardous_material, msiv.cas_number cas_number, -- &dff_columns -- mm.manufacturer_name manufaturer, mmpn.mfg_part_num manufacturer_part_number, -- xxen_util.user_name(msiv.created_by) created_by, xxen_util.client_time(msiv.creation_date) creation_date, xxen_util.user_name(msiv.last_updated_by) last_updated_by, xxen_util.client_time(msiv.last_update_date) last_update_date, msiv.inventory_item_id from hr_all_organization_units_vl haouv, mtl_parameters mp, mtl_system_items_vl msiv, cs_ctr_associations cca, cs_counter_groups ccg, mtl_mfg_part_numbers mmpn, mtl_manufacturers mm where 1=1 and msiv.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 msiv.organization_id=haouv.organization_id and msiv.organization_id=mp.organization_id and msiv.inventory_item_id=cca.source_object_id(+) and cca.counter_group_id=ccg.counter_group_id(+) and msiv.inventory_item_id=mmpn.inventory_item_id(+) and msiv.organization_id=mmpn.organization_id(+) and mmpn.manufacturer_id=mm.manufacturer_id(+) order by mp.organization_code, msiv.concatenated_segments Added ATP Time Fence Days Y AR INV Inventory Items تقرير البيانات الرئيسية الذي يسرد السمات الرئيسية للعنصر مثل نوع العنصر ووحدة التحكم والحالة والتحكم التسلسلي وأرقام الحسابات والعديد من السمات الأخرى D INV Inventory Items Inventory item master setup including main item attributes such as item type, uom, status, serial control, physical and various other attributes E INV Inventory Items Informe de datos maestros que enumera los atributos del maestro de artículos, como el tipo de artículo, la lista de materiales, el estado, el control de serie, los números de cuenta y otros atributos. F INV Inventory Items Rapport sur les données de base qui énumère les attributs de base des articles tels que le type d'article, l'UOM, le statut, le contrôle de série, les numéros de compte et divers autres attributs I INV Inventory Items Rapporto sui dati master che elenca gli attributi master degli articoli come il tipo di articolo, UOM, stato, controllo seriale, numeri di conto e vari altri attributi JA INV Inventory Items アイテムタイプ、UOM、ステータス、シリアルコントロール、アカウント番号、その他様々な属性などのアイテムマスター属性を一覧にしたマスターデータレポート KO INV Inventory Items 품목 유형, UOM, 상태, 일련 번호 관리, 계정 번호 및 다양한 기타 속성과 같은 품목 마스터 속성을 나열하는 마스터 데이터 보고서 PTB INV Inventory Items Relatório de dados principais que lista os atributos principais do item, como tipo de item, UOM, status, controle de série, números de conta e vários outros atributos RU INV Inventory Items Отчет об основных данных, в котором перечислены основные атрибуты элемента, такие как тип элемента, UOM, статус, серийный контроль, номера счетов и различные другие атрибуты. S INV Inventory Items Huvuddatarapport som listar artikelmastattribut som artikeltyp, UOM, status, seriell kontroll, kontonummer och olika andra attribut TR INV Inventory Items Kalem tipi, UOM, durum, seri kontrol, hesap numaraları ve çeşitli diğer özellikler gibi kalem ana özelliklerini listeleyen ana veri raporu US INV Items Master data report that lists item master attributes such as item type, UOM, status, serial control, account numbers and various other attributes ZHS INV Inventory Items 主数据报告，列出物品的主属性，如物品类型、UOM、状态、序列控制、账号和其他各种属性。 Enginatics &category_columns &dff_columns 1=1 1 -10 1=1 (msiv.organization_id,msiv.inventory_item_id) in ( select distinct xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',1) organization_id, xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',2) inventory_item_id from xxen_report_run_param_values xrrpv where xrrpv.parameter_id in (select xrpv.parameter_id from xxen_report_parameters_v xrpv where xrpv.parameter_name='organization_id|inventory_item_id') and xrrpv.run_id=:run_id ) Char F organisation_id|inventory_item_id US organization_id|inventory_item_id 2 10 1=1 mp.organization_code=:organization_code LOV INV Organization Code (including master) 0B22DF18E239D64AE0630100007FBD85 Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where 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) 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 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 3 20 1=1 msiv.concatenated_segments like :item LOV custom Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments F Article US Item 4 30 1=1 upper(msiv.description) like upper(:item_descr) LOV INV Item Description (master) B8DD9131FE72F277E0530100007F06F8 Y select msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments F Description de l'article ne tient pas compte de la casse et autorise les caractères de remplacement US Item Description case insensitive and allows wildcards 5 40 1=1 msiv.item_type=xxen_util.lookup_code(:item_type,'ITEM_TYPE',3) LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code F Type d'article US Item Type 6 50 1=1 msiv.bom_item_type=:bom_item_type LOV Oracle BOM_TYPE Y select to_char(lookup_code) id, meaning value, null description from fnd_lookup_values where lookup_type='BOM_ITEM_TYPE' and language=userenv('LANG') order by value,description F Type de poste de nomenclature US BOM Item Type 7 60 1=1 nvl(msiv.item_type,'x')<>xxen_util.lookup_code(:exclude_item_type,'ITEM_TYPE',3) LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code F Exclure le type d'article US Exclude Item Type 8 70 1=1 msiv.contract_item_type_code=xxen_util.lookup_code(:contract_item_type,'OKB_CONTRACT_ITEM_TYPE',0) LOV custom Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='OKB_CONTRACT_ITEM_TYPE' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.meaning F Type d'élément du contrat US Contract Item Type 9 80 1=1 msiv.inventory_item_status_code=:item_status LOV Oracle INV_SRS_ITEM_STATUS Y select inventory_item_status_code id, inventory_item_status_code value, description description from mtl_item_status order by value,description F Statut de l'article US Item Status 10 90 1=1 msiv.buyer_id in (select ppx.person_id from per_people_x ppx where ppx.full_name=:buyer_name) LOV PO Buyer 8E2FF36EDF2F79D2E0530100007F1FF2 Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name select ppx.full_name from fnd_user fu, per_people_x ppx where 1=2 and fu.user_id=fnd_global.user_id and fu.employee_id=ppx.person_id and ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa) F Acheteur US Buyer 11 100 1=1 msiv.planner_code=:planner_code LOV INV Planner Code 8E2FF36EDEC079D2E0530100007F1FF2 Y select x.* from ( select mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by mp.planner_code ) x union all select '<null>' value, null description from dual select mp.planner_code from fnd_user fu, per_people_x ppx, mtl_planners mp where 1=2 and fu.user_id=fnd_global.user_id and fu.employee_id=mp.employee_id and nvl(mp.disable_date,sysdate+1)>=sysdate and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') F Planificateur US Planner 12 110 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=1)) US Category Set 1 13 120 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=2)) US Category Set 2 14 130 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name xxen_util.previous_parameter_value(:parameter_id) US Category Set 3 15 140 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select mic.organization_id, mic.inventory_item_id from mtl_category_sets_v mcsv, mtl_item_categories mic where mcsv.category_set_name=:category_set_name and mcsv.category_set_id=mic.category_set_id) LOV INV Category Set (restricted) 8E2FF36EDF2D79D2E0530100007F1FF2 Y select mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where mcsv.category_set_id in (select mic.category_set_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) order by mcsv.category_set_name F Ensemble de la catégorie US Category Set 16 150 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select mic.organization_id, mic.inventory_item_id from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_item_categories mic where mck.concatenated_segments=:category and mcsv.category_set_name=:category_set_name and mcsv.category_set_id=mic.category_set_id and mcsv.structure_id=mck.structure_id and mck.category_id=mic.category_id ) LOV INV Category (restricted) 8E2FF36EDF2E79D2E0530100007F1FF2 Y select mck.concatenated_segments value, mct.description from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_categories_tl mct where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mck.structure_id and (mcsv.category_set_id, mck.category_id) in (select mic.category_set_id, mic.category_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) and mck.category_id=mct.category_id and mct.language=userenv('lang') order by mck.concatenated_segments F Catégorie US Category 17 160 1=1 msiv.last_update_date>=:last_update_date_from DateTime F Date de la dernière mise à jour du US Last Update Date From 18 170 1=1 msiv.last_update_date<=:last_update_date_to DateTime F Date de la dernière mise à jour au US Last Update Date To 19 180 1=1 msiv.last_updated_by=xxen_util.user_id(:last_updated_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Dernière mise à jour par US Last Updated By 20 190 1=1 msiv.creation_date>=:creation_date_from DateTime F Date de création du US Creation Date From 21 200 1=1 msiv.creation_date<=:creation_date_to DateTime F Date de création au US Creation Date To 22 210 1=1 msiv.created_by=xxen_util.user_id(:created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Créé par US Created By 23 220 1=1 msiv.inventory_item_id in ( select mcrb.inventory_item_id from mtl_cross_references_b mcrb where mcrb.cross_reference_type=:cross_reference_type and sysdate between nvl(mcrb.start_date_active,sysdate) and nvl(mcrb.end_date_active,sysdate) ) LOV INV Cross Reference Type 8E2FF36EDEE479D2E0530100007F1FF2 Y select mcrt.cross_reference_type value, mcrt.description from mtl_cross_reference_types mcrt where sysdate<nvl(mcrt.disable_date,sysdate+1) order by mcrt.cross_reference_type F Type de référence croisée US Cross Reference Type 24 230 1=1 msiv.inventory_item_id in ( select mcrb.inventory_item_id from mtl_cross_references_b mcrb where mcrb.cross_reference=:cross_reference and mcrb.cross_reference_type=:cross_reference_type and sysdate between nvl(mcrb.start_date_active,sysdate) and nvl(mcrb.end_date_active,sysdate) ) LOV INV Cross Reference 8E2FF36EDF0079D2E0530100007F1FF2 Y select mcrv.cross_reference value, mcrv.description from mtl_cross_references_vl mcrv where (mcrv.organization_id is null or :$flex$.organization_code is null or mcrv.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and (:$flex$.cross_reference_type is null or mcrv.cross_reference_type=:$flex$.cross_reference_type) order by mcrv.cross_reference F Référence croisée US Cross Reference 25 240 1=1 mp.organization_id=mp.master_organization_id LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Maître seulement US Master only 26 250 &dff_columns select xxen_util.dff_columns(p_table_name=>'mtl_system_items_b',p_table_alias=>'msiv', p_row_id=>'row_id',p_display_mode=>:dff_display) sql_text from dual LOV custom Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') F Contexte de Flexfield US DFF Display :$flex$.category_set Category Set Category :$flex$.cross_reference_type Cross Reference Type Cross Reference :$flex$.organization_code Organization Code Buyer :$flex$.organization_code Organization Code Category Set 1 :$flex$.organization_code Organization Code Category Set 2 :$flex$.organization_code Organization Code Category Set 3 :$flex$.organization_code Organization Code Cross Reference