INV Inventory Item Upload

Description
Categories: Enginatics, Upload
Repository: Github
INV Inventory Item Upload
===================
This upload can be used to create and update Inventory Items.

It allows creation of Inventory Items:
- from an item template (Copy From Template)
- from an existing item in the same Organization (Copy From Item)
- from the same item in the Master Organization (Assign From Master)
- manually enter the Item details.

It all ... 
INV Inventory Item Upload
===================
This upload can be used to create and update Inventory Items.

It allows creation of Inventory Items:
- from an item template (Copy From Template)
- from an existing item in the same Organization (Copy From Item)
- from the same item in the Master Organization (Assign From Master)
- manually enter the Item details.

It allows update of existing Inventory Items
- to update the details of an existing inventory items, they must first be downloaded. Use the report parameters to select and download the items to be updated.

Use the pre-defined templates to restrict the Item Attributes to be displayed and updated in the report, or you define a custom template containing only the Item Attributes of interest.
   more
Run INV Inventory Item Upload and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select
null action_,
null status_,
null message_,
null request_id_,
:p_upload_mode upload_mode_,
null item_row_id,
null item_cat_row_id,
null set_process_id,
--
to_number(null) number_of_import_workers,
to_number(null) purge_interface_days,
--
msiv.concatenated_segments item,
mp.organization_code,
null assign_from_master,
null copy_from_template,
null copy_from_item,
-- Category Assignment
mcs.category_set_name category_set,
mck.concatenated_segments item_category,
-- Main
msiv.description description,
msiv.long_description long_description,
xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type,
(select mis.inventory_item_status_code_tl from mtl_item_status mis where mis.inventory_item_status_code = msiv.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 muomt.uom_code = msiv.primary_uom_code and rownum <= 1) primary_unit_of_measure,
(select muomt.unit_of_measure_tl from mtl_units_of_measure_tl muomt where muomt.uom_code = msiv.secondary_uom_code and rownum <= 1) secondary_unit_of_measure,
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,
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 ma.action_code = msiv.expiration_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 mg.grade_code = msiv.default_grade) default_grade,
----Not Visible in Form
(select mms.status_code from mtl_material_statuses mms where mms.status_id = msiv.default_material_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,
--msiv.mcc_classification_type material_classification_type,
--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 hecv.full_name from  hr_employees_current_v hecv where hecv.employee_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 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 rownum <= 1) weight_unit_of_measure,
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 rownum <= 1) volume_unit_of_measure,
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 rownum <= 1) dimension_unit_of_measure,
msiv.unit_length length,
msiv.unit_width width,
msiv.unit_height 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,
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_max_minimum_quantity,
msiv.max_minmax_quantity min_max_maximum_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_size_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_ordered,
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',