APPS.MSC_ITEM_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

    SELECT NVL(minimum_order_quantity,0),
           NVL(maximum_order_quantity,0),
	   rounding_control_type,
	   NVL(fixed_order_quantity, 0),
	   NVL(fixed_lot_multiplier, 0)
    INTO   var_minimum_order_qty,
           var_maximum_order_qty,
	   var_round,
	   var_fixed_order_qty,
	   var_fixed_lot_mult
    FROM   msc_system_items
    WHERE  inventory_item_id = arg_item_id
    AND    organization_id = arg_org_id
    AND    sr_instance_id = arg_instance_id
    AND    plan_id = arg_plan_id;