The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(primary_cost_method,0)
,NVL(process_enabled_flag,'N')
,NVL(wms_enabled_flag,'N')
,NVL(eam_enabled_flag,'N')
,NVL(trading_partner_org_flag,'N')
FROM mtl_parameters
WHERE organization_id = cp_organization_id;
SELECT 1 INTO l_exists
FROM ZX_OUTPUT_CLASSIFICATIONS_V
WHERE lookup_code = p_tax_code
AND enabled_flag = 'Y'
AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
AND org_id IN (p_organization_id,-99)
AND rownum = 1;
SELECT 1 INTO l_exists
FROM ZX_INPUT_CLASSIFICATIONS_V
WHERE tax_type not in ('AWT','OFFSET')
AND enabled_flag = 'Y'
AND sysdate between start_date_active and nvl(end_date_active,sysdate)
AND lookup_code = p_pur_tax_code
AND org_id IN (p_organization_id,-99)
AND rownum = 1;
SELECT 1 INTO l_exists
FROM MTL_SYSTEM_ITEMS_B
WHERE inventory_item_id = p_base_item_id
AND organization_id = p_organization_id;
SELECT A.MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID
,A.ORGANIZATION_ID ORGANIZATION_ID
,A.ORGANIZATION_CODE ORGANIZATION_CODE
,A.PRIMARY_UOM_CODE PRIMARY_UOM_CODE
,A.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
,A.STATUS STATUS
,A.ERROR_CODE ERROR_CODE
,A.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
,A.TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND
,A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND
,A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
FROM THE (SELECT CAST(p_item_org_assign_tab AS "SYSTEM".EGO_ITEM_ORG_ASSIGN_TABLE)
FROM dual) A
ORDER BY INVENTORY_ITEM_ID;
SELECT inventory_item_id
,organization_id
,revision_id
FROM MTL_ITEM_REVISIONS_B
WHERE inventory_item_id = c_inventory_item_id
AND organization_id = c_organization_id;
SELECT inventory_item_id
,organization_id
,category_set_id
,category_id
FROM MTL_ITEM_CATEGORIES
WHERE inventory_item_id = c_inventory_item_id
AND organization_id = c_organization_id;
SELECT SUM(Decode(ATTRIBUTE_NAME,'MTL_SYSTEM_ITEMS.TAX_CODE',CONTROL_LEVEL,0))
,SUM(Decode(ATTRIBUTE_NAME,'MTL_SYSTEM_ITEMS.PURCHASING_TAX_CODE',CONTROL_LEVEL,0))
FROM mtl_item_attributes
WHERE attribute_name IN ( 'MTL_SYSTEM_ITEMS.PURCHASING_TAX_CODE','MTL_SYSTEM_ITEMS.TAX_CODE');
l_item_rec.last_update_date := l_sysdate;
SELECT DECODE(l_item_rec.tracking_quantity_ind,'P',1,
DECODE(NVL(l_item_rec.secondary_default_ind,'X'),'F',2,'D',3,4))
INTO l_item_rec.DUAL_UOM_CONTROL
FROM DUAL;
l_item_rec.last_updated_by := FND_GLOBAL.User_Id;
SELECT 1 INTO l_exists
FROM ZX_OUTPUT_CLASSIFICATIONS_V
WHERE lookup_code = l_item_rec.tax_code
AND enabled_flag = 'Y'
AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
AND org_id IN (l_item_rec.organization_id,-99)
AND rownum = 1;
SELECT 1 INTO l_exists
FROM ZX_INPUT_CLASSIFICATIONS_V
WHERE lookup_code = l_item_rec.purchasing_tax_code
AND tax_type not in ('AWT','OFFSET')
AND enabled_flag = 'Y'
AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
AND org_id IN (l_item_rec.organization_id,-99)
AND rownum = 1;
SELECT encumbrance_account
,expense_account
,sales_account
,cost_of_sales_account
INTO l_item_rec.encumbrance_account
,l_item_rec.expense_account
,l_item_rec.sales_account
,l_item_rec.cost_of_sales_account
FROM mtl_parameters
WHERE organization_id = org_assign_rec.organization_id;
SELECT
b.inventory_item_id
,t.description
,t.long_description
,b.primary_uom_code
,b.allowed_units_lookup_code
,b.overcompletion_tolerance_type
,b.overcompletion_tolerance_value
,b.effectivity_control
,b.check_shortages_flag
,b.full_lead_time
,b.order_cost
,b.mrp_safety_stock_percent
,b.mrp_safety_stock_code
,b.min_minmax_quantity
,b.max_minmax_quantity
,b.minimum_order_quantity
,b.fixed_order_quantity
,b.fixed_days_supply
,b.maximum_order_quantity
,b.atp_rule_id
,b.picking_rule_id
,b.reservable_type
,b.positive_measurement_error
,b.negative_measurement_error
,b.engineering_ecn_code
,b.engineering_item_id
,b.engineering_date
,b.service_starting_delay
,b.serviceable_component_flag
,b.serviceable_product_flag
,b.payment_terms_id
,b.preventive_maintenance_flag
,b.material_billable_flag
,b.prorate_service_flag
,b.coverage_schedule_id
,b.service_duration_period_code
,b.service_duration
,b.invoiceable_item_flag
,b.tax_code
,b.invoice_enabled_flag
,b.must_use_approved_vendor_flag
,b.outside_operation_flag
,b.outside_operation_uom_type
,b.safety_stock_bucket_days
,b.auto_reduce_mps
,b.costing_enabled_flag
,b.auto_created_config_flag
,b.cycle_count_enabled_flag
,b.item_type
,b.model_config_clause_name
,b.ship_model_complete_flag
,b.mrp_planning_code
,b.return_inspection_requirement
,b.ato_forecast_control
,b.release_time_fence_code
,b.release_time_fence_days
,b.container_item_flag
,b.vehicle_item_flag
,b.maximum_load_weight
,b.minimum_fill_percent
,b.container_type_code
,b.internal_volume
,b.global_attribute_category
,b.global_attribute1
,b.global_attribute2
,b.global_attribute3
,b.global_attribute4
,b.global_attribute5
,b.global_attribute6
,b.global_attribute7
,b.global_attribute8
,b.global_attribute9
,b.global_attribute10
,b.purchasing_tax_code
,b.attribute6
,b.attribute7
,b.attribute8
,b.attribute9
,b.attribute10
,b.attribute11
,b.attribute12
,b.attribute13
,b.attribute14
,b.attribute15
,b.purchasing_item_flag
,b.shippable_item_flag
,b.customer_order_flag
,b.internal_order_flag
,b.inventory_item_flag
,b.eng_item_flag
,b.inventory_asset_flag
,b.purchasing_enabled_flag
,b.customer_order_enabled_flag
,b.internal_order_enabled_flag
,b.so_transactions_flag
,b.mtl_transactions_enabled_flag
,b.stock_enabled_flag
,b.bom_enabled_flag
,b.build_in_wip_flag
,b.revision_qty_control_code
,b.item_catalog_group_id
,b.catalog_status_flag
,b.returnable_flag
,b.default_shipping_org
,b.collateral_flag
,b.taxable_flag
,b.qty_rcv_exception_code
,b.allow_item_desc_update_flag
,b.inspection_required_flag
,b.receipt_required_flag
,b.market_price
,b.hazard_class_id
,b.rfq_required_flag
,b.qty_rcv_tolerance
,b.list_price_per_unit
,b.un_number_id
,b.price_tolerance_percent
,b.asset_category_id
,b.rounding_factor
,b.unit_of_issue
,b.enforce_ship_to_location_code
,b.allow_substitute_receipts_flag
,b.allow_unordered_receipts_flag
,b.allow_express_delivery_flag
,b.days_early_receipt_allowed
,b.days_late_receipt_allowed
,b.receipt_days_exception_code
,b.receiving_routing_id
,b.invoice_close_tolerance
,b.receive_close_tolerance
,b.auto_lot_alpha_prefix
,b.start_auto_lot_number
,b.lot_control_code
,b.shelf_life_code
,b.shelf_life_days
,b.serial_number_control_code
,b.start_auto_serial_number
,b.auto_serial_alpha_prefix
,b.source_type
,b.source_organization_id
,b.source_subinventory
,b.expense_account
,b.encumbrance_account
,b.restrict_subinventories_code
,b.unit_weight
,b.weight_uom_code
,b.volume_uom_code
,b.unit_volume
,b.restrict_locators_code
,b.location_control_code
,b.shrinkage_rate
,b.acceptable_early_days
,b.planning_time_fence_code
,b.demand_time_fence_code
,b.lead_time_lot_size
,b.std_lot_size
,b.cum_manufacturing_lead_time
,b.overrun_percentage
,b.mrp_calculate_atp_flag
,b.acceptable_rate_increase
,b.acceptable_rate_decrease
,b.cumulative_total_lead_time
,b.planning_time_fence_days
,b.demand_time_fence_days
,b.end_assembly_pegging_flag
,b.repetitive_planning_flag
,b.planning_exception_set
,b.bom_item_type
,b.pick_components_flag
,b.replenish_to_order_flag
,b.base_item_id
,b.atp_components_flag
,b.atp_flag
,b.fixed_lead_time
,b.variable_lead_time
,b.wip_supply_locator_id
,b.wip_supply_type
,b.wip_supply_subinventory
,b.cost_of_sales_account
,b.sales_account
,b.default_include_in_rollup_flag
,b.inventory_item_status_code
,b.inventory_planning_code
,b.planner_code
,b.planning_make_buy_code
,b.fixed_lot_multiplier
,b.rounding_control_type
,b.carrying_cost
,b.postprocessing_lead_time
,b.preprocessing_lead_time
,b.summary_flag
,b.enabled_flag
,b.start_date_active
,b.end_date_active
,b.buyer_id
,b.accounting_rule_id
,b.invoicing_rule_id
,b.over_shipment_tolerance
,b.under_shipment_tolerance
,b.over_return_tolerance
,b.under_return_tolerance
,b.equipment_type
,b.recovered_part_disp_code
,b.defect_tracking_on_flag
,b.event_flag
,b.electronic_flag
,b.downloadable_flag
,b.vol_discount_exempt_flag
,b.coupon_exempt_flag
,b.comms_nl_trackable_flag
,b.asset_creation_code
,b.comms_activation_reqd_flag
,b.orderable_on_web_flag
,b.back_orderable_flag
,b.web_status
,b.indivisible_flag
,b.dimension_uom_code
,b.unit_length
,b.unit_width
,b.unit_height
,b.bulk_picked_flag
,b.lot_status_enabled
,b.default_lot_status_id
,b.serial_status_enabled
,b.default_serial_status_id
,b.lot_split_enabled
,b.lot_merge_enabled
,b.inventory_carry_penalty
,b.operation_slack_penalty
,b.financing_allowed_flag
,b.eam_item_type
,b.eam_activity_type_code
,b.eam_activity_cause_code
,b.eam_act_notification_flag
,b.eam_act_shutdown_status
,b.dual_uom_control
,b.secondary_uom_code
,b.dual_uom_deviation_high
,b.dual_uom_deviation_low
,b.contract_item_type_code
,b.subscription_depend_flag
,b.serv_req_enabled_code
,b.serv_billing_enabled_flag
,b.serv_importance_level
,b.planned_inv_point_flag
,b.lot_translate_enabled
,b.default_so_source_type
,b.create_supply_flag
,b.substitution_window_code
,b.substitution_window_days
,b.ib_item_instance_class
,b.config_model_type
,b.lot_substitution_enabled
,b.minimum_license_quantity
,b.eam_activity_source_code
,b.tracking_quantity_ind
,b.ont_pricing_qty_source
,b.secondary_default_ind
,b.option_specific_sourced
,b.config_orgs
,b.config_match
,b.segment1
,b.segment2
,b.segment3
,b.segment4
,b.segment5
,b.segment6
,b.segment7
,b.segment8
,b.segment9
,b.segment10
,b.segment11
,b.segment12
,b.segment13
,b.segment14
,b.segment15
,b.segment16
,b.segment17
,b.segment18
,b.segment19
,b.segment20
,b.attribute_category
,b.attribute1
,b.attribute2
,b.attribute3
,b.attribute4
,b.attribute5
,b.created_by
,b.last_updated_by
,b.last_update_login
,b.lifecycle_id
,b.current_phase_id
,b.vmi_minimum_units
,b.vmi_minimum_days
,b.vmi_maximum_units
,b.vmi_maximum_days
,b.vmi_fixed_order_quantity
,b.so_authorization_flag
,b.consigned_flag
,b.asn_autoexpire_flag
,b.vmi_forecast_type
,b.forecast_horizon
,b.exclude_from_budget_flag
,b.critical_component_flag
,b.continous_transfer
,b.convergence
,b.divergence
,b.drp_planned_flag
,b.days_tgt_inv_supply
,b.days_tgt_inv_window
,b.days_max_inv_supply
,b.days_max_inv_window
,b.lot_divisible_flag
,b.grade_control_flag
,b.default_grade
,b.child_lot_flag
,b.parent_child_generation_flag
,b.child_lot_prefix
,b.child_lot_starting_number
,b.child_lot_validation_flag
,b.copy_lot_attribute_flag
,b.process_execution_enabled_flag
,b.process_costing_enabled_flag
,b.retest_interval
,b.expiration_action_interval
,b.expiration_action_code
,b.maturity_days
,b.hold_days
,b.process_quality_enabled_flag
,b.recipe_enabled_flag
,b.process_supply_subinventory
,b.process_supply_locator_id
,b.process_yield_subinventory
,b.process_yield_locator_id
,b.hazardous_material_flag
,b.cas_number
,b.attribute16
,b.attribute17
,b.attribute18
,b.attribute19
,b.attribute20
,b.attribute21
,b.attribute22
,b.attribute23
,b.attribute24
,b.attribute25
,b.attribute26
,b.attribute27
,b.attribute28
,b.attribute29
,b.attribute30
,b.repair_leadtime
,b.repair_yield
,b.repair_program
,b.preposition_point
,b.charge_periodicity_code
,b.outsourced_assembly
,b.subcontracting_component
,NVL(b.approval_status,'A')
INTO
p_item_rec.inventory_item_id
,p_item_rec.description
,p_item_rec.long_description
,p_item_rec.primary_uom_code
,p_item_rec.allowed_units_lookup_code
,p_item_rec.overcompletion_tolerance_type
,p_item_rec.overcompletion_tolerance_value
,p_item_rec.effectivity_control
,p_item_rec.check_shortages_flag
,p_item_rec.full_lead_time
,p_item_rec.order_cost
,p_item_rec.mrp_safety_stock_percent
,p_item_rec.mrp_safety_stock_code
,p_item_rec.min_minmax_quantity
,p_item_rec.max_minmax_quantity
,p_item_rec.minimum_order_quantity
,p_item_rec.fixed_order_quantity
,p_item_rec.fixed_days_supply
,p_item_rec.maximum_order_quantity
,p_item_rec.atp_rule_id
,p_item_rec.picking_rule_id
,p_item_rec.reservable_type
,p_item_rec.positive_measurement_error
,p_item_rec.negative_measurement_error
,p_item_rec.engineering_ecn_code
,p_item_rec.engineering_item_id
,p_item_rec.engineering_date
,p_item_rec.service_starting_delay
,p_item_rec.serviceable_component_flag
,p_item_rec.serviceable_product_flag
,p_item_rec.payment_terms_id
,p_item_rec.preventive_maintenance_flag
,p_item_rec.material_billable_flag
,p_item_rec.prorate_service_flag
,p_item_rec.coverage_schedule_id
,p_item_rec.service_duration_period_code
,p_item_rec.service_duration
,p_item_rec.invoiceable_item_flag
,p_item_rec.tax_code
,p_item_rec.invoice_enabled_flag
,p_item_rec.must_use_approved_vendor_flag
,p_item_rec.outside_operation_flag
,p_item_rec.outside_operation_uom_type
,p_item_rec.safety_stock_bucket_days
,p_item_rec.auto_reduce_mps
,p_item_rec.costing_enabled_flag
,p_item_rec.auto_created_config_flag
,p_item_rec.cycle_count_enabled_flag
,p_item_rec.item_type
,p_item_rec.model_config_clause_name
,p_item_rec.ship_model_complete_flag
,p_item_rec.mrp_planning_code
,p_item_rec.return_inspection_requirement
,p_item_rec.ato_forecast_control
,p_item_rec.release_time_fence_code
,p_item_rec.release_time_fence_days
,p_item_rec.container_item_flag
,p_item_rec.vehicle_item_flag
,p_item_rec.maximum_load_weight
,p_item_rec.minimum_fill_percent
,p_item_rec.container_type_code
,p_item_rec.internal_volume
,p_item_rec.global_attribute_category
,p_item_rec.global_attribute1
,p_item_rec.global_attribute2
,p_item_rec.global_attribute3
,p_item_rec.global_attribute4
,p_item_rec.global_attribute5
,p_item_rec.global_attribute6
,p_item_rec.global_attribute7
,p_item_rec.global_attribute8
,p_item_rec.global_attribute9
,p_item_rec.global_attribute10
,p_item_rec.purchasing_tax_code
,p_item_rec.attribute6
,p_item_rec.attribute7
,p_item_rec.attribute8
,p_item_rec.attribute9
,p_item_rec.attribute10
,p_item_rec.attribute11
,p_item_rec.attribute12
,p_item_rec.attribute13
,p_item_rec.attribute14
,p_item_rec.attribute15
,p_item_rec.purchasing_item_flag
,p_item_rec.shippable_item_flag
,p_item_rec.customer_order_flag
,p_item_rec.internal_order_flag
,p_item_rec.inventory_item_flag
,p_item_rec.eng_item_flag
,p_item_rec.inventory_asset_flag
,p_item_rec.purchasing_enabled_flag
,p_item_rec.customer_order_enabled_flag
,p_item_rec.internal_order_enabled_flag
,p_item_rec.so_transactions_flag
,p_item_rec.mtl_transactions_enabled_flag
,p_item_rec.stock_enabled_flag
,p_item_rec.bom_enabled_flag
,p_item_rec.build_in_wip_flag
,p_item_rec.revision_qty_control_code
,p_item_rec.item_catalog_group_id
,p_item_rec.catalog_status_flag
,p_item_rec.returnable_flag
,p_item_rec.default_shipping_org
,p_item_rec.collateral_flag
,p_item_rec.taxable_flag
,p_item_rec.qty_rcv_exception_code
,p_item_rec.allow_item_desc_update_flag
,p_item_rec.inspection_required_flag
,p_item_rec.receipt_required_flag
,p_item_rec.market_price
,p_item_rec.hazard_class_id
,p_item_rec.rfq_required_flag
,p_item_rec.qty_rcv_tolerance
,p_item_rec.list_price_per_unit
,p_item_rec.un_number_id
,p_item_rec.price_tolerance_percent
,p_item_rec.asset_category_id
,p_item_rec.rounding_factor
,p_item_rec.unit_of_issue
,p_item_rec.enforce_ship_to_location_code
,p_item_rec.allow_substitute_receipts_flag
,p_item_rec.allow_unordered_receipts_flag
,p_item_rec.allow_express_delivery_flag
,p_item_rec.days_early_receipt_allowed
,p_item_rec.days_late_receipt_allowed
,p_item_rec.receipt_days_exception_code
,p_item_rec.receiving_routing_id
,p_item_rec.invoice_close_tolerance
,p_item_rec.receive_close_tolerance
,p_item_rec.auto_lot_alpha_prefix
,p_item_rec.start_auto_lot_number
,p_item_rec.lot_control_code
,p_item_rec.shelf_life_code
,p_item_rec.shelf_life_days
,p_item_rec.serial_number_control_code
,p_item_rec.start_auto_serial_number
,p_item_rec.auto_serial_alpha_prefix
,p_item_rec.source_type
,p_item_rec.source_organization_id
,p_item_rec.source_subinventory
,p_item_rec.expense_account
,p_item_rec.encumbrance_account
,p_item_rec.restrict_subinventories_code
,p_item_rec.unit_weight
,p_item_rec.weight_uom_code
,p_item_rec.volume_uom_code
,p_item_rec.unit_volume
,p_item_rec.restrict_locators_code
,p_item_rec.location_control_code
,p_item_rec.shrinkage_rate
,p_item_rec.acceptable_early_days
,p_item_rec.planning_time_fence_code
,p_item_rec.demand_time_fence_code
,p_item_rec.lead_time_lot_size
,p_item_rec.std_lot_size
,p_item_rec.cum_manufacturing_lead_time
,p_item_rec.overrun_percentage
,p_item_rec.mrp_calculate_atp_flag
,p_item_rec.acceptable_rate_increase
,p_item_rec.acceptable_rate_decrease
,p_item_rec.cumulative_total_lead_time
,p_item_rec.planning_time_fence_days
,p_item_rec.demand_time_fence_days
,p_item_rec.end_assembly_pegging_flag
,p_item_rec.repetitive_planning_flag
,p_item_rec.planning_exception_set
,p_item_rec.bom_item_type
,p_item_rec.pick_components_flag
,p_item_rec.replenish_to_order_flag
,p_item_rec.base_item_id
,p_item_rec.atp_components_flag
,p_item_rec.atp_flag
,p_item_rec.fixed_lead_time
,p_item_rec.variable_lead_time
,p_item_rec.wip_supply_locator_id
,p_item_rec.wip_supply_type
,p_item_rec.wip_supply_subinventory
,p_item_rec.cost_of_sales_account
,p_item_rec.sales_account
,p_item_rec.default_include_in_rollup_flag
,p_item_rec.inventory_item_status_code
,p_item_rec.inventory_planning_code
,p_item_rec.planner_code
,p_item_rec.planning_make_buy_code
,p_item_rec.fixed_lot_multiplier
,p_item_rec.rounding_control_type
,p_item_rec.carrying_cost
,p_item_rec.postprocessing_lead_time
,p_item_rec.preprocessing_lead_time
,p_item_rec.summary_flag
,p_item_rec.enabled_flag
,p_item_rec.start_date_active
,p_item_rec.end_date_active
,p_item_rec.buyer_id
,p_item_rec.accounting_rule_id
,p_item_rec.invoicing_rule_id
,p_item_rec.over_shipment_tolerance
,p_item_rec.under_shipment_tolerance
,p_item_rec.over_return_tolerance
,p_item_rec.under_return_tolerance
,p_item_rec.equipment_type
,p_item_rec.recovered_part_disp_code
,p_item_rec.defect_tracking_on_flag
,p_item_rec.event_flag
,p_item_rec.electronic_flag
,p_item_rec.downloadable_flag
,p_item_rec.vol_discount_exempt_flag
,p_item_rec.coupon_exempt_flag
,p_item_rec.comms_nl_trackable_flag
,p_item_rec.asset_creation_code
,p_item_rec.comms_activation_reqd_flag
,p_item_rec.orderable_on_web_flag
,p_item_rec.back_orderable_flag
,p_item_rec.web_status
,p_item_rec.indivisible_flag
,p_item_rec.dimension_uom_code
,p_item_rec.unit_length
,p_item_rec.unit_width
,p_item_rec.unit_height
,p_item_rec.bulk_picked_flag
,p_item_rec.lot_status_enabled
,p_item_rec.default_lot_status_id
,p_item_rec.serial_status_enabled
,p_item_rec.default_serial_status_id
,p_item_rec.lot_split_enabled
,p_item_rec.lot_merge_enabled
,p_item_rec.inventory_carry_penalty
,p_item_rec.operation_slack_penalty
,p_item_rec.financing_allowed_flag
,p_item_rec.eam_item_type
,p_item_rec.eam_activity_type_code
,p_item_rec.eam_activity_cause_code
,p_item_rec.eam_act_notification_flag
,p_item_rec.eam_act_shutdown_status
,p_item_rec.dual_uom_control
,p_item_rec.secondary_uom_code
,p_item_rec.dual_uom_deviation_high
,p_item_rec.dual_uom_deviation_low
,p_item_rec.contract_item_type_code
,p_item_rec.subscription_depend_flag
,p_item_rec.serv_req_enabled_code
,p_item_rec.serv_billing_enabled_flag
,p_item_rec.serv_importance_level
,p_item_rec.planned_inv_point_flag
,p_item_rec.lot_translate_enabled
,p_item_rec.default_so_source_type
,p_item_rec.create_supply_flag
,p_item_rec.substitution_window_code
,p_item_rec.substitution_window_days
,p_item_rec.ib_item_instance_class
,p_item_rec.config_model_type
,p_item_rec.lot_substitution_enabled
,p_item_rec.minimum_license_quantity
,p_item_rec.eam_activity_source_code
,p_item_rec.tracking_quantity_ind
,p_item_rec.ont_pricing_qty_source
,p_item_rec.secondary_default_ind
,p_item_rec.option_specific_sourced
,p_item_rec.config_orgs
,p_item_rec.config_match
,p_item_rec.segment1
,p_item_rec.segment2
,p_item_rec.segment3
,p_item_rec.segment4
,p_item_rec.segment5
,p_item_rec.segment6
,p_item_rec.segment7
,p_item_rec.segment8
,p_item_rec.segment9
,p_item_rec.segment10
,p_item_rec.segment11
,p_item_rec.segment12
,p_item_rec.segment13
,p_item_rec.segment14
,p_item_rec.segment15
,p_item_rec.segment16
,p_item_rec.segment17
,p_item_rec.segment18
,p_item_rec.segment19
,p_item_rec.segment20
,p_item_rec.attribute_category
,p_item_rec.attribute1
,p_item_rec.attribute2
,p_item_rec.attribute3
,p_item_rec.attribute4
,p_item_rec.attribute5
,p_item_rec.created_by
,p_item_rec.last_updated_by
,p_item_rec.last_update_login
,p_item_rec.lifecycle_id
,p_item_rec.current_phase_id
,p_item_rec.vmi_minimum_units
,p_item_rec.vmi_minimum_days
,p_item_rec.vmi_maximum_units
,p_item_rec.vmi_maximum_days
,p_item_rec.vmi_fixed_order_quantity
,p_item_rec.so_authorization_flag
,p_item_rec.consigned_flag
,p_item_rec.asn_autoexpire_flag
,p_item_rec.vmi_forecast_type
,p_item_rec.forecast_horizon
,p_item_rec.exclude_from_budget_flag
,p_item_rec.critical_component_flag
,p_item_rec.continous_transfer
,p_item_rec.convergence
,p_item_rec.divergence
,p_item_rec.drp_planned_flag
,p_item_rec.days_tgt_inv_supply
,p_item_rec.days_tgt_inv_window
,p_item_rec.days_max_inv_supply
,p_item_rec.days_max_inv_window
,p_item_rec.lot_divisible_flag
,p_item_rec.grade_control_flag
,p_item_rec.default_grade
,p_item_rec.child_lot_flag
,p_item_rec.parent_child_generation_flag
,p_item_rec.child_lot_prefix
,p_item_rec.child_lot_starting_number
,p_item_rec.child_lot_validation_flag
,p_item_rec.copy_lot_attribute_flag
,p_item_rec.process_execution_enabled_flag
,p_item_rec.process_costing_enabled_flag
,p_item_rec.retest_interval
,p_item_rec.expiration_action_interval
,p_item_rec.expiration_action_code
,p_item_rec.maturity_days
,p_item_rec.hold_days
,p_item_rec.process_quality_enabled_flag
,p_item_rec.recipe_enabled_flag
,p_item_rec.process_supply_subinventory
,p_item_rec.process_supply_locator_id
,p_item_rec.process_yield_subinventory
,p_item_rec.process_yield_locator_id
,p_item_rec.hazardous_material_flag
,p_item_rec.cas_number
,p_item_rec.attribute16
,p_item_rec.attribute17
,p_item_rec.attribute18
,p_item_rec.attribute19
,p_item_rec.attribute20
,p_item_rec.attribute21
,p_item_rec.attribute22
,p_item_rec.attribute23
,p_item_rec.attribute24
,p_item_rec.attribute25
,p_item_rec.attribute26
,p_item_rec.attribute27
,p_item_rec.attribute28
,p_item_rec.attribute29
,p_item_rec.attribute30
,p_item_rec.repair_leadtime
,p_item_rec.repair_yield
,p_item_rec.repair_program
,p_item_rec.preposition_point
,p_item_rec.charge_periodicity_code
,p_item_rec.outsourced_assembly
,p_item_rec.subcontracting_component
,x_master_status
FROM mtl_system_items_b b, mtl_system_items_tl t
WHERE b.inventory_item_id = t.inventory_item_id
AND b.organization_id = t.organization_id
AND b.inventory_item_id = p_item_rec.inventory_item_id
AND b.organization_id = p_master_org_id
AND t.language = userenv('LANG');
/* SELECT DECODE(p_item_rec.tracking_quantity_ind,'P',1,
DECODE(NVL(p_item_rec.secondary_default_ind,'X'),'F',2,'D',3,4))
INTO p_item_rec.DUAL_UOM_CONTROL
FROM DUAL; */