APPS.MRP_ITEM_PUB SQL Statements

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

Line: 44

    SELECT NVL(minimum_order_quantity,0),
           NVL(maximum_order_quantity,0),
	   rounding_control_type,
	   NVL(fixed_order_quantity, 0),
	   NVl(fixed_lot_multiplier,1)
    INTO   var_minimum_order_qty,
           var_maximum_order_qty,
	   var_round,
	   var_fixed_order_qty,
	   var_fixed_lot_mult
    FROM   mrp_system_items
    WHERE  inventory_item_id = arg_item_id
    AND    organization_id = arg_org_id
    AND    compile_designator = arg_compile_desig;